What is your solution for transactional data storage?
Hello all:
What is your go-to solution for transactional database storage? Do you use a managed product (such as Amazon RDS)? or host it yourself in a VM (cheaper)?
I tend to do everything myself as I am technically oriented but I'm realizing it takes a long time to setup all that is needed to properly secure, encrypt, backup and optimize a DB backend serving a web application.
Trending on Indie Hackers
My focus is building app that benefit customer directly. So I go with AWS RDS Postgres. With 3 years all upfront fee, I can save a bit compared to on demand instance. RDS cost me $6.69 (instance fee) + $2.66 (storage fee) = $9.55 per month while DigitalOcean can cost you $15 per month.
Interesting, I didn't know you could pay upfront and save like this. Thanks!
First I started out with Azure and the likes. The primary downside was the limitation on the number of IOPS. From there on I went to dedicated servers which had 500% the power for 50% of the price, and I have never looked back.
I'm not saying everyone should go this way. At one point I had over a billion data points in a transactional database, which was a pain in the arse. Cloud providers might as well solve your performance requirements are a lot lower.
Awesome, would you mind sharing what provider you use for dedicated hosting?
OVH nowadays. When you wait for a deal to happen you can get them for an incredibly sweet price/month. Even buying a second hand server and colocating it can turn out more expensive.
At a small-ish scale, the amount of money saved by managing it myself just isn't worth it to me. Especially for something as important as my primary data store, where me messing something up would result in data loss or downtime.
I currently use RDS, but I've used Heroku Postgres as well, and they're both great.
Firebase all the way. Easy to set up, epic documentation and generous free limits.
I use firestore over rtdb.
+1 for Postgres, I use it with Ecto for the DB wrapper and host on Heroku, it works quite nicely.
I use RDS. I think it makes sense to pay a little more for a managed service like RDS than trying to do everything for yourself, like the backup and encryption.
My go-to is Postgres on DigitalOcean (unmanaged). I use the Docker image to spin up an instance and configure it from there. Works great!
This comment was deleted 4 years ago.