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
– seppo0010, Commented Feb 1, 2011 at 2:26
Hmm... I would like to hear more about that too, then. Thank you. — Saturn
– Saturn, Commented Feb 1, 2011 at 2:28

Peter Mortensen · Accepted Answer · 2017-11-11 14:38:49Z

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, 2017 at 14:38

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered Feb 1, 2011 at 2:42

KingofBliss

15.1k6 gold badges52 silver badges73 bronze badges

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

2 Comments

mattlangtree Over a year ago

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.

João Nunes Over a year ago

Here is the updated link to donwload mysql Library: eval-art.com/2009/06/22/mysqlframework-for-iphone

Kenny Wyland · Accepted Answer · 2012-05-03 11:57:52Z

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 3, 2012 at 11:57

user577537

answered Feb 1, 2011 at 2:42

Kenny Wyland

22k26 gold badges130 silver badges250 bronze badges

1 Comment

walkingbrad Over a year ago

Technically Core Data is not a relational database but rather an object graph manager (if you want to get technical).

Peter Mortensen · Accepted Answer · 2017-11-11 14:40:15Z

1

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

edited Nov 11, 2017 at 14:40

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered Sep 14, 2012 at 6:44

hernan saab

92 bronze badges

Comments

Peter Mortensen · Accepted Answer · 2017-11-11 14:40:44Z

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, 2017 at 14:40

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered Apr 14, 2011 at 15:44

Nektarios

10.4k10 gold badges66 silver badges93 bronze badges

Collectives™ on Stack Overflow

Connecting to a MySQL database using Xcode and Objective-C

4 Answers 4

2 Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related