Our great sponsors
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
I don't have a preference for SQL vs NoSQL; the app data is simple enough (think something like a note-taking app that can sync if you have multiple devices) that I do not think it matters. However, it would be really nice if direct device-to-device sync is supported so I don't need to bother with accounts or cloud. Some of the options I've found: - Couchbase Lite for Dart - sync is an enterprise feature, but Couchbase Lite for Dart is a community-built solution. Not sure how well that will work. - firebase - doesn't seem offline-first, just allows for temporary loss of connectivity - realm with Device Sync - seems most promising - ObjectBox Sync - no user-specific data sync. All data is sent to all app users! - drift + roll my own sync: yikes!
In any case, you might be interested in tudo - it's an offline-first, realtime to-do app implemented using Flutter/sqlite_crdt on the frontend and Dart-Shelf/postgres_crdt on the backend. It even uses websockets for continuous sync.
sqlite_crdt and postgres_crdt are implementations of the above