News for hackers. Stuff that matters.
Re:LiteFS Cloud: Distributed SQLite with Managed Backups by Mertax on Wednesday July 05, 2023 @05:27PM (#36607397)
In scenarios where an individual customer/tenant can have isolated data this makes sense. Is there any reason why the client application itself can't be one of the nodes in the distributed system? Does LiteFS support a more peer-2-peer distribution model (similar to a git repo) where the client/customer's SQLite database is fully distributed to them and then it's just a matter of merging diffs?
Re:LiteFS Cloud: Distributed SQLite with Managed Backups by benbjohnson on Wednesday July 05, 2023 @05:37PM (#36607519)
No, LiteFS just does physical page replication. We don't really have a way to do merge conflict resolution between two nodes. You may want to look at either vlcn[1] or Mycelite[2] as options for doing that approach.

[1]: https://github.com/vlcn-io/cr-sqlite

[2]: https://github.com/mycelial/mycelite