TIL the author of SQLite wrote a tool called sqlite3_rsync that can be used to copy one database across machines. It does so incrementally like rsync while preserving the integrity of the database so both the source and the replica databases are safe to use when copying.

Analyze the bytes in a SQL database.

Valuable SQLite tips for the use on a production servers.