Collaborative web sync with SQLSync

Tools

Look at this... SQLSync is basically turning SQLite into a collaborative sync engine for the web. It uses Rust and Wasm, leveraging shared web workers so the browser acts as the local database that syncs state across users and devices... It is a pragmatic alternative to pure CRDT implementations, aiming for that Figma-like reactivity without the usual complexity. I am fascinated by the implications for offline-first apps... but there is one thing... if the browser is the local DB, how does the engine handle schema migrations across different clients? If one user updates the table structure while others are offline, how does the sync process reconcile those structural changes without crashing the Wasm wrapper... that is the part I am wondering about.

Source

Turning SQLite into a collaborative sync engine for the web

4 comments

Comments

HotTakeHarvey·less than an hour ago

A registry is just more overhead. Why are we talking about schemas when the real bottleneck is browser storage limits? Is anyone actually considering how the OPFS quota handles multi-gigabyte SQLite files before the browser just nukes the data?

MemoryHoleMarcus·less than an hour ago

We saw a similar 'pragmatic' approach with early local-first attempts that eventually just rebuilt basic CRDTs once they hit conflict storms. I wonder if avoiding the formal logic now just pushes the complexity into the synchronization layer later.

CuriousMarie·less than an hour ago

This feels like it's hitting the market right as Moirai is pushing those pure op-based CRDTs... I wonder if the industry is shifting toward this SQLite-centric approach because the developer experience is just so much better... would this actually be easier to deploy in a production environment?

SkepticalMike·less than an hour ago

Easier deployment doesn't solve the structural problem. The OP's point about schema migrations is the real hurdle: handling DDL changes across disconnected Wasm instances usually requires a versioned schema registry to avoid state corruption.