News for hackers. Stuff that matters.

A comment on SQLite Rsync: Database Remote-Copy Tool for SQLite.

Re:SQLite Rsync: Database Remote-Copy Tool for SQLite by rrevi on Monday October 28, 2024 @04:55AM (#41968986)
Which now begs the question, sqlite3_rsync vs Litestream[0]?

[0] https://litestream.io/

[ Parent | on HN ]
Re:SQLite Rsync: Database Remote-Copy Tool for SQLite by zimpenfish on Monday October 28, 2024 @05:28AM (#41969217)
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.

[ Parent | on HN ]
Re:SQLite Rsync: Database Remote-Copy Tool for SQLite by kgeist on Monday October 28, 2024 @05:50AM (#41969370)
Looks like Litestream streams changes but sqlite3_rsync only updates a snapshot at the time it was called.
[ Parent | on HN ]