I use marmot which gives me a multi master SQLite. It uses a simple crdt table structure, and allows me to have many live SQLite instances in all data enters.

I use marmot which gives me a multi master SQLite. It uses a simple crdt table structure, and allows me to have many live SQLite instances in all data enters. A Nat Jetstream server is used as a core with all SQLite DBS connected to it. It operates off the WAL and is simple to install. It also replicates all blobs to S3 , with the directory structure in the SQLite db. With a Cloudflare domain , the users request is automatically sent to the nearest Db. So it replaces cloudscapes D1 system for free . Just a hetzner 4 euro cos is enough. Mine is holding about 200 gb of data. https://github.com/maxpert/marmot https://github.com/maxpert/marmot