Tutorial to Connect iPhone app with MySQL database? (Interface Objective-C with mysql)

Question

I am looking for a tutorial on how to make an iPhone app that fetches data from and writes data to a MySQL database. I've seen some other threads saying that I should make an abstraction layer so as not to connect directly to the database from my app, but I'm not sure of how to actually go about doing this. Does anyone know of any tutorials that involve creating an abstraction layer for a MySQL database or connecting a MySQL database to an iPhone app?

To clarify, I am looking for a secure method that wouldn't allow people to sniff out my MySQL host, username and password. It seems like the libraries that connect directly to MySQL from the iPhone all have this problem, but please correct me if I'm wrong.

Snowman · Accepted Answer · 2012-03-10 17:06:21Z

2

This is a really good tutorial that covers how to communicate with MySQL from an iPhone app using PHP:

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

answered Mar 10, 2012 at 17:06

Snowman

32.2k48 gold badges192 silver badges312 bronze badges

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

Comments

Dimitris Bouzikas · Accepted Answer · 2014-12-05 23:40:10Z

2

I know only one library, which makes possible connection from iPhone to MySQL. This is port of official MySQL C libraries created by Karl Kraft.
Author published also small portion of samples, which describes how to use this library.

UPDATE (Karl Kraft's broken link)

Instead of link above, I used an archived copy.

edited Dec 5, 2014 at 23:40

Dimitris Bouzikas

4,5503 gold badges27 silver badges35 bronze badges

answered Mar 10, 2012 at 10:50

Tomasz Wojtkowiak

4,9201 gold badge31 silver badges35 bronze badges

2 Comments

Dylan Over a year ago

Thanks, but I read on the sample page that connecting to MySQL directly from the iPhone would allow someone to sniff out your database admin information, which doesn't seem very secure. Do you know any way of actually making this method secure?

João Nunes Over a year ago

do you have a copy? the link is down

Tristan G · Accepted Answer · 2015-02-03 07:38:38Z

2

not up to date, but this tutorial helped me a lot: http://codewithchris.com/iphone-app-connect-to-mysql-database/#connectiphonetomysql

answered Feb 3, 2015 at 7:38

Tristan G

1,8402 gold badges14 silver badges22 bronze badges

Comments

pät · Accepted Answer · 2012-03-10 10:53:54Z

0

Here http://blog.iosplace.com/?p=30 is a snippet that uses the original mysql client lib, and here http://www.karlkraft.com/index.php/2012/01/ is a link to a 3rd-party connector.

answered Mar 10, 2012 at 10:53

pät

5433 silver badges9 bronze badges

Comments

David Agustin Almanza Gaitan · Accepted Answer · 2014-04-09 15:25:13Z

Here is a nice tutorial on how to connect to a database using web service layer. From a practical perspective you could connect directly to a database from an iphone because that is a client server transaction. The problem is that you would need to expose your database server an issue that many would find very disturbing, because you would expose your server which hold your most valuable resource "your data". Of course you can implement and could be a good solution for rather small projects. But you would need to implement the layer which it would be used to connect on the iOS app, adding more complex to the matter.

Using a web service is more reliable even from the iOS developer, because there is a very extensive api for using web service, which offer great functionality (asynchronous transactions, threads management,JSON Mapping, XML Mapping) to name a few.

Oleg · Accepted Answer · 2018-03-21 15:15:17Z

0

Use the library OHMySQL. It copes with MySQL through MySQL C API.

answered Mar 21, 2018 at 15:15

Oleg

5184 silver badges14 bronze badges

Collectives™ on Stack Overflow

Tutorial to Connect iPhone app with MySQL database? (Interface Objective-C with mysql)

6 Answers 6

Comments

2 Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

2 Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related