News for hackers. Stuff that matters.
Re:SQLite is not a toy database by jakoblorz on Thursday March 25, 2021 @02:11PM (#26583486)
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).