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.
Author by
Vladimir Arevshatyan
Updated on June 28, 2022Comments
-
Vladimir Arevshatyan almost 2 years
- 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?
- 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?