Interface to an internet based database ?

Getting Started Newbie Questions
#1

Hi All

I have an upcoming project when I need to read from a MySQL database on the internet, to a mobile device. I was wondering if Corona would be useful for such a task?

Normally, I’d write the server-side scripts and just access the data with a browser, but I’d like to do it from an App. Possibly adding the ability to import data?

Are there any tutorials on interfacing with another database?

So far I can only find Jonathan Beebe’s Database Access tutorial, which deal with creating and updating a local database on the device.
[import]uid: 97524 topic_id: 36152 reply_id: 336152[/import]

#2

I would recommend setting up a REST-ful server side API for the app to communicate with the database. There are tons of How-Tos on the internet for doing this with various programming languages. Depending on the security of the data, you will probably need to set up SSL and use various other encryption techniques as well. I would NOT recommend trying to access your MySQL database directly from the app. [import]uid: 92150 topic_id: 36152 reply_id: 143595[/import]

#3

Thanks

I’ll look into REST.

Never heard of it before, but a quick read reveals it’s been adopted by Google and Facebook.

[import]uid: 97524 topic_id: 36152 reply_id: 143597[/import]

#4

Check out this blog post:

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

It should get you started. Yes, Corona does a great job with these types of apps. [import]uid: 199310 topic_id: 36152 reply_id: 143661[/import]

#5

depending upon the complexity of the data you’re accessing, you could also just write a php script that outputs results from the db as JSON. Corona handles that nicely as well. [import]uid: 32462 topic_id: 36152 reply_id: 143668[/import]

#6

…and now that I’ve actually looked at rob’s link I can see that’s exactly what he’s doing. [import]uid: 32462 topic_id: 36152 reply_id: 143669[/import]

#7

I would recommend setting up a REST-ful server side API for the app to communicate with the database. There are tons of How-Tos on the internet for doing this with various programming languages. Depending on the security of the data, you will probably need to set up SSL and use various other encryption techniques as well. I would NOT recommend trying to access your MySQL database directly from the app. [import]uid: 92150 topic_id: 36152 reply_id: 143595[/import]

#8

Thanks

I’ll look into REST.

Never heard of it before, but a quick read reveals it’s been adopted by Google and Facebook.

[import]uid: 97524 topic_id: 36152 reply_id: 143597[/import]

#9

Check out this blog post:

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

It should get you started. Yes, Corona does a great job with these types of apps. [import]uid: 199310 topic_id: 36152 reply_id: 143661[/import]

#10

depending upon the complexity of the data you’re accessing, you could also just write a php script that outputs results from the db as JSON. Corona handles that nicely as well. [import]uid: 32462 topic_id: 36152 reply_id: 143668[/import]

#11

…and now that I’ve actually looked at rob’s link I can see that’s exactly what he’s doing. [import]uid: 32462 topic_id: 36152 reply_id: 143669[/import]

#12

I would recommend setting up a REST-ful server side API for the app to communicate with the database. There are tons of How-Tos on the internet for doing this with various programming languages. Depending on the security of the data, you will probably need to set up SSL and use various other encryption techniques as well. I would NOT recommend trying to access your MySQL database directly from the app. [import]uid: 92150 topic_id: 36152 reply_id: 143595[/import]

#13

Thanks

I’ll look into REST.

Never heard of it before, but a quick read reveals it’s been adopted by Google and Facebook.

[import]uid: 97524 topic_id: 36152 reply_id: 143597[/import]

#14

Check out this blog post:

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

It should get you started. Yes, Corona does a great job with these types of apps. [import]uid: 199310 topic_id: 36152 reply_id: 143661[/import]

#15

depending upon the complexity of the data you’re accessing, you could also just write a php script that outputs results from the db as JSON. Corona handles that nicely as well. [import]uid: 32462 topic_id: 36152 reply_id: 143668[/import]

#16

…and now that I’ve actually looked at rob’s link I can see that’s exactly what he’s doing. [import]uid: 32462 topic_id: 36152 reply_id: 143669[/import]

#17

I would recommend setting up a REST-ful server side API for the app to communicate with the database. There are tons of How-Tos on the internet for doing this with various programming languages. Depending on the security of the data, you will probably need to set up SSL and use various other encryption techniques as well. I would NOT recommend trying to access your MySQL database directly from the app. [import]uid: 92150 topic_id: 36152 reply_id: 143595[/import]

#18

Thanks

I’ll look into REST.

Never heard of it before, but a quick read reveals it’s been adopted by Google and Facebook.

[import]uid: 97524 topic_id: 36152 reply_id: 143597[/import]

#19

Check out this blog post:

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

It should get you started. Yes, Corona does a great job with these types of apps. [import]uid: 199310 topic_id: 36152 reply_id: 143661[/import]

#20

depending upon the complexity of the data you’re accessing, you could also just write a php script that outputs results from the db as JSON. Corona handles that nicely as well. [import]uid: 32462 topic_id: 36152 reply_id: 143668[/import]