How to sync flutter app's offline data with online database efficiently
lets say I have a todo app that stores the data in sqflite database(locally on the phone) when the app goes online I want the data to be synced with my online database say mongodb or firestore.I don't want to do complete overwrites or creating the new table everytime,I am looking for some efficient solution that only updates the changes to the database.
Answer
Firebase Cloud Firestore makes all of this for you. If You can't use this, other solution is much more complicated as syncing information can be very tricky.
Imagine the user has 2 devices, both saving the same data, which version should the server keep, the newest created data, or the data the server received first?
SQLite is good for structured data, but you could save your data as a JSON string using System Preferences and just push that JSON to the server, it's a lot simpler if can do it this way.
Again, this really not a simple answer to give and varies from project to project.