Our October & November product update is here! The feature story is our new TanStack DB Integration – you can now use TanStack DB collections on top of a PowerSync-backed SQLite store www.powersync.com/blog/powers...

Electron developers: Alex Dumouchelle from the PowerSync community also made this video to help you decide whether to put PowerSync in Electron's main or renderer process, accompanying his blog post: www.youtube.com/watch?v=zFl... Alex is the founder of Open March, an open-source drill writing app

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:

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

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! 🔥

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!

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

We track the state of the art of using 𝗦𝗤𝗟𝗶𝘁𝗲 𝗶𝗻 𝘄𝗲𝗯 𝗯𝗿𝗼𝘄𝘀𝗲𝗿𝘀. 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.

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