remote database. what do you use?

Solar2D Network
#1

Hi all.

I’m starting a project that will need a remote database. I search the forums and almost all answers i got was a php code in server side to get data from the remote database. Or using clouds like Parse.com.

my question here is more a query.

I want to know, if possible, who had same need that i’ve now, how they resolved their problems.

did you go for the php solution? why? where can i find the best tutorial to go for this solution?

i found this 2 links that show me how to:

http://forums.coronalabs.com/topic/28868-how-to-insert-datas-on-a-remote-database/

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

this links are enought for me to get the job done?(securite is importante)

if you have gone to cloud services? who did you chose? why?

I’m looking at Coronium, i saw lot’s of good feedbacks from forum members using this kinda service.

This is the way to go if i need a remote database?

My App needs login/password (if not register an accound can be created in the app). register users can upload data and images to database. normal users can access the data inserted from the registered users. in resume is a backoffice and a frontoffice in 1 app.

hope i didnt made to many questions on 1 post :slight_smile:

thanks for all, Joao Peixoto.

#2

Some quick answers:

  • PHP & MySQL… easiest to knock something together without a high learning curve. Lots of free tools for tracking and debugging too.

  • MAMP Pro on MacBook Pro to develop, $14.95/month Hostgator hosting package for “production”.

  • If this app takes off (>5k users is the trigger point for me), I’ll look at AWS.

  • most of the up/down interaction is HTTP POST and JSON. Make sure you have SSL on your host for production.

#3

Thank you very much for your fast reply.

I will look into that solution. if anyone else others solutions please share them here :slight_smile:

#4

My App needs login/password (if not register an accound can be created in the app). register users can upload data and images to database. normal users can access the data inserted from the registered users. in resume is a backoffice and a frontoffice in 1 app.

While the PHP/MySQL route may be pretty easy, if you want to allow uploads of data (files? documents? images?), what you’re describing sounds like it, if it does take off, you could be hosting 100’s of GB of data pretty quickly.  Why not let someone else deal with that.

You might want to look at more of the cloud services, many of which have free offerings (though do pay attention to the limits for the free service offerings, and the price bumps for the next level of service which can be steep).  If all you really need is a place to upload data, maybe even look at the Box, Dropbox, etc.  (obviously not a full database, but have search/query capabilities if all you need is retrieval).

E.g. Apigee, Kinvey, Cloudant, Built.io, Appcelerator

#5

Take a look at http://coronium.io/

 

Totally free and amazing! 

#6

I already looked at coronium, like i mention in my first post. the problem i enconter with that solution is that i need to use coronium with DigitalOcean or Amazon EC2, none are cheap.

the app is ment to a huge audience, i’m afraid the prices go up pretty quick.

i already tested parse.com, and it was easy to implement a login/password system. but i need lots of data/images do be uploaded every day. i’m afraid of the jump from 0 to 100$ or more will be needed and thats a huge bill for me right now.

“Apigee, Kinvey, Cloudant, Built.io, Appcelerator” are easy to integrate with corona?

thanks for all replies,

Joao

#7

You can do the financial analysis. With Parse and other commercial services you are paying per API call. With Coronium you have to pay a flat fee for the server / droplet. You can start with the $5 a month mini server droplet and goto $10, $20 a month etc as your user base grow and your server utilization peeks. IMHO, the Coronium option is always going to be way more economical than anything else out there. 

#8

I’m reading some tutorials right now to learn how to use Coronium Cloud. If anyone have other solutions, please share them. more options, better decisions can be made.

Thank all for help.

#9

If you want to give Coronium a test run, you can use it on Amazon for 12 months free.  Cost-wise Coronium is going to be cheaper over time, like kerem mentioned.  No quotas, no subscription fees.

Best of luck.

#10

Some quick answers:

  • PHP & MySQL… easiest to knock something together without a high learning curve. Lots of free tools for tracking and debugging too.

  • MAMP Pro on MacBook Pro to develop, $14.95/month Hostgator hosting package for “production”.

  • If this app takes off (>5k users is the trigger point for me), I’ll look at AWS.

  • most of the up/down interaction is HTTP POST and JSON. Make sure you have SSL on your host for production.

#11

Thank you very much for your fast reply.

I will look into that solution. if anyone else others solutions please share them here :slight_smile:

#12

My App needs login/password (if not register an accound can be created in the app). register users can upload data and images to database. normal users can access the data inserted from the registered users. in resume is a backoffice and a frontoffice in 1 app.

While the PHP/MySQL route may be pretty easy, if you want to allow uploads of data (files? documents? images?), what you’re describing sounds like it, if it does take off, you could be hosting 100’s of GB of data pretty quickly.  Why not let someone else deal with that.

You might want to look at more of the cloud services, many of which have free offerings (though do pay attention to the limits for the free service offerings, and the price bumps for the next level of service which can be steep).  If all you really need is a place to upload data, maybe even look at the Box, Dropbox, etc.  (obviously not a full database, but have search/query capabilities if all you need is retrieval).

E.g. Apigee, Kinvey, Cloudant, Built.io, Appcelerator

#13

Take a look at http://coronium.io/

 

Totally free and amazing! 

#14

I already looked at coronium, like i mention in my first post. the problem i enconter with that solution is that i need to use coronium with DigitalOcean or Amazon EC2, none are cheap.

the app is ment to a huge audience, i’m afraid the prices go up pretty quick.

i already tested parse.com, and it was easy to implement a login/password system. but i need lots of data/images do be uploaded every day. i’m afraid of the jump from 0 to 100$ or more will be needed and thats a huge bill for me right now.

“Apigee, Kinvey, Cloudant, Built.io, Appcelerator” are easy to integrate with corona?

thanks for all replies,

Joao

#15

You can do the financial analysis. With Parse and other commercial services you are paying per API call. With Coronium you have to pay a flat fee for the server / droplet. You can start with the $5 a month mini server droplet and goto $10, $20 a month etc as your user base grow and your server utilization peeks. IMHO, the Coronium option is always going to be way more economical than anything else out there. 

#16

I’m reading some tutorials right now to learn how to use Coronium Cloud. If anyone have other solutions, please share them. more options, better decisions can be made.

Thank all for help.

#17

If you want to give Coronium a test run, you can use it on Amazon for 12 months free.  Cost-wise Coronium is going to be cheaper over time, like kerem mentioned.  No quotas, no subscription fees.

Best of luck.