I built my own offline capable, multiplayer capable sync engine with pglite and electric https://github.com/evelant/synchrotron

It is opinionated and not for every use case, also very experimental, but you might find some of the ideas interesting.