Bidirectional streaming? #10
-
Thank you for creating this. Definitely nicer than scheduled rsync tasks :) I was wondering if it is possible to use it in a bidirectional way so having e.g. two servers receiving (mostly distinct but not always) data, syncing to each other. Or will this most likely result in inconsistencies or crashes? |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment 5 replies
-
Hi Marc. 👋 Unfortunately, I don't think Litestream would be a good fit for that. Litestream works by replicating whole physical pages of the database so it would potentially overwrite updates if they were on the same page from each database. Have you looked at using the SQLite session extention to exchange changesets between databases? |
Beta Was this translation helpful? Give feedback.
Hi Marc. 👋
Unfortunately, I don't think Litestream would be a good fit for that. Litestream works by replicating whole physical pages of the database so it would potentially overwrite updates if they were on the same page from each database.
Have you looked at using the SQLite session extention to exchange changesets between databases?