Algorithm data synchronization (SQLite to Online Database)

Question

I am creating an app which have synchronised data with an online server. What is the best approach?

I thought having a local database (SQLite) which will synchronise with an online database with the same structure. Would it be better an online XML or an online database?

Other question. Is there any algorithm known for data synchronisation ?

depends entirely on your data and whether it can change on the server, on the device or at both places. — Renard, Apr 29 '12 at 19:35
depends also on the bandwidth between the local client and the online database, i.e. how much data you can send or receive. — Antti Huima, Apr 29 '12 at 20:07
More infos: initially will be unidirectional SQLite to remote server... Thanks — Thiago C. S Ventura, Apr 30 '12 at 01:35
Just reviewing my questions. And for sure nowadays I would it in a RESTful way. — Thiago C. S Ventura, Jan 05 '15 at 21:32
https://stackoverflow.com/questions/4008015/android-sqlite-bidirectional-synchronization-sqlite — Bernardo Ramos, Jul 01 '17 at 03:25

score 1 · Answer 1 · answered Jun 05 '12 at 21:34

The best practice is to model your application using a content provider and then connect a sample sync adapter. http://developer.android.com/resources/samples/NotePad/index.html http://developer.android.com/resources/samples/SampleSyncAdapter/index.html

You can find these sample in the Android SDK. In Eclipse,

File >
New >
Android Project >
Create project from existing sample >
Android 2.1 >
Select desired project

(Things start to change once you hit the tablets and Android 4.0, so 7 or 8 are your best bets.)

The blog post below explains the Sync Adapter well. http://www.c99.org/2010/01/23/writing-an-android-sync-provider-part-1/

If you want to start quickly, parse your XML, and then wrap your SQLite implementation around it, use the following link. http://andrewgertig.com/2010/07/android-and-ruby-on-rails/

Algorithm data synchronization (SQLite to Online Database)

1 Answers1