PowerSync
@powersync.com
Sync engine for keeping backend databases in sync with in-app SQLite.
Postgres | MongoDB | MySQL (beta)
🐘🌿🐬 «-» 🪶
Postgres | MongoDB | MySQL (beta)
🐘🌿🐬 «-» 🪶
When building online web apps with sync, you can sync data as needed rather than syncing everything upfront. For the initial UI state, you can sync the minimum data needed.
Here's an example using our new Sync Streams (currently in early alpha)
1) Define the Sync Stream:
Here's an example using our new Sync Streams (currently in early alpha)
1) Define the Sync Stream:
December 1, 2025 at 8:54 PM
When building online web apps with sync, you can sync data as needed rather than syncing everything upfront. For the initial UI state, you can sync the minimum data needed.
Here's an example using our new Sync Streams (currently in early alpha)
1) Define the Sync Stream:
Here's an example using our new Sync Streams (currently in early alpha)
1) Define the Sync Stream:
Get a full "synced app" stack with only @supabase.com + PowerSync:
Source DB - Supabase
Auth - Supabase
API (for incoming writes) - Supabase
Sync engine - PowerSync
Managed local SQLite - PowerSync
Source DB - Supabase
Auth - Supabase
API (for incoming writes) - Supabase
Sync engine - PowerSync
Managed local SQLite - PowerSync
November 25, 2025 at 5:18 PM
Get a full "synced app" stack with only @supabase.com + PowerSync:
Source DB - Supabase
Auth - Supabase
API (for incoming writes) - Supabase
Sync engine - PowerSync
Managed local SQLite - PowerSync
Source DB - Supabase
Auth - Supabase
API (for incoming writes) - Supabase
Sync engine - PowerSync
Managed local SQLite - PowerSync
Reposted by PowerSync
Thanks to @powersync.com for backing Sync Conf. They make real-time, local-first data sync simple for modern apps.
November 21, 2025 at 6:57 PM
Thanks to @powersync.com for backing Sync Conf. They make real-time, local-first data sync simple for modern apps.
Facilitron is the "Airbnb for public spaces".
Their app needed a replacement sync solution when Atlas Device Sync + Realm was deprecated.
They turned to PowerSync and successfully migrated in a few months! 🔥
Their app needed a replacement sync solution when Atlas Device Sync + Realm was deprecated.
They turned to PowerSync and successfully migrated in a few months! 🔥
November 18, 2025 at 7:57 PM
Facilitron is the "Airbnb for public spaces".
Their app needed a replacement sync solution when Atlas Device Sync + Realm was deprecated.
They turned to PowerSync and successfully migrated in a few months! 🔥
Their app needed a replacement sync solution when Atlas Device Sync + Realm was deprecated.
They turned to PowerSync and successfully migrated in a few months! 🔥
Local SQLite w/ PowerSync can speed up performance and improve UX of Electron apps.
But should PowerSync live in Electron's main or renderer process?
With both Node.js and web SDKs available, it's up to you!
But should PowerSync live in Electron's main or renderer process?
With both Node.js and web SDKs available, it's up to you!
November 17, 2025 at 5:23 PM
Local SQLite w/ PowerSync can speed up performance and improve UX of Electron apps.
But should PowerSync live in Electron's main or renderer process?
With both Node.js and web SDKs available, it's up to you!
But should PowerSync live in Electron's main or renderer process?
With both Node.js and web SDKs available, it's up to you!
𝗡𝗲𝘄 𝗿𝗲𝗹𝗲𝗮𝘀𝗲: @tanstack.com DB x PowerSync 🌴 🔥
The @tanstack/powersync-db-collection brings offline persistence, realtime multi-tab + backend sync, and automatic conflict resolution to TanStack DB.
And you get TanStack DB’s super reactive client-store and query engine!
The @tanstack/powersync-db-collection brings offline persistence, realtime multi-tab + backend sync, and automatic conflict resolution to TanStack DB.
And you get TanStack DB’s super reactive client-store and query engine!
November 14, 2025 at 7:45 PM
𝗡𝗲𝘄 𝗿𝗲𝗹𝗲𝗮𝘀𝗲: @tanstack.com DB x PowerSync 🌴 🔥
The @tanstack/powersync-db-collection brings offline persistence, realtime multi-tab + backend sync, and automatic conflict resolution to TanStack DB.
And you get TanStack DB’s super reactive client-store and query engine!
The @tanstack/powersync-db-collection brings offline persistence, realtime multi-tab + backend sync, and automatic conflict resolution to TanStack DB.
And you get TanStack DB’s super reactive client-store and query engine!
We track the state of the art of using 𝗦𝗤𝗟𝗶𝘁𝗲 𝗶𝗻 𝘄𝗲𝗯 𝗯𝗿𝗼𝘄𝘀𝗲𝗿𝘀.
We've just published the latest update to our comprehensive guide.
Link below ↓
We've just published the latest update to our comprehensive guide.
Link below ↓
November 13, 2025 at 4:06 PM
We track the state of the art of using 𝗦𝗤𝗟𝗶𝘁𝗲 𝗶𝗻 𝘄𝗲𝗯 𝗯𝗿𝗼𝘄𝘀𝗲𝗿𝘀.
We've just published the latest update to our comprehensive guide.
Link below ↓
We've just published the latest update to our comprehensive guide.
Link below ↓
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
"This was a radical shift in the way we thought about mobile app development. Suddenly, all of the data we wanted to make available to the client was directly and immediately available within our app."
www.powersync.com/blog/how-we...
www.powersync.com/blog/how-we...
How We Built Personalized College Matching using Sync, AI + RAG
Thanks to the instant sync now available in-app, we now provide our users with a seamless and hyper-personalized recommendation experience without our users having long wait times. Our users continue using every feature in Loper all while receiving tailored college recommendations in real-time from long-running AI + RAG processes.
www.powersync.com
October 27, 2025 at 5:57 PM
"This was a radical shift in the way we thought about mobile app development. Suddenly, all of the data we wanted to make available to the client was directly and immediately available within our app."
www.powersync.com/blog/how-we...
www.powersync.com/blog/how-we...
Reposted by PowerSync
Full lineup and schedule for @syncconf.bsky.social in SF on Nov 12. Link in the 🧵 below 👇
October 24, 2025 at 9:47 PM
Full lineup and schedule for @syncconf.bsky.social in SF on Nov 12. Link in the 🧵 below 👇
"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 ↓
Sync opens novel ways to use AI in apps.
E.g. not blocking UX with a "thinking..." state but instead asynchronously passing data to AI + RAG processes on the server & syncing the response when it's ready.
Loper uses this for its student-college matching app:
dub.sh/lsidchye2
E.g. not blocking UX with a "thinking..." state but instead asynchronously passing data to AI + RAG processes on the server & syncing the response when it's ready.
Loper uses this for its student-college matching app:
dub.sh/lsidchye2
How We Built Personalized College Matching using Sync, AI + RAG
Thanks to the instant sync now available in-app, we now provide our users with a seamless and hyper-personalized recommendation experience without our users having long wait times. Our users continue using every feature in Loper all while receiving tailored college recommendations in real-time from long-running AI + RAG processes.
dub.sh
October 22, 2025 at 5:37 PM
Sync opens novel ways to use AI in apps.
E.g. not blocking UX with a "thinking..." state but instead asynchronously passing data to AI + RAG processes on the server & syncing the response when it's ready.
Loper uses this for its student-college matching app:
dub.sh/lsidchye2
E.g. not blocking UX with a "thinking..." state but instead asynchronously passing data to AI + RAG processes on the server & syncing the response when it's ready.
Loper uses this for its student-college matching app:
dub.sh/lsidchye2
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."
🔨 𝗡𝗲𝘄 𝗽𝗿𝗼𝗽𝗼𝘀𝗮𝗹: Bucket data on object storage github.com/powersync-j...
[Proposal] Bucket data on object storage · powersync-ja powersync-service · Discussion #376
Background PowerSync currently syncs all data directly via either an HTTP stream, or a WebSocket connection. This proposal specifies an optional addition in the protocol, to allow syncing bulk data...
github.com
October 15, 2025 at 4:05 PM
🔨 𝗡𝗲𝘄 𝗽𝗿𝗼𝗽𝗼𝘀𝗮𝗹: Bucket data on object storage github.com/powersync-j...
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.
"In this post, I’ll be making my case that Supabase + PowerSync is one of the best stacks on the market for building offline-first web and mobile apps."
– @k081e.bsky.social
www.powersync.com/blog/offlin...
– @k081e.bsky.social
www.powersync.com/blog/offlin...
Offline-First Apps Made Simple: Supabase + PowerSync
In this post, I’ll be making my case that Supabase + PowerSync is one of the best stacks on the market for building offline-first web and mobile apps.
www.powersync.com
October 13, 2025 at 12:42 PM
"In this post, I’ll be making my case that Supabase + PowerSync is one of the best stacks on the market for building offline-first web and mobile apps."
– @k081e.bsky.social
www.powersync.com/blog/offlin...
– @k081e.bsky.social
www.powersync.com/blog/offlin...
"September is a shoulder season in many parts of the world, and that aligns with a big upgrade coming to the heart of PowerSync — 𝗦𝘆𝗻𝗰 𝗦𝘁𝗿𝗲𝗮𝗺𝘀, an evolution of our current Sync Rules system..."
Read more in our September newsletter:
www.powersync.com/blog/produc...
Read more in our September newsletter:
www.powersync.com/blog/produc...
Product Update: September 2025
September is a shoulder season in many parts of the world, and that aligns with a big upgrade coming to the heart of PowerSync — Sync Streams, an evolution of our current Sync Rules system.
www.powersync.com
October 9, 2025 at 3:25 PM
"September is a shoulder season in many parts of the world, and that aligns with a big upgrade coming to the heart of PowerSync — 𝗦𝘆𝗻𝗰 𝗦𝘁𝗿𝗲𝗮𝗺𝘀, an evolution of our current Sync Rules system..."
Read more in our September newsletter:
www.powersync.com/blog/produc...
Read more in our September newsletter:
www.powersync.com/blog/produc...
Reposted by PowerSync
Conrad (@powersync.com) covers one of our favorite topics: SQLite, and the latest on using it in your client-side web app.
PowerSync has written many excellent blog posts going deep on SQLite for the web, expect to see that expertise on display in this talk.
PowerSync has written many excellent blog posts going deep on SQLite for the web, expect to see that expertise on display in this talk.
October 7, 2025 at 3:16 PM
Conrad (@powersync.com) covers one of our favorite topics: SQLite, and the latest on using it in your client-side web app.
PowerSync has written many excellent blog posts going deep on SQLite for the web, expect to see that expertise on display in this talk.
PowerSync has written many excellent blog posts going deep on SQLite for the web, expect to see that expertise on display in this talk.
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
𝗡𝗲𝘄 𝗿𝗲𝗹𝗲𝗮𝘀𝗲: improved attachment utilities in our Dart / Flutter SDK.
Now with support for:
• Custom local storage implementation
• Dynamic nested directories and custom file extensions
• Adding optional metaData to attachments
Also: no longer depends on dart:io
Now with support for:
• Custom local storage implementation
• Dynamic nested directories and custom file extensions
• Adding optional metaData to attachments
Also: no longer depends on dart:io
October 7, 2025 at 12:29 PM
𝗡𝗲𝘄 𝗿𝗲𝗹𝗲𝗮𝘀𝗲: improved attachment utilities in our Dart / Flutter SDK.
Now with support for:
• Custom local storage implementation
• Dynamic nested directories and custom file extensions
• Adding optional metaData to attachments
Also: no longer depends on dart:io
Now with support for:
• Custom local storage implementation
• Dynamic nested directories and custom file extensions
• Adding optional metaData to attachments
Also: no longer depends on dart:io
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!