Native iPad Apps / SQLite

Question

Good afternoon, everyone .

 

I have a question and so far I could not find information about it, tell them .

 

I'm creating an iPad application using Titanium to "transform " my JS code to Objective- C , so far I have advanced sick using SQLite as database.

 

My application is a catalog of products , these products are rescued from the SQLite database as I told you, I also intend to make a kind of shopping cart and other things , all this will be stored in the database (on file I work with sqlite ) .

 

Now my question is , once you finish the software and upload it to Appstore, then it will download to my iPad, I will use it , I can store data, but as the rescue you ? , And be able to get all the data coming in from my iPad ? , The rescue the idea is to input data in a SQL Server / MySQL data is on my computer (PC ) or a MacBook.

 

I hope you can help me , many greetings and thanks in advance .

Answer 1

You could enable iTunes document sharing with UIFileSharingEnabled in the info.plist and then copy the sqlite database file to the Documents directory in your application, if it isn't there already.

I've been able to do this and was able to read the file just fine with sqlite on the desktop.

unfortunately it isn't automatic. Someone would need to go into iTunes and manually copy the file over each time.

 

Enabling UIFileSharingEnabled option one should be able to access certain files by iTunes. 

 

Anyone know if there is another way to manipulate the file. Sqlite and upload by FTP from an iPad to another location or send the file by email?

Answer 2

http://newiosnews.com/database-driven-tables-sqlite

http://newiosnews.com/database-driven-tables-sqlite-part-1/