What database do you choose? I'm looking for something like SQL but affordable. Do you run your own or use a managed service?
For further actions, you may consider blocking this person and/or reporting abuse
What database do you choose? I'm looking for something like SQL but affordable. Do you run your own or use a managed service?
For further actions, you may consider blocking this person and/or reporting abuse
Michael Tharrington -
Ujjawal Tyagi -
Harutyun Mardirossian -
dev.to staff -
Top comments (12)
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:
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.
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!
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.
Can you elaborate a bit? What's your use case?
A service marketplace
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...
Good points right now I just want to verify there's a market for this idea so it's light on tech needs
An example about running PostgreSQL on Digital Ocean digitalocean.com/community/tutoria...
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
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.
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.
I think Heroku offers free tier on PostgreSQL . I think it might work for you. Heroku