4 ms·
> I love being able to backup by just doing a VACUUM INTO and then copying the resulting single file. Naively, I would probably just copy the sqlite file. Is t
by jszymborski 9mo ago
> I love being able to backup by just doing a VACUUM INTO and then copying the resulting single file.
Naively, I would probably just copy the sqlite file. Is that a bad idea?
- amanzi 9mo agoI learned about the VACUUM INTO command through the following guide on how to backup your sqlite database: https://litestream.io/alternatives/cron/ https://litestream.io/alternatives/cron/
- simonw 9mo agoThat's fine if SQLite isn't running, but you risk corruption if you copy a file while it is being actively written to. VACUUM INTO eliminates that risk.
- modo_mario 9mo agoThank you for mentioning this. I was planning to do exactly this soon and had no idea.