What database can I use in the iPhone app?

Question

I want to create an iPhone app that will sync with its web site client application for websites.

I currently have data stored in a .plist. Would SQLite be the best way to do this?

Also I will need to set up user accounts / registration database. Any sites or tutorials that do this?

Thanks.

Answer 1

@Faisal:

Hey.

Yes, you can use SQlite, but I would suggest you switch to the MySQL database on your database server, and then you can parse the data using JSON and extract the data.

This will reduce the overhead of synchronizing the database, and the iPhone application will also be easier.

EDIT:

If you are new and do not have a database, it is better to start with Sqlite, and then go to the main data to store your data on the iPhone or in this case MySQL to store your data on the server.

EDIT-2 :

This is a link that gives you many different possibilities for exploring SQlite and its implementation in the iPhone application.

Where is the best SQLite 3 tutorial for iPhone-SDK?

Hope this helps you :)

Answer 2

You have two different problems; local storage and client server data.

For local storage, the data model is simple (based on the comments on the PARTH answer), and thus Core Data will be perfect.

No need to learn SQLite before using Core Data. Master data is a persistence graph of objects and a solution for managing change. SQLite is one of Core Data's persistence mechanisms, but it is an implementation detail that is pretty much completely hidden behind a higher-level API.

For the client / server part , using HTTP + JSON will work just fine for communicating with your application on the server.

On the server side, go to any of the many different solutions already written for managing this type of data. For this kind of application, PHP + MySQL is probably a perfectly acceptable solution in this registration + a simple data warehouse is a problem that has been solved about a million times with this combination of tools (and thus you can find 100s of records about , how to do it).