11 ms·
Which now begs the question, sqlite3_rsync vs Litestream[0]? [0] https://litestream.io/ https://litestream.io/
by rrevi 2y ago
Which now begs the question, sqlite3_rsync vs Litestream[0]?
[0] https://litestream.io/ https://litestream.io/
- zimpenfish 2y agoWhy not both? They solve different problems, after all. I'm currently using `litestream` for backups but I might add `sqlite3_rsync` as a point-in-time replica for things that benefit from "remote" sqlite access - easier than restoring a version from `litestream`, safer than copying it myself, and a lot easier than transporting changes over NATS / HTTP / whatnot.
- kgeist 2y agoLooks like Litestream streams changes but sqlite3_rsync only updates a snapshot at the time it was called.