[samwillis]

ElectricSQL are in this space, and have the concept of a central source of truth. SQLite in the browser and Postgres on the server with two way syncing using CRDTs. All open source but backed and funded.

https://electric-sql.com/

I'm not convinced that separating the two tools is best for usability, loose coupling sure. But some level of integration enables the reactive front end querying to swap between the front end copy and central source depending on if you have the data copied locally.

Also many of the mechanisms needed for reactive re-querying are also needed for two way syncing.

[maccaw]

The trouble with coupling the two is that now I have to either trust some third party db service, or some custom db.

The DB is so fundamental, and so hard to get right / scale, that it's hard to trust a startup to do it well.

We use Firebase and even with all the resources google has this has a lot of issues (especially with the client libs).