1 comments
<a href="https://github.com/nsrht/time-travel-sqlite-debugger/blob/main/watcher.php" rel="nofollow">https://github.com/nsrht/time-travel-sqlite-debugger/blob/ma...</a> works by checking the mtime on the database file (and -wal file) once per second and creating a backups/unixtime_database.sqlite file if anything has changed, then keeps the last 50 copies.<p>So OK for smaller database files but not great if you're pushing into a GB+ of data.<p>I'm not convinced by the way it copies the files - I think using a "vacuum into" backup would be safer then file copies.<p>Litestream offers point-in-time recovery for SQLite by backing up chunks of WAL directly, which I expect is a lot more efficient than this mechanism.