Sync engine for keeping backend databases in sync with client-side SQLite. Postgres | MongoDB | MySQL | SQL Server | Azure DocumentDB 🐘🌿🐬🛢️«-» 🪶

Distributed
Joined May 2023
Michael's search for a good sync solution has ended. smry.ai is now running on @powersync_ read about his journey: powersync.com/blog/how-smry-…
I'm looking for a good solution for indexeddb<-> postgres sync. Needs to be able to use my existing db (no electricsql) and actually stable. Something like linear's sync engine but less hand-rolled. Anybody know a good tool for this?
1
9
We love SQLite, but working with booleans can have some rough edges due to SQLite's absence of a dedicated bool type. We shipped "fixed_booleans_in_json" in 1.27 of the PowerSync Service, which now preserves boolean literals in synced JSON. Check it 👇
1
4
272
We've released 1.27.1 of the PowerSync Service on Docker Hub. It contains mitigations for the eMudhra Intermediate CA Compromise. The compromise could affect JWKS fetching and TLS connections for source databases. It is recommended to upgrade now. github.com/powersync-ja/powe…
1
2
2
506
We're busy rolling out this patch to PowerSync Cloud and coordinating with customers.
62
PowerSync DevTools have shipped - inspect your app's live database Our team couldn't resist memeing a video about this one 😆 releases.powersync.com/annou…
1
1
6
560
💯
one of my beliefs is that most apps basically solve the same engineering problems over and over again: - a design system - a sync engine - transactional database and if you just extract these out and solve them correctly, "vibe coding" any app on top becomes trivial
4
305
The PowerSync CLI now has a --dry-run flag for all deploy commands, to review changes before deploying. If you're paranoid about agents running amok, this could help. Available in v0.10.2
6
288
Sometimes your app requires fast user switching. If you call disconnectAndClear(), then each time a user switches they need to re-download all their data. To make user switching faster, consider preserving local data when disconnecting: db.disconnectAndClear({ soft: true })
1
4
411
SQLite
starts with S and we all love it?
1
9
419
Supabase Select is happening today! Say hi to @k081e if you see him there. The event gave us an excuse to ship something we've always wanted to: a streamlined Supabase setup experience in PowerSync Cloud. Building sync into your app has never been simpler!
2
2
2
10
1,930
The integration creates a dedicated replication role, presents a small UI to select tables to replicate&sync, and automatically configures PowerSync's db connection to Supabase, and configures PoweSync to use Supabase auth when authenticating clients.
1
105
This also sets us up for a deeper signed redirect partner integration, which we'll be shipping next!
57