Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What's the easiest/cheapest way to create a cloud-based SQL database?

I have a website that I've built (hosted on Amazon S3) and it works great. The only problem is that all of the data is static. I'd like to create a SQL database in the cloud that would allow me to store basic text data from users after they submit forms. I'm still a novice web-developer but I've used sqlite3 for several of my Java desktop apps and I'd like to use that SQL knowledge to create this online database. I guess what i'm asking (in my ignorance) is: how can I create a sqlite-type database that is stored in the cloud and that I can query against using javascript?

Where do I get started? Is there a service like Amazon AWS or Azure or something where I can create this database and then use some sort of jQuery/Javascript API to query data from it? I don't need a ton of storage space and my queries would be very basic SQL type stuff.

Any help would be greatly appreciated. Thanks in advance.

like image 692
tennisgent Avatar asked May 02 '12 16:05

tennisgent


People also ask

Can I use Cloud SQL for free?

New customers also get $300 in free credits to spend on Cloud SQL to run, test, and deploy workloads. You won't be charged until you upgrade. Sign up to try Cloud SQL for free.

Is Google Cloud SQL free?

Google Cloud charges a per-hour rate for the software license of SQL Server, depending on the product edition you want to use. Storage and network costs are the same for all variations of Google Cloud SQL — SQL Server, MySQL, and PostgreSQL.


1 Answers

For more flexibility, less service lock-in, and cheaper scalability: I would suggest CouchDB (though you would likely still use a hosting service like Cloudant). CouchDB can host your website, and provides a HTTP API for storing data, to which your client-side JavaScript can make REST calls.

like image 78
Peter Tseng Avatar answered Oct 02 '22 08:10

Peter Tseng