Thank you very much.<p>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.
Fantastic, looks like something I need! Some questions in case someone knows:<p>- 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<p>- can this operate on a ~continuous basis? Or can I run it every few mins?<p>Thanks!
checkout Simon Willison's notes if you want to know how to get this running and try: <a href="https://til.simonwillison.net/sqlite/compile-sqlite3-rsync" rel="nofollow">https://til.simonwillison.net/sqlite/compile-sqlite3-rsync</a>
Which now begs the question, sqlite3_rsync vs Litestream[0]?<p>[0] <a href="https://litestream.io/" rel="nofollow">https://litestream.io/</a>