DEV Community

Picking a cloud database?

Alan Barr on July 28, 2018

What database do you choose? I'm looking for something like SQL but affordable. Do you run your own or use a managed service?

Collapse
 
mizhac profile image
Cristhian H.

Currently the majority of SQL services that we administer are in Aurora due to its multiple features:
Rapid implementation, easy documentation, fast migration, clean costs, and serverless aurora is amazing for our team.

Quote amazon:

"Amazon Aurora is designed to automatically detect database crashes and restart without the need for crash recovery or to rebuild the database cache. If the entire instance fails, Amazon Aurora will automatically fail over to one of up to 15 read replicas.": aws.amazon.com/rds/aurora/details/...

In our case, the cost represented by aurora is up to 30% less than what it cost us to handle instances in RDS directly with Postgres.

Collapse
 
backspaceage profile image
Backspace Age

aws.amazon.com/free/ <-- use RDS with either MySQL or PostGres

Don't run your own DB to start with - it's a lot of hassle to make sure it stays up and performant. Focus on your app, and leave the DB management to the experts.

All the best!

Collapse
 
acoh3n profile image
Arik

Personally, I'm in love with PostgreSQL and that would be my first choice 99% of the time.

It also has native support for JSON and other "NoSQL" features.

It has a fantastic team behind it and it's rock solid.

Collapse
 
rhymes profile image
rhymes

Can you elaborate a bit? What's your use case?

Collapse
 
alanmbarr profile image
Alan Barr

A service marketplace

Collapse
 
rhymes profile image
rhymes

Sorry, I meant what are your technical requirements.

In general I would say use a managed DB because you get security and upgrades for free but if you have experience in running one you can probably save some money installing it on a virtual machine and connecting your app to it.

Keep in mind that your time is money as well...

Thread Thread
 
alanmbarr profile image
Alan Barr

Good points right now I just want to verify there's a market for this idea so it's light on tech needs

Thread Thread
 
rhymes profile image
rhymes • Edited

An example about running PostgreSQL on Digital Ocean digitalocean.com/community/tutoria...

Collapse
 
aswathm78 profile image
Aswath KNM • Edited

It doesn't matter which database you choose, all managed or manual managed SQL DBMS costs more.

If you look for price affordable solutions, try DynamoDB from Amazon

Since you are trying out something new, why don't you try Heroku

Collapse
 
caubeen profile image
caubeen • Edited

Running Postgres in docker on a Digital Ocean droplet is the cheapest and easiest method I've used. I host all my test production environments on there, and multiple Postgres database.
For big production websites that are used by a lot of users and need to be robust, I'd probably end up hosting my entire app on AWS something or other.

Collapse
 
david_ojeda profile image
David Ojeda

If you only need to validate an idea I'd recommend AWS RDS. You can probably get away with the free tier, which is a micro instance of MySQL.

Collapse
 
thidasapankaja profile image
Thidasa Pankaja Paranavitharana

I think Heroku offers free tier on PostgreSQL . I think it might work for you. Heroku