How to copy / export or sync sqlite db from device to computer?

Question

coolguy1981 Author

Level 1

4 points

How to copy / export or sync sqlite db from device to computer?

I am wondering is there any way to back up / sync the data from sqlite in iphone / ipod touch device back to computer. For example, I have an application wich use sqlite database in iphone / ipod touch device. So if user has edited anything then I would like to get the data back in the computer so that i can sync up and include the existing data with new ones. Thanks for any suggestions and advices.

MacBook Pro 15", Mac OS X (10.5.5)

Posted on Nov 13, 2008 8:48 PM

Reply

Answer 1

desaro

Level 1

8 points

Nov 13, 2008 9:03 PM in response to coolguy1981

You have to do it manually. There are tons of ways to do it: bonjour, ftp, http, etc.

Reply

Answer 2

coolguy1981 Author

Level 1

4 points

Nov 13, 2008 9:32 PM in response to desaro

Can you give one simple example to do it? I was trying to import using SQLite Database Browser 1.3. But i am not sure how can i actually find the path that the sqlite database is locating in one of the application that i was installed in iphone/ipod touch device which is connecting to my macbook.If we can do it manually if there is anyway that we can also do it by programming? Thanks/

Reply

Answer 3

uprise78

Level 1

100 points

Nov 14, 2008 7:01 AM in response to coolguy1981

When I said 'manually' I just meant that there is no code written to do it for you. You have to write it yourself. Example code for something of this level if far outside the scope of this message board. It is nowhere near trivial no matter which method you use.

Reply

Answer 4

Nov 14, 2008 7:24 PM in response to coolguy1981

There is an SQLite plugin for firefox that I use. The only bad part is that the target DB changes with every build, so just NSLog the real path to the DB when you debug the app. I havent figured out how to actually pull the DB off the phone, but still it's helpful.

Reply

Answer 5

Nov 16, 2008 11:15 PM in response to Steve High

I seem to remember using the Organizer in Xcode to get my app's database off my phone once. I don't have it in front of me right now so I can't check.

Reply