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
"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!
Cinapse.io migrated their sync layer to move away from CRDTs:
"CRDTs are an impressive and exciting technology, but they turned out to be a bad fit for our use case."
They've shared their story:
www.powersync.com/blog/why-ci...
"CRDTs are an impressive and exciting technology, but they turned out to be a bad fit for our use case."
They've shared their story:
www.powersync.com/blog/why-ci...
Why Cinapse Moved Away From CRDTs For Sync
Cinapse’s scheduling app was the first one I built from scratch using CRDTs. CRDTs are an impressive and exciting technology, but they turned out to be a bad fit for our use case.
www.powersync.com
October 2, 2025 at 12:28 PM
Cinapse.io migrated their sync layer to move away from CRDTs:
"CRDTs are an impressive and exciting technology, but they turned out to be a bad fit for our use case."
They've shared their story:
www.powersync.com/blog/why-ci...
"CRDTs are an impressive and exciting technology, but they turned out to be a bad fit for our use case."
They've shared their story:
www.powersync.com/blog/why-ci...
New demo: Collaborative text editing with @tiptap.dev over PowerSync, *without* CRDTs or OT ✨
"Instead of trying to 'fit' collaborative text into a database table, we merely record the log of all updates to the text.
...
"Instead of trying to 'fit' collaborative text into a database table, we merely record the log of all updates to the text.
...
October 1, 2025 at 1:15 PM
New demo: Collaborative text editing with @tiptap.dev over PowerSync, *without* CRDTs or OT ✨
"Instead of trying to 'fit' collaborative text into a database table, we merely record the log of all updates to the text.
...
"Instead of trying to 'fit' collaborative text into a database table, we merely record the log of all updates to the text.
...
Reposted by PowerSync
I made a guest post on @powersync.com's blog: powersync.com/blog/collabo...
It describes a demo we made of collaborative text editing on top of PowerSync's DB sync engine, using character IDs & totally-ordered updates in a DB table (w/o CRDTs).
It describes a demo we made of collaborative text editing on top of PowerSync's DB sync engine, using character IDs & totally-ordered updates in a DB table (w/o CRDTs).
Collaborative Text Editing Over PowerSync
This blog post describes the resulting demo of collaborative text editing over PowerSync. The demo uses Tiptap as the editor, has basic support for shared cursors and anonymous share links, and includ...
powersync.com
September 30, 2025 at 9:16 PM
I made a guest post on @powersync.com's blog: powersync.com/blog/collabo...
It describes a demo we made of collaborative text editing on top of PowerSync's DB sync engine, using character IDs & totally-ordered updates in a DB table (w/o CRDTs).
It describes a demo we made of collaborative text editing on top of PowerSync's DB sync engine, using character IDs & totally-ordered updates in a DB table (w/o CRDTs).
"One of the most immediate benefits we noticed with the Rust client was a modest performance increase on @reactnative.dev: Depending on the exact scenario, the new client is around 5 times faster than the JavaScript-based implementation!"
– Simon Binder on our new @rust-lang.org client.
– Simon Binder on our new @rust-lang.org client.
September 25, 2025 at 12:25 PM
"One of the most immediate benefits we noticed with the Rust client was a modest performance increase on @reactnative.dev: Depending on the exact scenario, the new client is around 5 times faster than the JavaScript-based implementation!"
– Simon Binder on our new @rust-lang.org client.
– Simon Binder on our new @rust-lang.org client.
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