mysqldelphidelphi-xe5dbexpressfiredac

Firemonkey Mobile Application and remote MySQL

I am using Delphi XE5 and I have created basic Firemonkey Mobile Application - Delphi

I would like to connect to a remote MySQL database. Which if any database conduit do I use? (FireDAC, DBExpress, etc)?

Solution

  • You can use standard TSQLQueries, but as your mobile app needs to connect to a remote database, you will need to go via a DataSnap service (most probably hosted on an IIS server). The mobile device then connects to the DataSnap server which then connects to the database.

    The DataSnap functions can return TDataSets which your app can then use.