使用 Homebrew 安装 sqlite-rsync

项目链接

• 主页

命令和别名

• sqlite3_rsync

项目历史

The SQLite documentation describes sqlite3_rsync as a tool that makes a replica database become a copy of an origin database. It is part of the SQLite ecosystem and uses a bandwidth-efficient protocol similar to rsync while preserving SQLite consistency semantics.

采用历史

The input identifies a Homebrew formula named `sqlite-rsync`, reflecting the tool's packaging as a standalone command. SQLite's own documentation says the executable must be on PATH locally and, for remote synchronization, on the remote system's SSH PATH as well.

使用方式

The basic command shape is `sqlite3_rsync ORIGIN REPLICA`. One side can use `USER@HOST:PATH`, SSH is used for communication, and the tool can copy from a live origin database while producing a consistent snapshot.

为什么软件包爱好者会关心

Package nerds care because sqlite3_rsync fills a sharp operational gap: it gives SQLite users an installable CLI for safe, efficient database copies where generic rsync may produce inconsistent or corrupt results against a changing database.

时间线

• 2025: SQLite 3.50.0 removed earlier WAL-mode and same-page-size limitations from sqlite3_rsync.
• 2025: SQLite documentation notes protocol improvements in 3.50.0 that reduce bandwidth when origin and replica are already similar.
• Current: Homebrew packages the tool as `sqlite-rsync`.

Related projects

• sqlite3_rsync is related to SQLite itself and to rsync conceptually, but its protocol and consistency behavior are SQLite-specific.

来源

• https://www.sqlite.org/rsync.html - official sqlite3_rsync documentation.
• https://www.sqlite.org/src - official SQLite source repository.
• source_facts.package-manager.brew - Homebrew formula name supplied in input.