top | item 41968986

(no title)

rrevi | 1 year ago

Which now begs the question, sqlite3_rsync vs Litestream[0]?

[0] https://litestream.io/

discuss

order

zimpenfish|1 year ago

Why 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|1 year ago

Looks like Litestream streams changes but sqlite3_rsync only updates a snapshot at the time it was called.