Lightnews — Scholar-powered news

PowerSync @powersync.com · 2d

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

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

Reposted by PowerSync

Sync Conf @syncconf.bsky.social · 4d

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.

1 1 3

PowerSync @powersync.com · 4d

We created a full tutorial + demo app:

www.powersync.com/blog/keep-b...

Keep Background Apps Fresh with Expo Background Tasks and PowerSync

Use Expo background tasks and PowerSync to keep app databases fresh while apps are minimized.

www.powersync.com

PowerSync @powersync.com · 4d

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

1 3

PowerSync @powersync.com · 4d

Read the release notes:

releases.powersync.com/announcemen...

Improved Attachment Utilities in the Dart / Flutter SDK

Overview The PowerSync Dart/Flutter SDK now includes improved attachment utilities under package:powersync_core/attachments/attachments.dart . This new...

releases.powersync.com

PowerSync @powersync.com · 4d

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

1

PowerSync @powersync.com · 8d

Using ORMs With PowerSync

As much as some developers love to drop into raw SQL for advanced queries, it can be annoying to have to write SQL for simple queries, often because there’s no type-safety. Using an ORM helps address this challenge.

www.powersync.com

PowerSync @powersync.com · 8d

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!

1 1 1

PowerSync @powersync.com · 9d

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

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

1

PowerSync @powersync.com · 10d

Read the full post:

www.powersync.com/blog/collab...

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 includes a "Sync Active" toggle that you can use to try out concurrent edits.

www.powersync.com

PowerSync @powersync.com · 10d

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 👏

1

PowerSync @powersync.com · 10d

So, when a user inserts some characters, formats a range of text, etc., their client inserts a row containing that update (as arbitrary JSON) into their local PowerSync table.

Eventually, those rows reach the backend database which assigns them an auto-incrementing server_version.

...

1

PowerSync @powersync.com · 10d

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.

...

1 1

Reposted by PowerSync

Matthew Weidner @mweidner.bsky.social · 10d

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

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

3 13

PowerSync @powersync.com · 16d

More here:

www.powersync.com/blog/speedi...

Speeding up PowerSync with a SQLite extension written in Rust

How we increased engineering velocity and sync performance in PowerSync’s cross-platform SDKs using Rust.

www.powersync.com

PowerSync @powersync.com · 16d

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

1 4

PowerSync @powersync.com · 17d

If you're at FlutterconEU in Berlin:

Catch Simon Binder's talk on synced in-app databases tomorrow @ 12pm.

#ftcon25eu #FlutterDev

PowerSync @powersync.com · 19d

We cover how to implement this in our @expo.dev example project here:

expo.dev/blog/what-s...

What synced in-app SQLite brings to Expo apps

Combine Expo and PowerSync to bring flow state joy to full stack development.

expo.dev

PowerSync @powersync.com · 19d

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:

1 1

PowerSync @powersync.com · 22d

Docs:

docs.powersync.com/client-sdk-...

SQL libraries - PowerSync

Reference for using PowerSync with SQL mapping libraries.

docs.powersync.com

PowerSync @powersync.com · 22d

Full release notes:

releases.powersync.com/announcemen...

More robust SQL queries for Kotlin apps: Room and SQLDelight

The PowerSync Kotlin SDK lets you sync your backend database with a client-side SQLite database. On the client, you interact with the database using SQL....

releases.powersync.com

1

PowerSync @powersync.com · 22d

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.

1

PowerSync @powersync.com · 23d

Read more about in-app SQLite in @expo.dev apps:

expo.dev/blog/what-s...

What synced in-app SQLite brings to Expo apps

Combine Expo and PowerSync to bring flow state joy to full stack development.

expo.dev

1

PowerSync @powersync.com · 23d

"Even though SQL is probably older than you are, it’s still the go-to mechanism for expressing most data querying needs."

- Chriztiaan_dev

1 1

PowerSync @powersync.com · 24d

Christiaan Landman wrote a whole blog post about this:

expo.dev/blog/what-s...

What synced in-app SQLite brings to Expo apps

Combine Expo and PowerSync to bring flow state joy to full stack development.

expo.dev

1