3 ms·

You might like the new sqlite3_rsync command https://www.sqlite.org/rsync.html https://www.sqlite.org/rsync.html

• simonw 2y ago
  Yeah that looks ideal for this exact problem, because it lets you stream a snapshot backup of a SQLite over SSH without needing to first create a duplicate copy using .backup or vacuum. My notes here: https://til.simonwillison.net/sqlite/compile-sqlite3-rsync https://til.simonwillison.net/sqlite/compile-sqlite3-rsync
  • webstrand 2y ago
    Maybe that tool just doesn't fit my use-case, but I'm not sure how you'd use it to do incremental backups? I store all of my backups in S3 Glacier for the cheap storage, so there's nothing for me to rsync onto. I can see how you'd use it for replication though.
    • simonw 2y ago
      If you want incremental backups to S3 I recommend Litestream.