TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

Ask HN: SQLite offline first sync options?

4 pointsby nateabout 1 year ago
I&#x27;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?<p>My goals:<p>- offer this local data as something users can maybe alter and use from a web app or another device. There won&#x27;t be a lot of frequent real time merging and syncing going on. I imagine it&#x27;s going to be an infrequent sync operation. - I&#x27;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&#x27;m not quickly groking if they are what I want here.<p>Really curious what you all are doing with projects similar to this.

1 comment

ochibaabout 1 year ago
I am quite familiar with this space. What is your backend&#x2F;database stack? That is a factor.<p>I&#x27;m a cofounder of PowerSync [1] which provides bi-directional sync between Postgres and SQLite and has a client SDK for React Native.<p>There is an RN tutorial that may be helpful [2]<p>[1] <a href="https:&#x2F;&#x2F;www.powersync.com&#x2F;" rel="nofollow">https:&#x2F;&#x2F;www.powersync.com&#x2F;</a><p>[2] <a href="https:&#x2F;&#x2F;bndkt.com&#x2F;blog&#x2F;2023&#x2F;building-an-offline-first-chat-app-using-powersync-and-supabase" rel="nofollow">https:&#x2F;&#x2F;bndkt.com&#x2F;blog&#x2F;2023&#x2F;building-an-offline-first-chat-a...</a>
评论 #39784807 未加载