(via) Neat new SQLite utilities often show up in branches of the SQLite repository. Here’s a new one from last month: sqlite3-rsync, providing tools for efficiently creating and updating copies of WAL-mode SQLite databases on either the same machine or across remote machines via SSH. (View Highlight)
The tool takes full advantage of SQLite’s WAL mode - when you run it you’ll get an exact snapshot of the database state as it existed at the moment the copy was initiated, even if the source database continues to apply changes. (View Highlight)