SQLite Rsync: Database Remote-Copy Tool for SQLite
1–10 of 13 posts
Re: SQLite Rsync: Database Remote-Copy Tool for SQLite
#2Thank you very much.
It would be useful to have dates for created and for edited on the articles. With the huge scope of the SQLite project, I have no idea whether this is historical, current, or upcoming.
Re: SQLite Rsync: Database Remote-Copy Tool for SQLite
#3It seems I have some scripts to update today
Re: SQLite Rsync: Database Remote-Copy Tool for SQLite
#4Thank you very much. It would be useful to have dates for created and for edited on the articles. With the huge scope of the SQLite project, I have no idea whether this is historical, current, or upcoming.
History on the SQLite repo seems to say this was added Sep 10, 2024
https://github.com/sqlite/sqlite/commit/a9c8f7cf34545f410e94...
Re: SQLite Rsync: Database Remote-Copy Tool for SQLite
#5Thank you very much. It would be useful to have dates for created and for edited on the articles. With the huge scope of the SQLite project, I have no idea whether this is historical, current, or upcoming.
History on the SQLite repo seems to say this was added Sep 10, 2024 https://github.com/sqlite/sqlite/commit/a9c8f7cf34545f410e94...
And made it to the news section of the SQLite site on Oct. 21st 2024:
Re: SQLite Rsync: Database Remote-Copy Tool for SQLite
#6This is great, could be useful for keeping a standby up to date with a systemd timer/cron.
Re: SQLite Rsync: Database Remote-Copy Tool for SQLite
#7Fantastic, looks like something I need! Some questions in case someone knows:
- is the source DB blocked in any way when this is running? E.g. is this like an ordinary read, or something different? I know WAL mode gives more concurrency but still writes are queued up in the wal file during a long read
- can this operate on a ~continuous basis? Or can I run it every few mins?
Thanks!
Re: SQLite Rsync: Database Remote-Copy Tool for SQLite
#8Which now begs the question, sqlite3_rsync vs Litestream[0]?
Re: SQLite Rsync: Database Remote-Copy Tool for SQLite
#9Which now begs the question, sqlite3_rsync vs Litestream[0]? [0] https://litestream.io/
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.
Re: SQLite Rsync: Database Remote-Copy Tool for SQLite
#10Which now begs the question, sqlite3_rsync vs Litestream[0]? [0] https://litestream.io/
Looks like Litestream streams changes but sqlite3_rsync only updates a snapshot at the time it was called.