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.

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

"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...

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 ↓

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

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.

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."

🔨 𝗡𝗲𝘄 𝗽𝗿𝗼𝗽𝗼𝘀𝗮𝗹: 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.

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.

"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...

"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...

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.

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

𝗡𝗲𝘄 𝗿𝗲𝗹𝗲𝗮𝘀𝗲: 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

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!

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...

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. ...

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).

"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.

If you're at FlutterconEU in Berlin: 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:

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.

"Even though SQL is probably older than you are, it’s still the go-to mechanism for expressing most data querying needs." - 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™

To reduce duplication and improve performance, we built a new Rust client for the PowerSync SDKs: we expanded our existing custom SQLite extension written in Rust to include a client state machine for the PowerSync protocol. 🧵

We’ve published a new long-form video on setting up a Swift app with PowerSync 🎉 www.youtube.com/watch?v=GYQ...

We've simplified our pricing. Overall, these changes should lower usage costs for everyone. www.powersync.com/blog/simpli...

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.

🔨 𝗡𝗲𝘄 𝗽𝗿𝗼𝗽𝗼𝘀𝗮𝗹: Syncing binary data github.com/powersync-j...

Hit this toggle on our diagnostics app if you're using our new Rust-based sync client.

Day 31: I have been tinkering with syncing my offline sqlite DB with my remote database and damn it’s hard. Recently, I found out about powersync and their cool plug and play solution for exactly this. They have nice dart package for it and it also works with drift DB. Very promising. #flutter

@k081e.bsky.social‬ and Steven present a demo and workshop on using PowerSync with Swift at Denver Cocoaheads on Tuesday, Sep 9. RSVP here: www.meetup.com/cocoaheadsd...

We've started creating public proposals on GitHub for major product improvements being considered/planned. The goal is to get more community feedback, earlier. 🧵 with the first round of proposals↓

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.

𝗡𝗲𝘄 𝗿𝗲𝗹𝗲𝗮𝘀𝗲: High performance diffs (experimental 🧪) Differential watch queries allow fine-grained UI updates by scanning tables to spot diffs. They're powerful, but can become slow on large tables. Trigger-based diffs solve this by (1) only processing the rows that changed, not the full dataset &

PowerSync 🤝 Expo

We've updated our comparison post of @reactnative.dev‬ local database options, including work by @ospfranco.com‬, @expo.dev‬, and @livestore.dev‬. Link ↓ www.powersync.com/blog/react-...

Proof of concept integration between the @powersync.com Swift SDK and Structured Queries by @pointfree.co Should be able to ship this :) github.com/powersync-ja...

Ok, ready to wrap up the ground work! ✅ Firebase -> Supabase, both database and auth ✅ PowerSync in place and API layer refactored accordingly ✅ Some touch ups stirred up by the refactoring Now to make sure migrating goes smooth for users on the new version. #buildinpublic #iosdev #indiedev

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.

React developers regularly asked about support for React memoization in useQuery-based components. Read the story of how 𝙄𝙣𝙘𝙧𝙚𝙢𝙚𝙣𝙩𝙖𝙡 𝙒𝙖𝙩𝙘𝙝𝙚𝙙 𝙌𝙪𝙚𝙧𝙞𝙚𝙨 enables that in our July update. ↓

PowerSync MySQL backend database support has reached Beta!

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‬

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.

Simon Binder reflects on Fluttercon USA 2025 in New York "At a previous Fluttercon I attended, I had the impression that there were relatively few intermediate and advanced talks, so it was good to see more variance this time. " Link next ↓ CC: @flutter.dev‬

𝗡𝗲𝘄 𝗥𝗲𝗹𝗲𝗮𝘀𝗲: Incremental & Differential Watch Queries for JavaScript 🚀 Build snappier UIs w/o excessive re-renders. • 𝗜𝗻𝗰𝗿𝗲𝗺𝗲𝗻𝘁𝗮𝗹 𝗾𝘂𝗲𝗿𝗶𝗲𝘀: return results only when the rows you care about change. • 𝗗𝗶𝗳𝗳𝗲𝗿𝗲𝗻𝘁𝗶𝗮𝗹 𝗾𝘂𝗲𝗿𝗶𝗲𝘀: sends a structured diff of updates so you make more fine-grained UI patches.