3 ms·
Ask HN: 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 3y agoI 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/ https://www.powersync.com/ [2] https://bndkt.com/blog/2023/building-an-offline-first-chat-app-using-powersync-and-supabase https://bndkt.com/blog/2023/building-an-offline-first-chat-a...
- nate 3y agoHey! 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 3y agoOkay 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/ https://supabase.com/