Picking a cloud database?

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

Comments

[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.

[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!

[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.

[rhymes]

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

[Alan Barr]

A service marketplace

[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...

[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

[rhymes]

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

[Aswath KNM]

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

[caubeen]

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.

[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.

[Thidasa Pankaja Paranavitharana]

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