News for hackers. Stuff that matters.

A comment on Using SQLite as storage for web server static content. Parent comment

Re:Using SQLite as storage for web server static content by simonw on Sunday October 27, 2024 @03:01PM (#41964760)
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
[ Parent | on HN ]
Re:Using SQLite as storage for web server static content by webstrand on Sunday October 27, 2024 @03:22PM (#41964918)
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.

[ Parent | on HN ]
Re:Using SQLite as storage for web server static content by simonw on Sunday October 27, 2024 @06:23PM (#41966174)
If you want incremental backups to S3 I recommend Litestream.
[ Parent | on HN ]