3 ms·
In Oracle, I can do this: RECOVER DATABASE UNTIL TIME '2021-10-01 02:00:00' USING BACKUP CONTROLFILE; SQLite does not implement such a feature.
by chasil 5y ago
In Oracle, I can do this:
RECOVER DATABASE UNTIL TIME '2021-10-01 02:00:00' USING BACKUP CONTROLFILE;
SQLite does not implement such a feature.
- srcreigh 5y agoThere is a diff tool [0], and an online backup tool [1]. That kinda thing should be pretty easy to cobble together. You'll just need ~3x disk space to store 2 backups at an interval, diff them and discard the older backup, then apply backward diffs on your most recent backup to achieve a specific backup time. EDIT: or maybe the Session Extension [2] [0]: https://www.sqlite.org/sqldiff.html https://www.sqlite.org/sqldiff.html [1]: https://www.sqlite.org/backup.html https://www.sqlite.org/backup.html [2]: https://www.sqlite.org/sessionintro.html https://www.sqlite.org/sessionintro.html
- simonw 5y agoLitestream may be able to do that on top of SQLite: https://litestream.io https://litestream.io See the -timestamp option here: https://litestream.io/reference/restore/ https://litestream.io/reference/restore/