Can Android connect directly to MySQL without PHP?

17,594

Solution 1

It is strongly recommended that you don't do this.

See this post: Direct insert data in mysql data in android

... and this post: Why should a developer use web services instead of direct connections to a db?

Edit: The comment from @halfer is very informative, so quoting it here:

In practice, you will always need more security controls than MySQL will give you - hence the need for a server-side layer. If it gets slow then you can optimise your queries or upgrade your hardware (but don't optimise unless you need to).

Solution 2

1. Yes, it is possible. I use Delphi XE5 FMX and MyDAC from DEVART.

Share:
17,594
Vladimir Arevshatyan
Author by

Vladimir Arevshatyan

Updated on June 28, 2022

Comments

  • Vladimir Arevshatyan
    Vladimir Arevshatyan almost 2 years
    1. I want to connect to MySQL remote database from android but I don't want to send request to php, I want a straight connection to MySQL without making request to php, so in my opinion it will be more fast and I will get everything i need from mysql remote db table, but as far as I google only tutorials on how to connect through request to php. Is it even possible to do what I want?
    2. If the first one isn't possible, could Android have local database SQLite in which straight away in android code I can wire queries to that db, but is it possible to write queries inside android code to remote mysql database?