Ask HN: SQLite offline first sync options?

[nate]

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]

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

[nate → ochiba]

Hey! Thanks for this. I have no backend yet, so it can be whatever makes sense. This is all just planning for what I want to do next here. So postgres in the back is fine by me. This looks pretty great. Will dive in.

[ochiba → nate]

Okay great. In that case I can also recommend Supabase [1] since it's an easy way to spin up a Postgres backend and gives you auth, edge functions, etc.

[1] https://supabase.com/