Firemonkey Mobile Application and remote MySQL

Question

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)?

Answer 1

You can take a look at Devart DAC

Answer 2

I'm using DBExpress since XE2, it works good, but i think now FireDAC is much bettter

Answer 3

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.