Exploring Offline-First Data Sync with effect/schema/sqlfx/effect-rx and Backend Integration
Has anybody here has tackled offline-first data sync using sqlite with effect/schema/sqlfx/effect-rx? If so, how did you manage sync with your backend? I'm aware of https://github.com/evoluhq/evolu but it doesn't fit my use case as I have a central db and data shared between users. Right now I don't use client side sqlite, instead I store things in localstorage (mmkv) as a cache but it doesn't really work well for enabling true local-first offline support. I'd like to use sqlite on the client but haven't been able to figure out a good solution for keeping data in sync between sqlite and my postgres backend.