Help with mySQL on iOS

I’ve been trying to do what research I can on my own but I’m afraid it’s still just a little bit over my head still at the moment. I’m currently developing an application for iOS and I need it to be able to connect to mySQL for both sign on credentials to get started and retrieving user information and adding information to a mySQL server chart.

Does anyone have any suggestions as for where to start with learning how to do this or any tips and thoughts on coding to get me started? Will I need to do any socket programming in order to make this work?

  1. dont try & connect directly to the mySQL server
  2. see #1

I’d use a service (maybe http based) on a host that connects to the mysql server there

There is no direct connection database servers available in iOS. You’ll have to use sockets to communicate with some service that’s doing the actual communications with the database.

[quote=229684:@Norman Palardy]1) dont try & connect directly to the mySQL server
2) see #1

I’d use a service (maybe http based) on a host that connects to the mysql server there[/quote]

Would you both recommend perhaps working on an HTTPSecureSocket to setup communication with the iOS application to a web host that then connects and communicates with the mySQL server?

That would be preferable since you the n control the protocol used back and forth between the iOS client & whatever back end server
HTTPS is just a good idea in any event

Do you know where I might be able to find an example of how to go about this or the procedure generally used for the coding for either the creation of the socket or integrating it with the application?

Also, I do apologize if the questions are a little stupid. I’m very new to programming and my standard approach to learning isn’t effective with how diverse this is. I really appreciate all the help and tips!

Try looking in the examples > ios > networking

Watch the webinars on exactly this topic:

REST Web Services