Is it possible to access a external database server using Corona? And other questions.

Hello, people.

I am new with Corona, and quite newbie programming (Still second year on computer science).

Yesterday, my sister made a request for me: The hospital where she works needs a mobile system/app capable of accessing a already existing database and retrieve some useful information about patients, so they can speed up some boring or even hard work. I decided to use Corona because this application must be done for Android and iOS.
I must create tables for nurses, patients and history. Any knowledge aside from Corona and MySQL will be necessary for accessing, retrieving and storing data? 
So, is this possible?

First, I want to create a database on my computer and try to access using a Android/iPhone. But another question comes: How can I have the path for a non-local MySQL database? Is it possible to store data?

Well,

thank you, people.

Sorry for asking too many questions.

Hi @blessthismess,

Please view this tutorial and see if it may accomplish what you seek:

http://www.coronalabs.com/blog/2012/11/20/how-to-download-json-data-from-mysql-using-corona-sdk/

Best regards,

Brent Sorrentino

Hi @blessthismess,

Please view this tutorial and see if it may accomplish what you seek:

http://www.coronalabs.com/blog/2012/11/20/how-to-download-json-data-from-mysql-using-corona-sdk/

Best regards,

Brent Sorrentino