Connect to external MySQL database...

Discussion in 'iOS Programming' started by Aquis, Aug 18, 2008.

  1. Aquis macrumors member

    Joined:
    Aug 7, 2007
    Location:
    Staffordshire, UK
    #1
    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!
     
  2. santelia macrumors newbie

    Joined:
    Aug 17, 2008
    #2
    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/
     
  3. Aquis thread starter macrumors member

    Joined:
    Aug 7, 2007
    Location:
    Staffordshire, UK
    #3
    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!
     
  4. jeremy.king macrumors 603

    jeremy.king

    Joined:
    Jul 23, 2002
    Location:
    Fuquay Varina, NC
    #4
    Add a web service layer and talk to that from your phone.
     
  5. Aquis thread starter macrumors member

    Joined:
    Aug 7, 2007
    Location:
    Staffordshire, UK
    #5
    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.
     

Share This Page