News for hackers. Stuff that matters.
Re:Consider SQLite by chasil on Wednesday December 29, 2021 @02:11PM (#29728692)
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.
Re:Consider SQLite by srcreigh on Wednesday December 29, 2021 @02:20PM (#29728821)
There 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

[1]: https://www.sqlite.org/backup.html

[2]: https://www.sqlite.org/sessionintro.html

Re:Consider SQLite by simonw on Wednesday December 29, 2021 @06:47PM (#29731643)
Litestream may be able to do that on top of SQLite: https://litestream.io

See the -timestamp option here: https://litestream.io/reference/restore/