SQLiteDB Syncing

Discussion in 'iOS Programming' started by soundz, Jul 15, 2008.

  1. soundz macrumors newbie

    Jul 15, 2008

    I would like to know if SQLiteDB provided with the iPhone SDK provides some facility to sync data from a database server to the SQLiteDB.

    Specifically, this is our scenario. We have a web application that's running on Oracle. Can we sync data from Oracle to the iPhone over the cellular network? If not Oracle, how about MySQL, MSSQL, etc...? Are there any 3rd party solutions?

    If there's no sync'ing technologies currently available, would it be feasible to write our own sync'ing program?


  2. detz macrumors 65816

    Jun 29, 2007
    Depends on how much data you have going back and forth but it seem that writing your own would be the best approach so you only sync the stuff you need. Shouldn't be too hard.
  3. ayasin macrumors 6502

    Jun 26, 2008
    Database syncing is NOT trivial if you want a 2 way sync. If it's just one way and the server always wins it's easy enough, but when you have a two way sync you have to consider collisions and that's where it becomes complex. It's best if you can find something to do this for you, but I don't know of anything off the top of my head that does it. You should also consider what interface you're going to use to manage collisions and such if you need to...
  4. cleverapps macrumors newbie

    Aug 1, 2008
    EntropyDB (http://code.google.com/p/entropydb/) has a replication mechanism but not for SQL servers like Oracle.

Share This Page