iOS Connect to external MySQL database...

[Aquis]

Hey! Does anyone have any ideas on how to connect to an external MySQL database? I've thought of MySQL-Cocoa, but I gather frameworks aren't allowed. The C API of MySQL I've thought of as well which seems a little more probable...but I'm not sure of the best way of using it (or even if I could use it) with an iPhone. Anyone got any ideas?

Thanks!

 

[santelia]

Suggest to convert in SQLite. Quite same functionality, good speed, some limits (such as max 1MB data per row). Of course not a client-server classic architecture... Try it. Some converters, importers and other nice managing tools available on the net, few of them free, some others at a very affordable cost ($20 or somewhere around).

In iPhone SDK, you have to use libsqlite3.0.dylib framework.
You can find it under /Developer/Platforms/iPhoneOS.platform/Developer/SDKs/iPhoneOS2.0.sdk/usr/lib/

 

[Aquis]

I'm afraid it really has to be MySQL - I'm tied with several hosts which uses nothing else and don't have enough access to install a new db server. It's pretty annoying, but I'm afraid I really do need MySQL access.

Thanks anyway!

 

[jeremy.king]

Add a web service layer and talk to that from your phone.

 

[Aquis]

I was thinking about that too...and whilst this might work, I'm still after the direct MySQL connection if at all possible. I'm not after alternatives - if it is at all possible to have direct connections, that is best.