3 ms·
SQLite backups aren't quite that easy. Grabbing a copy of the file won't necessarily work: you need at atomic snapshot. You can create those using the backup A
by simonw 4y ago
SQLite backups aren't quite that easy.
Grabbing a copy of the file won't necessarily work: you need at atomic snapshot. You can create those using the backup API or by using VACUUM INTO, but in both cases you'll need enough spare disk space to create a fresh copy of your database.
I'm having great results from Litestream streaming to S3, so that's definitely a good option here.
- rtpg 4y agoThat is a very good point! Obviously a lot of stuff is easier if you just allow yourself downtime, but at one point the file gets big enough to where this matters.