3 ms·

With a small bit of tweaking this could be used for syncing live SQLite databases (probably)

• linsomniac 4y ago
  Shouldn't require any tweaking, the sliding window should be able to work on sqlite files just as well as the game content files used in this article. If you want something smarter and very much more sqlite optimized, you probably want to look at litefs. https://github.com/superfly/litefs https://github.com/superfly/litefs
• josephg 4y ago
  The problem is conflicts. If two remote peers both edit data concurrently, its not obvious what the resulting sqlite state should be. Better to embed a CRDT inside sqlite that can understand the semantics of sqlite's data, like cr-sqlite is doing: https://github.com/vlcn-io/cr-sqlite https://github.com/vlcn-io/cr-sqlite
• manigandham 4y ago
  You can use Litestream which is purpose built for streaming SQLite database replicas: https://litestream.io/ https://litestream.io/