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 =/

Are you sure you mean MySQL and no SQLite which is usually use for mobile/desktop applications? — seppo0010, Feb 01 '11 at 02:26
Hmm... I would like to hear more about that too, then. Thank you. — Saturn, Feb 01 '11 at 02:28

score 13 · Accepted Answer · edited Nov 11 '17 at 14:38

13

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:

iPhone POSTING a request to the WebServer using HTTP
Web Server connecting to the MySQL database
Web Server returning data to the iPhone (XML, plain text)
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.

edited Nov 11 '17 at 14:38

Peter Mortensen

30,738
21
105
131

answered Feb 01 '11 at 02:42

KingofBliss

15,055
6
50
72

Re: You will not be able to connect to MySQL directly from the iPhone. >> This isn't exactly true. I have a working version of MCPKit connecting to a remote MySQL database. But your suggestion about using a PHP/web intermediate layer is a great recommendation. – mattlangtree Jul 11 '12 at 00:27
Here is the updated link to donwload mysql Library: http://www.eval-art.com/2009/06/22/mysqlframework-for-iphone/ – João Nunes Apr 04 '14 at 07:47

score 3 · Answer 2 · edited May 03 '12 at 11:57

3

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.

edited May 03 '12 at 11:57

answered Feb 01 '11 at 02:42

Kenny Wyland

20,844
26
117
229

1

Technically Core Data is not a relational database but rather an object graph manager (if you want to get technical). – walkingbrad Apr 26 '13 at 03:21

score 1 · Answer 3 · edited Nov 11 '17 at 14:40

1

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

edited Nov 11 '17 at 14:40

Peter Mortensen

30,738
21
105
131

answered Sep 14 '12 at 06:44

hernan saab

9
2

score 1 · Answer 4 · edited Nov 11 '17 at 14:40

1

If you want to connect to a MySQL database, use MySQL's Connector/C API library which, as Objective-C is a strict superset of C, you can use without any issues. I helped someone with the installation of it here.

edited Nov 11 '17 at 14:40

Peter Mortensen

30,738
21
105
131

answered Apr 14 '11 at 15:44

Nektarios

10,173
8
63
93

Connecting to a MySQL database using Xcode and Objective-C

4 Answers4

Linked