This question is locked. New answers and comments are not allowed.
Hi we are planning to create iPhone and iPad apps using Icenium. We will have a backend remote database exposed via OData services. I know kendo UI works quite well with odata sources. From what I have read Icenium provides WebSQL and Sqlite plugins. Are there any cons of using sqllite compared to websql? Also, I have never designed mobile app before, but I understand that I would need to cache some data locally? What is the best approach for it? I envisage it like this:
- When app first loads it downloads all the data from remote DB and stores it in local DB
- When app performs any CRUD operations, it pushes data to remote DB and stores it locally as well.
- When app starts next time, it passes last updated date (probably date it was run last) to the remote DB, and remote DB passes back only data that has been changed since
the date passed.
Is this right way of doing it? My biggest concern is that database can still go out of sync, and also I am not sure how good Sqlite performance is on mobile device. Also should I still have some background thread that sync data constantly every so often?
- When app first loads it downloads all the data from remote DB and stores it in local DB
- When app performs any CRUD operations, it pushes data to remote DB and stores it locally as well.
- When app starts next time, it passes last updated date (probably date it was run last) to the remote DB, and remote DB passes back only data that has been changed since
the date passed.
Is this right way of doing it? My biggest concern is that database can still go out of sync, and also I am not sure how good Sqlite performance is on mobile device. Also should I still have some background thread that sync data constantly every so often?