[satvikpendem]

Look into ElectricSQL which works with existing Postgres, it is what I'm leaning towards using too.

[ochiba]

I work on PowerSync which may be worth looking at too, for Postgres-SQLite sync https://www.powersync.com/

[zknill]

Also checkout Ably LiveSync, works with postgres and makes some different (potentially simpler) tradeoffs