4 ms·
SQLite Rsync: Database Remote-Copy Tool for SQLite
- vanous 2y agoThank 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.
- unsnap_biceps 2y agoHistory on the SQLite repo seems to say this was added Sep 10, 2024 https://github.com/sqlite/sqlite/commit/a9c8f7cf34545f410e947b59b8298633324bde97 https://github.com/sqlite/sqlite/commit/a9c8f7cf34545f410e94...
- rrevi 2y agoAnd made it to the news section of the SQLite site on Oct. 21st 2024: https://sqlite.org/news.html https://sqlite.org/news.html
- ollybee 2y agoIt seems I have some scripts to update today
- config_yml 2y agoThis is great, could be useful for keeping a standby up to date with a systemd timer/cron.
- rich_sasha 2y agoFantastic, 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!
- zimpenfish 2y ago> is the source DB blocked in any way when this is running? Doesn't sound like it: "If other processes change the content of ORIGIN while this command is running, those changes will be applied to ORIGIN, but they are not transferred to REPLICA" Sounds like it uses the internal snapshot mechanism[0] and replicates that. [0] https://www.sqlite.org/c3ref/snapshot.html https://www.sqlite.org/c3ref/snapshot.html
- rrevi 2y agoWhich 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.
- deleted 2y ago[deleted]
- avinassh 2y agocheckout Simon Willison's notes if you want to know how to get this running and try: https://til.simonwillison.net/sqlite/compile-sqlite3-rsync https://til.simonwillison.net/sqlite/compile-sqlite3-rsync