sqlite-rsync を Homebrew でインストール

プロジェクトリンク

• ホームページ

コマンドとエイリアス

• 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.