Can Corona access a remote database so you have an app where people can get records from a database or add records to a database. How easy can or cant Corona do this because this ?
I havent found a tutorial on this. [import]uid: 138547 topic_id: 29352 reply_id: 329352[/import]
Yes, you can access an external database by using something like PHP and mysql, you call a PHP script on your website which fetches the data. [import]uid: 8697 topic_id: 29352 reply_id: 117954[/import]
Hi,
Corona can definitely do this, and as Cublah mentioned the “proper” way would be to throw together a simple web application to manage the communication between your app and the DB. So your app would make web requests to your web app, and it would make calls to the DB.
What kind of data/records do you need to manage? What kind of App are you building?
Ali [import]uid: 10499 topic_id: 29352 reply_id: 117976[/import]
See: http://omnigeek.robmiracle.com/2012/04/15/using-corona-sdk-with-rest-api-services/
[import]uid: 19626 topic_id: 29352 reply_id: 118019[/import]
I guess what IU am trying to get at is Corona good for the job. YOu would get that argue you shouldnt
use Corona to access a remote DB and instead use Androidm SDK as it is more suitable.
I just want to access simple DB to read/insert and update data like logging calls , an IT tech goes to his job off site, the details are kisted in this DB and he adds to the call when finished. There are many IT techs. [import]uid: 138547 topic_id: 29352 reply_id: 118097[/import]
Based on that, why don’t you store your information either in an SQLite data base on the device or a text file containing a JSON structure (basically a text copy of) a Lua table. And give a sync/upload button at the end that would then connect to a remote server and transfer the data.
But I’m going to bring up one REALLY important point, that I think we’ve all stated without stating it.
No IT manager in their right mind is going to give open access to their database server from an outside client. That is an incredibly large security hole. “Lets prod port 3306 and see if MySQL responds? Lookie, it does.”. The average 14 year old has your entire database in just a few minutes.
The only sane way to do this is have some web based service using something like PHP as the intermediary between your app and the database. You’re PHP (or .net or asp or whatever) script talks to your database behind the firewall and you only have the web port (80 or 443 for https) open to connections. You manage what data gets passed in and your PHP scripts can scrub the data from the client before it ever gets close to the database.
[import]uid: 19626 topic_id: 29352 reply_id: 118102[/import]