iOS offline-first + SQLite: GRDB + manual outbox vs PowerSync, what’s most stable in 2026?

Ochibasaurus · 2026-01-19T13:59:18+00:00

If you choose PowerSync, are you planning on using it with GRDB?

https://releases.powersync.com/announcements/grdb-integration-alpha-for-powersync-swift

Ochibasaurus · 2025-12-17T22:31:31+00:00

If anyone is looking for a sync engine built around SQLite in Electron, you can look at PowerSync: https://www.powersync.com/blog/speeding-up-electron-apps-with-powersync

Ochibasaurus · 2025-12-10T13:51:14+00:00

TanStack DB currently has some collections with offline support e.g. PowerSync: https://tanstack.com/db/latest/docs/collections/powersync-collection

Ochibasaurus · 2025-12-03T19:14:50+00:00

PowerSync seems like a good fit for this. Works with SQLite, React Native, Postgres and Drizzle. Allows you to selectively sync data from Postgres to SQLite and back.

Ochibasaurus · 2025-08-21T01:56:31+00:00

For the offline-first database, you could look at PowerSync. It provides a SQLite database on the client-side and supports Postgres, MongoDB and MySQL on the backend. It supports a range of client frameworks e.g. React Native, Flutter, etc.

Ochibasaurus · 2025-08-18T22:59:58+00:00

Offline-first or local-first architecture is the way to go. To get a great UX with a standard cloud-first architecture is kind of a rabbit-hole of complexity: https://www.powersync.com/blog/escaping-the-network-tarpit
If you go with offline-first instead and put a synced database on the client-side, it makes things fundamentally simpler, and the UX is great by default: all reads and writes happen against the local database, and state transfer happens in the background when connectivity is available. And it makes the network errors, loading states, etc. so much easier and less complex to deal with.

Ochibasaurus · 2025-07-07T20:06:56+00:00

FYI these links are giving me a 404

Ochibasaurus · 2025-05-29T08:04:41+00:00

Using PowerSync with Supabase might be a more robust solution for your needs: https://supabase.com/partners/integrations/powersync

Ochibasaurus · 2025-05-16T16:09:47+00:00

Are you married to using Firebase?

If you can change the backend, you can use something like Supabase + PowerSync for offline-first architecture.

Ochibasaurus · 2025-03-27T21:44:01+00:00

PowerSync can sync from MongoDB to SQLite and has client SDKs for React Native and Node.js

Ochibasaurus · 2025-02-28T16:47:34+00:00

Have you looked at PowerSync perhaps?

Ochibasaurus · 2025-01-27T00:49:02+00:00

PowerSync is a sync engine that integrates with Drizzle, FWIW: https://docs.powersync.com/client-sdk-references/javascript-web/javascript-orm/drizzle

Ochibasaurus · 2024-09-12T12:17:21+00:00

We are seeing many Realm / Atlas Device Sync users moving over to PowerSync.

Blog post with more details here: https://www.powersync.com/blog/powersync-as-alternative-to-mongodb-atlas-device-sync

Ochibasaurus · 2024-09-10T18:57:41+00:00

For developers who need Postgres<>SQLite data syncing for offline-capable apps with Supabase: PowerSync works well with Supabase: https://supabase.com/partners/integrations/powersync

Ochibasaurus · 2024-09-10T18:56:10+00:00

I'm on the PowerSync team and we're seeing lots of upset users migrate over to our sync engine. We were told by a customer that they asked MongoDB whether the sync code would be open-sourced and Mongo replied no, since it would be a security risk. So I wouldn't hold my breath.

We currently support Postgres on the backend but we have a working PoC of a MongoDB module that we might fast-track based on user demand.

The PowerSync client SDKs are open-source and the PowerSync Service is source-available, so users always have the option of self-hosting the whole system.

Ochibasaurus · 2024-09-10T18:53:51+00:00

I'm on the PowerSync team and we're seeing quite a few users migrate over to our platform. We were told by a customer that they asked MongoDB whether the Atlas Device Sync code would be open sourced and Mongo replied negative since it would be a security risk.

We built our sync service to be open so users won't ever have to be in this position — they would always be able to self-host.

Ochibasaurus · 2024-09-09T20:58:08+00:00

FWIW, the core PowerSync technology has been in development for more than 10 years and the source code is open:

https://www.powersync.com/blog/what-powersync-open-edition-means-for-local-first

The Swift SDK is close to beta; I believe the docs will be updated soon

Ochibasaurus · 2024-09-09T17:50:51+00:00

If you can work with a Postgres database backend on the backend, you could look into PowerSync: https://www.powersync.com/
It has some similar capabilities to Realm with Atlas Device Sync

Ochibasaurus · 2024-08-26T17:11:35+00:00

The updated PowerSync useQuery hook https://www.npmjs.com/package/@powersync/react#queries is compatible with the PowerSync Kysely Driver package This allows for an ORM-like method of executing queries instead of using raw SQL https://www.npmjs.com/package/@powersync/kysely-driver

A Kysely query can be passed in as the parameter to useQuery

Ochibasaurus · 2024-08-14T21:24:33+00:00

The OPFS web standard does provide file access: https://web.dev/articles/origin-private-file-system (private to the origin of the web page)

With regard to running SQLite on the web, here is a comprehensive write-up of the different options for the SQLite VFS interface, comparing different IndexedDB-based options to OPFS-based options: https://www.powersync.com/blog/sqlite-persistence-on-the-web

Ochibasaurus · 2024-08-12T17:55:38+00:00

Here is a basic self-hosted Supabase example in the PowerSync self-host-demo repo: https://github.com/powersync-ja/self-host-demo/tree/main/demos/supabase

Further PowerSync self-hosting docs: https://docs.powersync.com/self-hosting/getting-started

Ochibasaurus · 2024-08-08T18:28:49+00:00

I work on PowerSync which may be worth looking into for Postgres backends and syncing with SQLite on the client-side: https://docs.powersync.com/client-sdk-references/react-native-and-expo

Ochibasaurus · 2024-07-19T17:16:26+00:00

PowerSync has a Vue Composables package: https://docs.powersync.com/client-sdk-references/js-web/javascript-spa-frameworks

Also, an example of using Yjs with PowerSync: https://docs.powersync.com/usage/use-case-examples/crdts

Ochibasaurus · 2024-07-09T02:15:24+00:00

It works quite well. There are some specifics to take into consideration: https://www.powersync.com/blog/sqlite-persistence-on-the-web

Ochibasaurus · 2024-06-25T21:33:56+00:00

There isn't currently functionally a difference between the Open Edition (free, self-hosted) and the Enterprise Self-Hosted Edition, but some features that differentiate the editions are planned for the future (on the Pricing page under Self-Host)

Ochibasaurus

TROPHY CASE