The hosting of the data can get expensive. For larger projects, you will most likely end up paying for the database (unless you host the database on your own machine).
I'm looking for some DBaaS options for PostgreSQL. Ideally pay-for-what-you-use services (no fixed costs for a plan) with great scalability options.
By the research I've done, I'm aware of:
- Heroku PostgreSQL, which offers pretty limited free tier, like 10k records or so.
- Google Cloud SQL or Amazon RDS, including their free tier for a year.
- Self-hosting on $6 DigitalOcean droplet or similar services.
What are some of the most cost-effective PostgreSQL hosting solutions that you use and would recommend?
Top comments (16)
Squids.io (squids.io/) is a cost-effective database hosting solution. I know they're planning to support PostgreSQL very soon. It allows you host through your own cloud account and charges you zero management fees.
Never heard of it, should explore more 😉👍
I do prefer a VPS droplet aka linode, DigitalOcean.
But I will be hosting the entire application on droplet. Or multiple applications on droplet. Heroku and AWS are too restrictive imo. Though great security defaults.
I see DO have over 50 pricing plans - basic, general purpose, cpu-optimized, memory optimized and storage optimized. The prices range from $6/mo to $2480/mo.
Have you use any of their services?
Usually I go for 5$ basic droplets(6$ is "premium Intel" , 5$ is basic intel) though 10$ droplets make sense just for the 50GB space. It's enough to run multiple applications/db servers as long as you know your way around linux, nginx/apache and the works.
Anything above 50$ a month and you are better off choosing bare metal servers from peeps like OVH cloud.
This is useful info, thanks for the share 🙏❤
I use scaleway as my VPS provider and have seen that they provide DBaaS(Postgresql in particular), although I have not tried it out myself.
It's quite flexible service and billed per hour. Note that it's EU based.
scaleway.com/en/database/
Awesome, should dig into this 👍 Thanks for the share! 😉
What is this for? A side project? If so, you don't need scalability.
Not in a rush to find one now, I was just curious to see the available options if the necessity arises one day 😉
Cost-wise the cheapest would be to host on the same box which is running your app. The advantage of databases as a service is they're easier to manage: upgrades, backups, etc. Personally, I haven't found that to be important for side projects.
Thanks for the share! 🙏❤
I've been really happy with the DigitalOcean Managed PostgreSQL service:
digitalocean.com/products/managed-...
Yeah, I might try it out too, seem promising 😉👍
hasura with graphql
Thanks for the share 🙏❤