iOS Remote Database Access

[DSchwartz88]

Hi All,

I'm writing an iPhone app that requires a ton of information and thus I need to store it in a database on remote server. At the moment it is in a MySQL db but can be porter to anything else. Even 1000's of XML files. My question is as of now I don't know how to access a MySQL db from the iPhone nor do I know how to grab XML files to populate UITableView's. If anyone can help it would be much appreciated.

Thanks,
Daniel

 

[GNUMatrix]

I have the same question, but more generic.... How does one go about connecting an iPhone App to an ODBC-style database? Lots of interest in mysql of course, but my personal db of choice happens to be DB2.

I've read lots about the embedded SQL stuff, but that doesn't really apply, so does anyone have a demo app or something to demonstrate this kind of thing? I see some apps showing up now (like the Oracle Business Indicators and whatever it was for connecting to Dynamics) so its obviously quite possible.

 

[cleverapps]

You could use http://code.google.com/p/entropydb/ which has replication support.

 

[syner]

cleverapps - thanks for posting the link. something to look at down the road but as of now it is GPL so no one actually trying to make an app for the app store can use (non commercial license only). also, it's only been tested on a simulator. doesn't always translate right on a real iphone. not ready for prime time yet.

 

[cleverapps]

cleverapps - thanks for posting the link. something to look at down the road but as of now it is GPL so no one actually trying to make an app for the app store can use (non commercial license only). also, it's only been tested on a simulator. doesn't always translate right on a real iphone. not ready for prime time yet.

Hi, it has been testen on the iPhone (device) but the pre-built static library is available only for the Simulator. The code works on both.
As for the license, I think a viable solution would be a dual license.