Sorry for reposting, just realized this place might be more appropriate for this topic:
Hi,
I'm an electronic engineer and basically have no experience in programming PC or mobile apps, but now I have to do an Android app that needs to access a remote MySQL database.
I'm confused about how can I access the MySQL database from a mobile phone. At first I thought the FireDAC will give me this ability if I purchase the enterprise edition, but in an tutorial on the Embarcadero web site "Mobile Tutorial: Using InterBase ToGo with FireDAC (iOS and Android)" ( http://docwiki.embarcadero.com/RADStudio/Rio/en/Mobile_Tutorial:_Using_InterBase_ToGo_with_FireDAC_(iOS_and_Android) ) , it says:
FireDAC is a unique set of Universal Data Access Components for developing cross-platform database applications for Delphi and C++Builder. With its powerful common architecture, FireDAC enables native high-speed direct access from Delphi to InterBase, SQLite, MySQL, SQL Server, Oracle, PostgreSQL, IBM DB2, SQL Anywhere, Access, Firebird, Informix, and more.
I've purchased C++ Builder Rio 10.3.2 professional, should I upgrade it to enterprise edition ? What is the best way to create Android MySQL database apps?
Any reply or suggestion is much appreciated.
Jian Jiao
I followed an api-approach, using a php crud api frontend (https://github.com/mevdschee/php-crud-api) in the server side and a rest client in delphi or C++ (android and win32).
You must have php installed in your server and all crud operations are available to your rest client (some restrictions apply, see mevdschee document)
Thank you for the help. As I'm not a real programmer, I know nothing about REST and php, so this approach might be a hard way for me, but thanks anyway.