mysql database

Other
#1

Hi, 

I have two questions regarding mysql database. 

  1. If I have a mysql database file generated from a third party tool, can I include that in my app and access it? Any helpful link will be great.

  2. I want to generate some mysql tables and include them in the app. Is there some tool out there that I can use to populate the tables? Like excel that can be used for populating the tables and then the file is included in the corona app and accessed from within in.

thanks for your help,

#2

If you’re using Corona SDK (not Enterprise), then we include SQLite 3 as the database for internal app use.  You also can use network.request() to make server based PHP calls (or other scripting language) using a REST like HTTP requests and have those scripts interface with your hosted MySQL database.

If you’re using Corona Enterprise then it’s possible that Apple and/or Google provide an SDK/Framework/Library that can be used to include an embedded MySQL database.  Since apps only have access to their sandbox you really can’t run a MySQL server on a mobile device.

Rob

#3

Thanks Rob. I am new to Corona and Lua for that matter. I was wondering if MySQL can be used on the remote device.

#4

Maybe this tutorial will help you:
 

http://omnigeek.robmiracle.com/2012/04/15/using-corona-sdk-with-rest-api-services/

Rob

#5

If you’re using Corona SDK (not Enterprise), then we include SQLite 3 as the database for internal app use.  You also can use network.request() to make server based PHP calls (or other scripting language) using a REST like HTTP requests and have those scripts interface with your hosted MySQL database.

If you’re using Corona Enterprise then it’s possible that Apple and/or Google provide an SDK/Framework/Library that can be used to include an embedded MySQL database.  Since apps only have access to their sandbox you really can’t run a MySQL server on a mobile device.

Rob

#6

Thanks Rob. I am new to Corona and Lua for that matter. I was wondering if MySQL can be used on the remote device.

#7

Maybe this tutorial will help you:
 

http://omnigeek.robmiracle.com/2012/04/15/using-corona-sdk-with-rest-api-services/

Rob