I didn't need PowerSync, so I built sync on top of SQLite in React Native

Short summary

A developer built a custom offline sync layer on SQLite for a React Native workout tracker instead of using PowerSync, ElectricSQL, WatermelonDB, or RxDB. The design uses a sync queue with last-write-wins conflict resolution, operation compaction before push, and a single environment variable to gate sync. The approach ships local-first and adds sync later without replacing the data layer.

• •Custom sync queue on SQLite replaces four heavyweight frameworks
• •Last-write-wins with operation compaction handles offline conflicts
• •Single env var gates sync; local app works standalone without server

Generated with AI, which can make mistakes.