News for hackers. Stuff that matters.
Re:Consider SQLite by masklinn on Wednesday December 29, 2021 @02:13PM (#29728707)
> modulo write ahead journal and whatnot

That's like saying immortality is trivial modulo death and whatnot. If you don't integrate with sqlite's locking system, you can easily "backup" a file mid-write, corrupted and unusable.

That's why sqlite has a built-in backup command.

Re:Consider SQLite by jks on Wednesday December 29, 2021 @10:12PM (#29733100)
Litestream does streaming backups using a separate process: https://litestream.io/
Re:Consider SQLite by lrem on Wednesday December 29, 2021 @03:49PM (#29729831)
I guess my secret is having almost no writes (the couple things I deployed with SQLite would see a dozen writes per month).