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?
[ Parent
| on HN ]
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.