Think you'd really enjoy exploring Electric SQL (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.