Phillip from PowerSync here, always good to see more people working on problems in this space.
A few things to clarify:
>one multi-tenant centralized db to bidirectionally sync
PowerSync supports syncing from multiple databases.
>The downside is complexity.
I'd say this is true if you're building a partial replication system yourself. PowerSync gives you a ready-built system that's been proven at scale and therefore lets you avoid most of that complexity.
>SQLSync, on the other hand, is full db sync.
It's just as easy to sync the full db with PowerSync as do partial sync.
Congrats to the team. I'm on the team over at https://powersync.co and have been following this space for a while.
PowerSync is also a plug-in sync layer. The biggest difference I see is in Electric's use of CRDTs, where we don't rely on them and instead use server reconciliation.
As a team that's been working on online/offline sync for just over a decade, it's great to finally see more products that enable offline-first architectures!
OP here – Supabase fans have been asking for something akin to Firebase Firestore's (limited) automatic offline support. We've gone a step further and built a SDK with embedded local database as well as a sync service that plugs into Supabase.