Re:Consider SQLite
by chasil on Wednesday December 29, 2021 @02:11PM
(#29728692)
In Oracle, I can do this:
SQLite does not implement such a feature.
[ Parent
| on HN ]
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
Litestream may be able to do that on top of SQLite: https://litestream.io
See the -timestamp option here: https://litestream.io/reference/restore/