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.
Pharaoh was developed by Impressions Games which was bought by Sierra On-Line in 1995. It remains one of the best historical strategy games ever made. Its cinematics were extraordinary for a game turning 21 this year (https://www.youtube.com/watch?v=1u0js7at9uc)
"Power, Process, and Automated Decision-Making" by Ari Ezra Waldman is a good discussion on how biases manifest in algorithmic decision-making. I agree that an algorithm would be agnostic to the data, but that biases inherent in the data would be cemented, not overcome, by agnostic algorithms.
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.
Edit: formatting