iOS remote MySQL database, technology recommendation

manpreet Best Answer 2 years ago

There is web application, journalism related, that uses MySQL databases and presents a web based interface to users.

I want to build a iOS app that does a mobile interface as well. The UI is pretty easy and I have experience with that.

The problem is with the database, which I have no experience with. I will be learning about databases and probably take the Coursera course on it. I am not asking you to teach me that. I just wanna know which technologies I should invest my time in over the next couple months.

My understanding so far is that the app should not talk to the database directly, but rather there should be some one on the server talking to the database on behalf of the App.

This is the question and the part I want to understand clearly, so correct me if I am wrong.

I will have to write some sort of a unix program that runs on the server and talks to the db and then communicates back to app? how? using a web view? Using unix sockets to talk to the app? ssh? Which one is cool with Apple?

My preference for writing something like that on the server would be: python(have experience), java(have experience), and maybe ruby(no experience). I'd prefer to avoid scripting languages.

Are they ok? Which one is best suited? Also is this middle dude going to have to be on the same server that has the database or can be another machine on the internet(i'd prefer this, so i can put it on my own VPS and not have to screw up with the server machine)