PowerSync
@powersync.com
Sync engine for keeping backend databases in sync with in-app SQLite.
Postgres | MongoDB | MySQL (beta)
🐘🌿🐬 «-» 🪶
Postgres | MongoDB | MySQL (beta)
🐘🌿🐬 «-» 🪶
Introducing our Capacitor JS SDK (Alpha) 🎉
It extends the PowerSync Web SDK so you can use the same APIs in Capacitor apps (iOS, Android, web), while adding native SQLite support for stronger persistence and performance on mobile platforms.
It extends the PowerSync Web SDK so you can use the same APIs in Capacitor apps (iOS, Android, web), while adding native SQLite support for stronger persistence and performance on mobile platforms.
November 4, 2025 at 1:16 PM
Introducing our Capacitor JS SDK (Alpha) 🎉
It extends the PowerSync Web SDK so you can use the same APIs in Capacitor apps (iOS, Android, web), while adding native SQLite support for stronger persistence and performance on mobile platforms.
It extends the PowerSync Web SDK so you can use the same APIs in Capacitor apps (iOS, Android, web), while adding native SQLite support for stronger persistence and performance on mobile platforms.
Sync Conf is hitting San Francisco in just two weeks!
We're giving away 4 tickets 🎉
Enter here: form.typeform.com/to/MX2Pzmqs
CC: @syncconf.bsky.social
We're giving away 4 tickets 🎉
Enter here: form.typeform.com/to/MX2Pzmqs
CC: @syncconf.bsky.social
October 28, 2025 at 4:57 PM
Sync Conf is hitting San Francisco in just two weeks!
We're giving away 4 tickets 🎉
Enter here: form.typeform.com/to/MX2Pzmqs
CC: @syncconf.bsky.social
We're giving away 4 tickets 🎉
Enter here: form.typeform.com/to/MX2Pzmqs
CC: @syncconf.bsky.social
"The next generation of products are being built on sync engines and local-first architectures."
We're sponsoring @syncconf.bsky.social in SF and we're giving away 4 tickets to developers who want to join us at the event!
Enter below ↓
We're sponsoring @syncconf.bsky.social in SF and we're giving away 4 tickets to developers who want to join us at the event!
Enter below ↓
October 23, 2025 at 1:59 PM
"The next generation of products are being built on sync engines and local-first architectures."
We're sponsoring @syncconf.bsky.social in SF and we're giving away 4 tickets to developers who want to join us at the event!
Enter below ↓
We're sponsoring @syncconf.bsky.social in SF and we're giving away 4 tickets to developers who want to join us at the event!
Enter below ↓
Incrementally materialized views created by pg_ivm are just regular Postgres tables that are efficiently kept up to date using an IVM algorithm.
Because changes to these tables are published in logical replication, you can reference them in PowerSync’s Sync Rules like any other table.
Because changes to these tables are published in logical replication, you can reference them in PowerSync’s Sync Rules like any other table.
October 21, 2025 at 5:12 PM
Incrementally materialized views created by pg_ivm are just regular Postgres tables that are efficiently kept up to date using an IVM algorithm.
Because changes to these tables are published in logical replication, you can reference them in PowerSync’s Sync Rules like any other table.
Because changes to these tables are published in logical replication, you can reference them in PowerSync’s Sync Rules like any other table.
Marcus Pousette built a PowerSync + Supabase React app w/ E2EE:
"Messages & rooms are stored as encrypted rows; mirrors expose the plaintext needed for UI. I used PowerSync’s differential watch to feed the chat, because it tells you exactly what changed rather than re‑emitting whole result sets."
"Messages & rooms are stored as encrypted rows; mirrors expose the plaintext needed for UI. I used PowerSync’s differential watch to feed the chat, because it tells you exactly what changed rather than re‑emitting whole result sets."
October 16, 2025 at 4:32 PM
Marcus Pousette built a PowerSync + Supabase React app w/ E2EE:
"Messages & rooms are stored as encrypted rows; mirrors expose the plaintext needed for UI. I used PowerSync’s differential watch to feed the chat, because it tells you exactly what changed rather than re‑emitting whole result sets."
"Messages & rooms are stored as encrypted rows; mirrors expose the plaintext needed for UI. I used PowerSync’s differential watch to feed the chat, because it tells you exactly what changed rather than re‑emitting whole result sets."
With our Vite + React + TS template, you can set up a fully self-hosted development environment using @supabase.com with just a few commands.
October 15, 2025 at 1:21 PM
With our Vite + React + TS template, you can set up a fully self-hosted development environment using @supabase.com with just a few commands.
Expo's BackgroundTask API can be used to keep in-app SQLite synced even when apps are minimized.
Background tasks aren't perfect: they can be aggressively throttled by the OS to preserve battery and resources etc.
But when the stars align it feels like magic.
Background tasks aren't perfect: they can be aggressively throttled by the OS to preserve battery and resources etc.
But when the stars align it feels like magic.
October 14, 2025 at 12:54 PM
Expo's BackgroundTask API can be used to keep in-app SQLite synced even when apps are minimized.
Background tasks aren't perfect: they can be aggressively throttled by the OS to preserve battery and resources etc.
But when the stars align it feels like magic.
Background tasks aren't perfect: they can be aggressively throttled by the OS to preserve battery and resources etc.
But when the stars align it feels like magic.
With @expo.dev background tasks, keep apps in sync even when they're minimized.
Demo flow:
1. Minimize app
2. Add 5,000 new records on @supabase.com
3. Open app → new records already downloaded
Demo flow:
1. Minimize app
2. Add 5,000 new records on @supabase.com
3. Open app → new records already downloaded
October 7, 2025 at 2:43 PM
With @expo.dev background tasks, keep apps in sync even when they're minimized.
Demo flow:
1. Minimize app
2. Add 5,000 new records on @supabase.com
3. Open app → new records already downloaded
Demo flow:
1. Minimize app
2. Add 5,000 new records on @supabase.com
3. Open app → new records already downloaded
It's an exciting time for client-side data stores.
PowerSync integrates with:
@tinybase.bsky.social
@drizzle.team
@kysely.dev
Drift
SQLDelight
Room
If you need support for something else, let us know!
PowerSync integrates with:
@tinybase.bsky.social
@drizzle.team
@kysely.dev
Drift
SQLDelight
Room
If you need support for something else, let us know!
October 3, 2025 at 2:02 PM
It's an exciting time for client-side data stores.
PowerSync integrates with:
@tinybase.bsky.social
@drizzle.team
@kysely.dev
Drift
SQLDelight
Room
If you need support for something else, let us know!
PowerSync integrates with:
@tinybase.bsky.social
@drizzle.team
@kysely.dev
Drift
SQLDelight
Room
If you need support for something else, let us know!
That establishes a canonical total order on updates. All clients compute the current text state by processing the updates in server_version order."
– Thanks to @mweidner.bsky.social 👏
– Thanks to @mweidner.bsky.social 👏
October 1, 2025 at 1:15 PM
That establishes a canonical total order on updates. All clients compute the current text state by processing the updates in server_version order."
– Thanks to @mweidner.bsky.social 👏
– Thanks to @mweidner.bsky.social 👏
If you're at FlutterconEU in Berlin:
Catch Simon Binder's talk on synced in-app databases tomorrow @ 12pm.
#ftcon25eu #FlutterDev
Catch Simon Binder's talk on synced in-app databases tomorrow @ 12pm.
#ftcon25eu #FlutterDev
September 24, 2025 at 12:38 PM
If you're at FlutterconEU in Berlin:
Catch Simon Binder's talk on synced in-app databases tomorrow @ 12pm.
#ftcon25eu #FlutterDev
Catch Simon Binder's talk on synced in-app databases tomorrow @ 12pm.
#ftcon25eu #FlutterDev
When self-hosting PowerSync, you can use @supabase.com as both your source database (source of truth) and your "bucket storage" database (where PowerSync stores operation history etc).
The result is a fairly simple topology:
The result is a fairly simple topology:
September 22, 2025 at 4:49 PM
When self-hosting PowerSync, you can use @supabase.com as both your source database (source of truth) and your "bucket storage" database (where PowerSync stores operation history etc).
The result is a fairly simple topology:
The result is a fairly simple topology:
For @kotlinlang.org developers – PowerSync now supports integrations for SQLDelight (beta) and Room (alpha).
Why use these libraries?
• compile-time validation of queries
• automatic mapping into typed classes
This makes writing SQL queries and parsing results on the client safer.
Why use these libraries?
• compile-time validation of queries
• automatic mapping into typed classes
This makes writing SQL queries and parsing results on the client safer.
September 19, 2025 at 4:02 PM
For @kotlinlang.org developers – PowerSync now supports integrations for SQLDelight (beta) and Room (alpha).
Why use these libraries?
• compile-time validation of queries
• automatic mapping into typed classes
This makes writing SQL queries and parsing results on the client safer.
Why use these libraries?
• compile-time validation of queries
• automatic mapping into typed classes
This makes writing SQL queries and parsing results on the client safer.
"Even though SQL is probably older than you are, it’s still the go-to mechanism for expressing most data querying needs."
- Chriztiaan_dev
- Chriztiaan_dev
September 18, 2025 at 12:13 PM
"Even though SQL is probably older than you are, it’s still the go-to mechanism for expressing most data querying needs."
- Chriztiaan_dev
- Chriztiaan_dev
Using @expo.dev with real-time synced SQLite means that instead of having to:
• manage network requests
• handle loading states
• implement retry logic
• orchestrate state management between your local cache and remote data
You just write queries™
• manage network requests
• handle loading states
• implement retry logic
• orchestrate state management between your local cache and remote data
You just write queries™
September 17, 2025 at 2:51 PM
Using @expo.dev with real-time synced SQLite means that instead of having to:
• manage network requests
• handle loading states
• implement retry logic
• orchestrate state management between your local cache and remote data
You just write queries™
• manage network requests
• handle loading states
• implement retry logic
• orchestrate state management between your local cache and remote data
You just write queries™
Our August newsletter covers major product updates but it also introduces Sync Streams: a major update to our dynamic partial replication system that we're currently working on.
September 11, 2025 at 4:15 PM
Our August newsletter covers major product updates but it also introduces Sync Streams: a major update to our dynamic partial replication system that we're currently working on.
Hit this toggle on our diagnostics app if you're using our new Rust-based sync client.
September 5, 2025 at 6:35 PM
Hit this toggle on our diagnostics app if you're using our new Rust-based sync client.
Catch Simon Binder's talk at Fluttercon EU in Berlin later this month.
September 1, 2025 at 2:15 PM
Catch Simon Binder's talk at Fluttercon EU in Berlin later this month.
The quickest way to spin up a PowerSync app is by using a fully self-hosted setup with @supabase.com and our @vite.dev template app.
August 29, 2025 at 11:25 AM
The quickest way to spin up a PowerSync app is by using a fully self-hosted setup with @supabase.com and our @vite.dev template app.
Swift developers in Denver:
Join the Denver Cocoaheads meetup on Sep 9 for a hands-on session w/ @k081e.bsky.social and Steven, one of the engineers behind our Swift SDK.
We’ll share how it keeps backend databases in sync with SQLite embedded in iOS/macOS/watchOS apps in a workshop context.
Join the Denver Cocoaheads meetup on Sep 9 for a hands-on session w/ @k081e.bsky.social and Steven, one of the engineers behind our Swift SDK.
We’ll share how it keeps backend databases in sync with SQLite embedded in iOS/macOS/watchOS apps in a workshop context.
August 13, 2025 at 5:40 PM
Swift developers in Denver:
Join the Denver Cocoaheads meetup on Sep 9 for a hands-on session w/ @k081e.bsky.social and Steven, one of the engineers behind our Swift SDK.
We’ll share how it keeps backend databases in sync with SQLite embedded in iOS/macOS/watchOS apps in a workshop context.
Join the Denver Cocoaheads meetup on Sep 9 for a hands-on session w/ @k081e.bsky.social and Steven, one of the engineers behind our Swift SDK.
We’ll share how it keeps backend databases in sync with SQLite embedded in iOS/macOS/watchOS apps in a workshop context.
PowerSync MySQL backend database support has reached Beta!
August 11, 2025 at 12:15 PM
PowerSync MySQL backend database support has reached Beta!
Simon Binder will be in action again at Fluttercon Europe in September, talking about
𝙎𝙞𝙢𝙥𝙡𝙚𝙧 𝙨𝙩𝙖𝙩𝙚 𝙢𝙖𝙣𝙖𝙜𝙚𝙢𝙚𝙣𝙩 𝙬𝙞𝙩𝙝 𝘿𝙖𝙧𝙩 𝙤𝙣 𝙩𝙝𝙚 𝙨𝙚𝙧𝙫𝙚𝙧 𝙖𝙣𝙙 𝙨𝙮𝙣𝙘𝙚𝙙 𝙙𝙖𝙩𝙖𝙗𝙖𝙨𝙚𝙨
🚀 🇪🇺
𝙎𝙞𝙢𝙥𝙡𝙚𝙧 𝙨𝙩𝙖𝙩𝙚 𝙢𝙖𝙣𝙖𝙜𝙚𝙢𝙚𝙣𝙩 𝙬𝙞𝙩𝙝 𝘿𝙖𝙧𝙩 𝙤𝙣 𝙩𝙝𝙚 𝙨𝙚𝙧𝙫𝙚𝙧 𝙖𝙣𝙙 𝙨𝙮𝙣𝙘𝙚𝙙 𝙙𝙖𝙩𝙖𝙗𝙖𝙨𝙚𝙨
🚀 🇪🇺
August 7, 2025 at 2:44 PM
Simon Binder will be in action again at Fluttercon Europe in September, talking about
𝙎𝙞𝙢𝙥𝙡𝙚𝙧 𝙨𝙩𝙖𝙩𝙚 𝙢𝙖𝙣𝙖𝙜𝙚𝙢𝙚𝙣𝙩 𝙬𝙞𝙩𝙝 𝘿𝙖𝙧𝙩 𝙤𝙣 𝙩𝙝𝙚 𝙨𝙚𝙧𝙫𝙚𝙧 𝙖𝙣𝙙 𝙨𝙮𝙣𝙘𝙚𝙙 𝙙𝙖𝙩𝙖𝙗𝙖𝙨𝙚𝙨
🚀 🇪🇺
𝙎𝙞𝙢𝙥𝙡𝙚𝙧 𝙨𝙩𝙖𝙩𝙚 𝙢𝙖𝙣𝙖𝙜𝙚𝙢𝙚𝙣𝙩 𝙬𝙞𝙩𝙝 𝘿𝙖𝙧𝙩 𝙤𝙣 𝙩𝙝𝙚 𝙨𝙚𝙧𝙫𝙚𝙧 𝙖𝙣𝙙 𝙨𝙮𝙣𝙘𝙚𝙙 𝙙𝙖𝙩𝙖𝙗𝙖𝙨𝙚𝙨
🚀 🇪🇺
𝗕𝗲𝘁𝗮 𝗿𝗲𝗹𝗲𝗮𝘀𝗲: Node.js Client SDK
After shipping a bunch of improvements and bug fixes, we're now confident the SDK is ready for production use (once you’ve tested your use cases), so we’re bumping it to beta.
npm install @powersync/node
cc: @nodejs.org
After shipping a bunch of improvements and bug fixes, we're now confident the SDK is ready for production use (once you’ve tested your use cases), so we’re bumping it to beta.
npm install @powersync/node
cc: @nodejs.org
August 6, 2025 at 12:13 PM
𝗕𝗲𝘁𝗮 𝗿𝗲𝗹𝗲𝗮𝘀𝗲: Node.js Client SDK
After shipping a bunch of improvements and bug fixes, we're now confident the SDK is ready for production use (once you’ve tested your use cases), so we’re bumping it to beta.
npm install @powersync/node
cc: @nodejs.org
After shipping a bunch of improvements and bug fixes, we're now confident the SDK is ready for production use (once you’ve tested your use cases), so we’re bumping it to beta.
npm install @powersync/node
cc: @nodejs.org
PowerSync applications are now compatible with @Expo.dev Go!
We’ve released a pure JavaScript SQLite adapter for our React Native SDK, @powersync/adapter-sql-js, which works in sandboxed environments like Expo Go by using our custom fork of SQL.js.
We’ve released a pure JavaScript SQLite adapter for our React Native SDK, @powersync/adapter-sql-js, which works in sandboxed environments like Expo Go by using our custom fork of SQL.js.
August 4, 2025 at 3:06 PM
PowerSync applications are now compatible with @Expo.dev Go!
We’ve released a pure JavaScript SQLite adapter for our React Native SDK, @powersync/adapter-sql-js, which works in sandboxed environments like Expo Go by using our custom fork of SQL.js.
We’ve released a pure JavaScript SQLite adapter for our React Native SDK, @powersync/adapter-sql-js, which works in sandboxed environments like Expo Go by using our custom fork of SQL.js.
We're trying something new for our June newsletter 👀
Inspired by Fly[dot]io, we're sharing more about the engineering reasoning behind our latest product updates.
Read about implementing sync logic in Rust, multiple improvements to our server-side sync service, our .NET MAUI package and more.
Inspired by Fly[dot]io, we're sharing more about the engineering reasoning behind our latest product updates.
Read about implementing sync logic in Rust, multiple improvements to our server-side sync service, our .NET MAUI package and more.
July 7, 2025 at 2:09 PM
We're trying something new for our June newsletter 👀
Inspired by Fly[dot]io, we're sharing more about the engineering reasoning behind our latest product updates.
Read about implementing sync logic in Rust, multiple improvements to our server-side sync service, our .NET MAUI package and more.
Inspired by Fly[dot]io, we're sharing more about the engineering reasoning behind our latest product updates.
Read about implementing sync logic in Rust, multiple improvements to our server-side sync service, our .NET MAUI package and more.