SQLite added an rsync command

The new sqlite3_rsync command can create a REPLICA of an SQLite database:

$ sqlite3_rsync ORIGIN REPLICA ?OPTIONS?

But why not simply use the rsync command?

The reason is that ordinary rsync does not understand SQLite transactions, can lead to a corrupted copy depending on the database active transactions.


Leave a comment

Discover more from /root

Subscribe now to keep reading and get access to the full archive.

Continue reading