SQLiteDB Syncing - MacRumors Forums
Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > Apple Systems and Services > Programming > iPhone/iPad Programming

Reply
 
Thread Tools Search this Thread Display Modes
Old Jul 15, 2008, 03:53 PM   #1
soundz
macrumors newbie
 
Join Date: Jul 2008
SQLiteDB Syncing

Hi,

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?

Thanks,

Jimmy
soundz is offline   0 Reply With Quote
Old Jul 15, 2008, 04:09 PM   #2
detz
macrumors 65816
 
Join Date: Jun 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.
detz is offline   0 Reply With Quote
Old Jul 15, 2008, 10:26 PM   #3
ayasin
macrumors 6502
 
Join Date: Jun 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...
__________________
iNeedStuff Shopping Assistant - MacLife called it "the ultimate iPhone grocery list maker".
Follow me on Twitter
Need a developer? PM me.
ayasin is offline   0 Reply With Quote
Old Aug 2, 2008, 02:15 AM   #4
cleverapps
macrumors newbie
 
Join Date: Aug 2008
Quote:
Originally Posted by soundz View Post
Hi,

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?

Thanks,

Jimmy
EntropyDB (http://code.google.com/p/entropydb/) has a replication mechanism but not for SQL servers like Oracle.
cleverapps is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Systems and Services > Programming > iPhone/iPad Programming

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
Better syncing? Faize iPhone Tips, Help and Troubleshooting 1 Oct 20, 2012 06:51 PM
Syncing.... saladiro iOS 6 1 Oct 1, 2012 07:59 PM
Syncing old itunes account not syncing apps? Lewb iPhone and iPod touch Apps 0 Sep 14, 2012 07:28 AM
Trying to inject contacts SQLITEDB file into phone Schitz iPhone Tips, Help and Troubleshooting 0 Jul 18, 2012 02:21 PM
Problem syncing iPhone 3GS - stuck at "Syncing bookmarks" baskervi iPhone Tips, Help and Troubleshooting 0 Jul 1, 2012 11:12 AM

Forum Jump

All times are GMT -5. The time now is 06:33 PM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC