1. Due to the recent site upgrade, the iPadForums (iPF) App will no longer work. The new iPadForums.net website has been designed from the ground up to work perfectly from any mobile, tablet, or desktop computer using the built in internet browser. Create a shortcut to iPadForums.net on your home screen by following these steps: Create an icon for iPadForums.net

Can I develop an iPad app that connects to a remote mysql database?

Discussion in 'iPad Help' started by Godzuki, Mar 2, 2012.

  1. Godzuki
    Offline

    Godzuki iPF Novice

    Joined:
    Mar 2, 2012
    Messages:
    14
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Mexico
    Ratings:
    +0 / 0
    I'm a windows application developer, I'm recently learning how to develop for iPad and iPod touch/iphone. I've done lots of programs that can read and write data into tables of a MySQL database. However I don't know if that is possible on the iPad. I have seen some mysql clients, so I guess that is actually possible to develop an app that allows me to access data on a mysql database and insert/update/delete records from it, using a personalized front end. I'm making a program to take attendance and homework's from students in a local high school. I'm already finishing development for windows 32 bit and I would like to make an iPad version of it. Is this possible? Can I create forms on iPad and access a remote database (MySQL) and use the stored data there?

    Thanks for the help.
  2. MikesTooLz
    Offline

    MikesTooLz Super Moderator Staff Member

    Joined:
    May 7, 2010
    Messages:
    2,364
    Thanks Received:
    19
    Trophy Points:
    0
    Location:
    Miami, FL
    Ratings:
    +20 / 0
    Yes you can.

    If this needs to be a secure connection then it will be much more difficult. If its not needed to be secure, you could simply create a PHP script on your web server that accepts variables to be passed to it. Then all you would have to do is grab the webpage for your url with the custom variables to be passed along. Results could be passed back if needed.


    Securely connecting to the database would require you to make the app actually make its own connection to the database and would be 10 times more involved.
  3. joeyteel
    Offline

    joeyteel iPad Fan

    Joined:
    Jan 31, 2012
    Messages:
    194
    Thanks Received:
    16
    Trophy Points:
    0
    Ratings:
    +16 / 0
    You can make a secure connection through a script just fine, in fact it's easier that way as long as you know what you're doing and secure the server and the connection properly.

    Based on what the OP said about a win32 client though I'm guessing that using a MySQL client library wouldn't be an issue :)
  4. Godzuki
    Offline

    Godzuki iPF Novice

    Joined:
    Mar 2, 2012
    Messages:
    14
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Mexico
    Ratings:
    +0 / 0
    I'm afraid that I didn't explain the question properly.

    I created a program that runs on windows 7 32 bits using Delphi 2010 and Devart MyDAC components. MyDAC allows my program to connect and query the database without the need to install a mysql client on the client pc. For the end user is transparent. Can I create an iPad app that may connect to the same database on mysql?, not a php page, not a web service, just an app that is able to connect to a database on a remote server (I'm using ubuntu server 11.04)

    I want to program an simple app that may insert/update/delete records from a database. If the iPad cannot do this task, I may question: may the iPad handle databases at all? and if that so, how does it do it?
  5. joeyteel
    Offline

    joeyteel iPad Fan

    Joined:
    Jan 31, 2012
    Messages:
    194
    Thanks Received:
    16
    Trophy Points:
    0
    Ratings:
    +16 / 0
    Actually, if I remember correctly, MyDAC links a static MySQL library into the EXE, which you would have to do that or use an existing MySQL framework, as I assume you don't want to write a MySQL protocol library from scratch.
  6. Godzuki
    Offline

    Godzuki iPF Novice

    Joined:
    Mar 2, 2012
    Messages:
    14
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Mexico
    Ratings:
    +0 / 0
    Yeah, I don't want to write a framework to work with MySQL, yet I assume that there are some free/commercial ones out there.
    I'm still learning php, and seems like a viable option instead of starting to write code on a device that has it's limitations regarding MySQL usage.

Share This Page

Search tags for this page
build an app for an ipad using mysql
,

connect a mobile app to a database

,
connect ipad app to remote database
,

connecting a mobile ios app to a database

,
connecting apps to a database
,
create ipad app mysql
,
creating database application for the ipad securely
,
free app to develop webforms for mysql database
,
how does an iphone application connect to a database
,
how to build an app from a database
,
how to connect to database via ipad
,

how to create a iphone app conected to sql database

,
how to updat eremote database in ios
,

ios app connect to mysql

,
ios app development remote database
,

ipad application remote database connectivity

,
ipad apps connect to database
,
ipad mysql script
,

make ipad app mysql

,
mysql apps for ipad