We are singing from the same song sheet.

SQLite in the browser and at the edge is going to explode in popularity. A slightly unknown feature of SQLite is “sessions” which would allow you to build an eventually consistent system on top of SQLite.

https://www.sqlite.org/sessionintro.html

I can very much see SAAS type apps wheee each costumer/workplace has a SQLite db effectively deployed to the edge.

This is the biggest question actually.

Something like cockroachdb's serverless might fit too: https://www.cockroachlabs.com/blog/how-we-built-cockroachdb-...