Skip to content Skip to sidebar Skip to footer
Home / Android / Database / Mysql / Sqlite / Synchronization

Sync Databases Mysql Sqlite

Post a Comment
Possible Duplicate: how to sync SQLite database on android phone with MySQL database on server? I am wondering what is the best approach to updating a database on an Application

Solution 1:

Why not use a timestamp (or version field) in the mysql database on your server, then when the android app is run it imply checks the timestamp/version to see if there is a change since it needs to be updated. If the timestamp/version is newer than previously found download the updated dataset else simply use what is already stored.

Solution 2:

Unless you want to process the whole data on the device (depending on how big the database..etc...) it's probably better to do the conversion offline on the server and transfer the files. There are some tools available to convert your MySQL database into SQLite. http://forums.mysql.com/read.php?145,68269,92627

Post a Comment for "Sync Databases Mysql Sqlite"