> But a group of N sqlite databases is an N-writer database. And mvsqlite provides the necessary mechanisms to do serializable cross-database transactions without additional overhead.
I'm confused, are these databases planned to be replicated? Or is it expected for the databases to have separate schemas?
Replication is handled by FDB so you don't need to care about it on the application level. These databases can contain partitioned data of your application, like one DB per user, so that a transaction on only user A and another one on only user B won't conflict.
I'm confused, are these databases planned to be replicated? Or is it expected for the databases to have separate schemas?