DB with SQLite

[gedw99]

I use Sqlite with GORM and then use NATS to make the DB multi master using Marmot.

https://github.com/maxpert/marmot
https://github.com/maxpert/marmot/tree/master/examples

Perf is very high. Thats because we just removed a TCP layer between the middle tier and MariaDB. SQLite is running in the same process. You can also use https://github.com/zombiezen/go-sqlite if you really want Process isolation too.

Marmot uses NATS Jetstream to do Multi master replication.
There is NO changes to the middle tier or the SQL code.
The DB writes to SQL, and Marmot then propagate the change to the other nodes.
And visa verse from others nodes too.
Its uses a simple CRDT Last write Wins to achieve the Multi Master.
Been running it for Pocketbase for ages and so issues.

Marmot not yet support SQL migrations I real time, so I just do a basic stop the world for 2 seconds normally.

• Have middle tier tell NATS / Maermti that we want to migrate.
• NATS then tells Marmot to stop the world. It just makes eusre all nodes are up to each other.
• SQL migration happens to local DB and then out to other DBS via NATS and Marmot
• NATS then starts the world and tells the middle tiers all is fine.