Connecting to a MySQL database using Xcode and Objective-C

Question

I have been interested in working with a MySQL database in my iPhone or Mac projects. How is a connection performed in Objective-C?

I only had a bit of experience with PHP, but heck, that is a bit too different =/

Answer 1

Check this tutorial for connectivity with SQLite.

You will not be able to connect to MySQL directly from the iPhone. You must use some intermediate layer such as a Web application with PHP.

So, you will have something like this:

1. iPhone POSTING a request to the WebServer using HTTP
2. Web Server connecting to the MySQL database
3. Web Server returning data to the iPhone (XML, plain text)
4. iPhone processing the data

You can use this technique to query and insert/update/delete data.

Once I found this library for MySQL, and I am aware how it works.

Answer 2

It's a much better option not to deal directly with MySQL, but use Apple's Core Data API.

It allows you to manage an relational database without having to write SQL. It's very fast, very useful. Good stuff.

Answer 3

Try absrd which recycles connections across concurrent threads (queues).