Could you please consider adding support for rqlite?
It’s essentially using multiple sqlite databases and adds replications between them to the application layer using RAFT consensus, removeing the need to have RWX volumes when e.g. running on a Kubernetes cluster.
Easy to setup. Reliable. Probably fast enough for most use cases. And since you already support the sqlite dialect adding support should be no more then adding a new connection string for rqlite via env vars.