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.
[ Parent
| on HN ]
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).