Best Local Database Options for Offline-First Flutter POS Web/Desktop App with Sync Capabilities
I’m working on a Flutter POS app for web and desktop platforms. There’s already a mobile version, but for web and desktop, the architecture needs to be offline-first so transactions can be created and stored locally, then synced with an online database once connectivity is available.
I've considered Hive, but its query capabilities aren’t robust enough for what I need, and SQLite isn’t an option for the web. Additionally, AWS App Sync & Firebase Realtime Database doesn’t fit the project requirements, so I'm left exploring alternatives that:
- Support robust offline data storage and querying.
- Are compatible with both web and desktop (Flutter).
- Have reliable sync options or can integrate easily with sync logic for periodic updates to an online database.
Mongo-DB is our cloud database for mobile app as of now. Any recommendations on database solutions for this use case or alternative approaches for syncing offline transactions to an online database? Would love to hear from anyone who has experience building offline-first apps in Flutter!