Creating and Implementing a Database for iOS Xcode

Question

Brief: Ok. I'm looking to implement and create a database with several tables to put in a iOS app. I know SQLite is an option but can you put SQLite online so data stays current on each device? I haven't made a SQLite database but I've done a MySQL through PHP.

Question: What route should I use? I've just heard of SQLite and don't want to waste time. Please in your answer say how I can achieve an implement this table. I currently have a site so could I host a SQLite database. If so please link to a tutorial/guide. Also if anyone has found one: a tutorial to implement this database in Xcode.

Just looking for the best route to go but I'm not looking to pay for something like Kumlos.

nyanev · Accepted Answer · 2012-08-16 06:04:59Z

4

You can make databse into your server and one sqlite in you iOS application. Then you can synchronize them. Make one php script that retrive information from database and the convert it to JSON. From you app download this JSON parse it and then save it to the db. This is approach that I use.

Update: http://www.raywenderlich.com/2941/how-to-write-a-simple-phpmysql-web-service-for-an-ios-app

edited Aug 16, 2012 at 6:04

answered Aug 16, 2012 at 5:58

nyanev

11.6k7 gold badges50 silver badges77 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

keji Over a year ago

Have any links that could help?

keji Over a year ago

Ok thanks but what if I wanted to put my data in a nsarray like [listOfItems addobject:@"Item1"]

nyanev Over a year ago

What do you want to pot in an array?

keji Over a year ago

I have products and their descriptions and prices. I plan on feeding the array to a table

Collectives™ on Stack Overflow

Creating and Implementing a Database for iOS Xcode

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related