top | item 32014778

(no title)

phlyingpenguin | 3 years ago

It doesn't appear to be doing much more than replication though. https://litestream.io does that for sqlite already. (Edit for clarity) GitDB seem to have more "distributed" ideas in their roadmap for v3 maybe.

discuss

order

uniqueuid|3 years ago

Litestream is awesome, but I don't see that it enables multi-way merges yet. Am I wrong?

benbjohnson|3 years ago

Litestream author here. You're correct. Also, there's no plans for multi-master replication right now. I do think it'd be an interesting project to make a eventually consistent distributed database using the SQLite session extension[1] but I haven't put much thought into that.

[1]: https://www.sqlite.org/sessionintro.html

phlyingpenguin|3 years ago

GitDB also doesn't handle merge conflicts, so I'm not convinced it would handle multiple clients well. The It's again marked as something they might do in the future someday. I suspect this is pretty fragile. (Note: I was _not_ claiming litestream would do such a thing. Just replication.)

qbasic_forever|3 years ago

Are you sure you want to use sqlite if your workload is mostly multiple, independent writers?