objective-c with remote MySQL server

[peeInMyPantz]

Hi,
anyone has any idea how i can use objective-c to connect to a remote mysql server?
it can be either direct or indirect through a script...
i want to make an app that sync with a remote mysql database... but i dunno where to start looking

[JLA]

Originally Posted by peeInMyPantz

Hi,
anyone has any idea how i can use objective-c to connect to a remote mysql server?
it can be either direct or indirect through a script...
i want to make an app that sync with a remote mysql database... but i dunno where to start looking

Do the libraries that allow Notes to save to local SQL not allow remote? Not sure what they are, but you could probably browse framework headers on Erica Sadun's site and track it down.
If not, surely there is some sort of SQL stuff available in C/C++/ObjC.

If not, you might want to look into Java via JamVM, on Jay Freeman's repository. I believe it has an SQL library available for it.

[NetMage]

The iPhone's built-in SQL is sqlite, not MySQL.

Sqlite is a local embedded SQL that doesn't use a separate engine process.

You will need a MySQL client library conpiled for the iPhone to link against.

[gregcaulder]

Originally Posted by NetMage

The iPhone's built-in SQL is sqlite, not MySQL.

Sqlite is a local embedded SQL that doesn't use a separate engine process.

You will need a MySQL client library conpiled for the iPhone to link against.

Instead of it being a library wouldent it be called a framework?
Because I have found a cocoa mysql framework but right now I can't get it to work when compiling to an iPhone app.
Or am I completley mistaken?

G

[NetMage]

The fourth time I have tried to post this *sigh* isn't the Internet wonderful...

Binary (even universal binaries) for OS X are not compatible with the iPhone. You will need to get the source for the MySQL client library and compile it yourself.

Unfortunately, MySQL doesn't appear to support a Cygwin port so that may make compiling with the toolchain difficult. Even more unfortunately, the source for the client is not cleanly separated from the server, but if you are using the SDK, compiling for OS X would probably give you a good starting point.

Here is an article that may help:
MySQL on Mac OS X

[JedixJarf]

Can you just make a remote sqllite database to query?

[gregcaulder]

Originally Posted by NetMage

The fourth time I have tried to post this *sigh* isn't the Internet wonderful...

Binary (even universal binaries) for OS X are not compatible with the iPhone. You will need to get the source for the MySQL client library and compile it yourself.

Unfortunately, MySQL doesn't appear to support a Cygwin port so that may make compiling with the toolchain difficult. Even more unfortunately, the source for the client is not cleanly separated from the server, but if you are using the SDK, compiling for OS X would probably give you a good starting point.

Here is an article that may help:
MySQL on Mac OS X

I have found source for a Cocoa MySQL framework/library. It compiles correctly, but when the iPhone simulator tries to run it, it completely crashes and needs to send a report. I have already sent an email to support, but they don't exists.

So what about this as a starting point, if you download it look for a framework called MCPKit_bundled.framework. That is the one you need.

SourceForge.net: Downloading ...