it is posible ?
No.
@hectots is, in practice, correct, though a deeper description would be to say that a mobile application will not be able to directly access any database hosted on a web server without an interface to provide security and meaning to the requests for data. This is typically a web service (like a web page for machines) which lets you make requests from within your code to the database, without compromising security.
Coronium is very promising in this regard. No more PHP code needed to run your SQL Select or SQL Updates etc. No more receiving & processing JSON. Hang in there just a little longer and you might have your wish. I am utterly impressed so far.
No.
@hectots is, in practice, correct, though a deeper description would be to say that a mobile application will not be able to directly access any database hosted on a web server without an interface to provide security and meaning to the requests for data. This is typically a web service (like a web page for machines) which lets you make requests from within your code to the database, without compromising security.
Coronium is very promising in this regard. No more PHP code needed to run your SQL Select or SQL Updates etc. No more receiving & processing JSON. Hang in there just a little longer and you might have your wish. I am utterly impressed so far.
what a useful answer, very explicit
Well the technical answer is “Yes you can”, but the practical answer is “No”. Let me explain.
You could expose your MySQL’s database TCP/IP port for public access. Then you would have to use the Lua socket library and write socket level code to open the TCP/IP port and basically build a MySQL client. You will spend months on this and in the end leave your database open for attacks.
So for all practical purposes, you will need middle-ware between your app and your server that takes specific command and passes them as SQL queries to your database. It’s simply from a security perspective irresponsible to allow a remote device to execute SQL against your database. You can write your middle-ware can be written in any script language, like Ruby, Perl, Python, Node.JS, .NET, etc. The most common way is to have your webserver execute these scripts as responses to HTTP web queries. The script executes and pulls key-value pairs from the GET or POST data and the script scrubs the data and them forms an SQL query in your control to the database. When the database returns the data to the script, you put it in a table, JSON encode it and write it out.
The most common way to do this is with PHP.
From Corona SDK you will use the network.request() API. When it completes, a function of your writing will trigger with the JSON data passed to it. You then run json.decode() in Corona to turn it into a Lua table.
Rob
@icqaza I apologize for my unhelpful answer. Thankfully, other members of the community (including Corona Staff members) gave a more useful explanation.
what a useful answer, very explicit
Well the technical answer is “Yes you can”, but the practical answer is “No”. Let me explain.
You could expose your MySQL’s database TCP/IP port for public access. Then you would have to use the Lua socket library and write socket level code to open the TCP/IP port and basically build a MySQL client. You will spend months on this and in the end leave your database open for attacks.
So for all practical purposes, you will need middle-ware between your app and your server that takes specific command and passes them as SQL queries to your database. It’s simply from a security perspective irresponsible to allow a remote device to execute SQL against your database. You can write your middle-ware can be written in any script language, like Ruby, Perl, Python, Node.JS, .NET, etc. The most common way is to have your webserver execute these scripts as responses to HTTP web queries. The script executes and pulls key-value pairs from the GET or POST data and the script scrubs the data and them forms an SQL query in your control to the database. When the database returns the data to the script, you put it in a table, JSON encode it and write it out.
The most common way to do this is with PHP.
From Corona SDK you will use the network.request() API. When it completes, a function of your writing will trigger with the JSON data passed to it. You then run json.decode() in Corona to turn it into a Lua table.
Rob
@icqaza I apologize for my unhelpful answer. Thankfully, other members of the community (including Corona Staff members) gave a more useful explanation.