Re:SQLite is not a toy database
by gwd on Thursday March 25, 2021 @11:45AM
(#26581691)
I just looked, and the entire database for my webapp (which typically serves around ~50 people) is 139k. As you say, you can do a data dump quickly and safely; at that size, you could afford to just dump the entire DB every hour and keep the last year's worth of snapshots if you wanted.
[ Parent
| on HN ]
https://litestream.io/
That's exactly what litestream accomplishes.
Re:SQLite is not a toy database
by benbjohnson on Thursday March 25, 2021 @02:18PM
(#26583558)
That's close. Litestream takes a snapshot of the database and then continuously replicates out WAL frames. On restore, it grabs the snapshot and replays all those WAL frames (or all the frames up to a certain time if you want point-in-time recovery).