Think you'd really enjoy exploring Electric SQL (https://electric-sql.com/blog/2023/08/14/introducing-electricsql-v0.5 https://electric-sql.com/blog/2023/08/14/

Think you'd really enjoy exploring Electric SQL (https://electric-sql.com/blog/2023/08/14/introducing-electricsql-v0.5 https://electric-sql.com/blog/2023/08/14/introducing-electri...). They're syncing client-side SQLite to server-side Postgres on backend via an Erlang service that enables bi-directional active-active replication. They have a little more work to go until they solve the RLS concerns, but its been an incredible project to follow.