2

In my app I have a SQLite DB want to backup to server but what I want is one to one synchronization for off-line backup (e.g. standalone SQLite file instead of a centralized MySQL server, mainly performance reason and I don't need real time query)

Ideally I don't want to upload the database everytime when I need to sync, prefer only sync the changes?

Are there any existing solution for this? (I can consider using other file DB as currently I mainly use SQLite as Key-Value database)

Thanks.

Ryan
  • 10,041
  • 27
  • 91
  • 156

1 Answers1

0

As you are willing to consider using a different DB, take a look at TouchDB-Android. This syncs a database on an Android device to a CouchDB server. There is a related project SyncPoint, that automates setting up a database for each user.

We are using TouchDb-iOS for our product at the moment are planning work on an Android version using TouchDB-Android soon.

The development community is active. Check out the user group.

lambmj
  • 1,843
  • 2
  • 21
  • 27
  • Hi, thanks for your input. Our main concern is don't want to maintain a centralized database server, just use the remote server as backup purpose. Eventually user will be very easy to download their data from our server. – Ryan Nov 09 '12 at 03:17
  • I think you are describing something very similar to Apple's iCloud. It has the ability to store SQLLite (aka CoreData) databases and sync them between devices. CouchDB can be used to do something similar and can be used in a decentralized manner. – lambmj Nov 09 '12 at 13:12