News for hackers. Stuff that matters.

A comment on Cron-based backup for SQLite. Parent comment

Re:Cron-based backup for SQLite by simonw on Sunday May 15, 2022 @09:56AM (#31387588)
This comment cleared that up for me: VACUUM INTO backups are transactional, but the .backup mechanism is not: https://news.ycombinator.com/item?id=31387556

Ben I suggest updating that cron backups documentation page to recommend VACUUM INTO instead!

[ Parent | on HN ]
Re:Cron-based backup for SQLite by ignoramous on Sunday May 15, 2022 @10:28AM (#31387754)
Could start an issue: https://github.com/benbjohnson/litestream.io/issues
[ Parent | on HN ]
Re:Cron-based backup for SQLite by benbjohnson on Sunday May 15, 2022 @11:32AM (#31388167)
Good catch. I went ahead and added an issue on the docs. https://github.com/benbjohnson/litestream.io/issues/56
[ Parent | on HN ]