[gedw99]

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