HACKER Q&A
📣 nate

SQLite offline first sync options?


I'm confused, and my AI chat buddies seem to be too. I have an iOS React Native app that stores data in a sqlite db. What are the best options these days for getting that data synced to the cloud and back?

My goals:

- offer this local data as something users can maybe alter and use from a web app or another device. There won't be a lot of frequent real time merging and syncing going on. I imagine it's going to be an infrequent sync operation. - I'd rather not rewrite everything to use a different datastore. - I see there are sqlite merging and hosting options (fly.io and litesync.io) but I'm not quickly groking if they are what I want here.

Really curious what you all are doing with projects similar to this.


  👤 ochiba Accepted Answer ✓
I am quite familiar with this space. What is your backend/database stack? That is a factor.

I'm a cofounder of PowerSync [1] which provides bi-directional sync between Postgres and SQLite and has a client SDK for React Native.

There is an RN tutorial that may be helpful [2]

[1] https://www.powersync.com/

[2] https://bndkt.com/blog/2023/building-an-offline-first-chat-a...