Install sqlite-rsync with Homebrew

Project links

• Homepage

Commands and aliases

• sqlite3_rsync

Project history

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.

Adoption history

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.

How it is used

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.

Why package nerds care

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.

Timeline

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

Sources

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