DEV Community

Cover image for Where do you host your PostgreSQL?
Madza
Madza

Posted on

Where do you host your PostgreSQL?

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:

What are some of the most cost-effective PostgreSQL hosting solutions that you use and would recommend?

Discussion (16)

Collapse
elliechecksoutwithgithub profile image
elliechecksoutwithgithub

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.

Collapse
madza profile image
Madza Author

Never heard of it, should explore more πŸ˜‰πŸ‘

Collapse
karandpr profile image
Karan Gandhi

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.

Collapse
madza profile image
Madza Author

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?

Collapse
karandpr profile image
Karan Gandhi

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.

Thread Thread
madza profile image
Madza Author

This is useful info, thanks for the share πŸ™β€

Collapse
cipharius profile image
Valts Liepiņő

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/

Collapse
madza profile image
Madza Author

Awesome, should dig into this πŸ‘ Thanks for the share! πŸ˜‰

Collapse
aghost7 profile image
Jonathan Boudreau

What is this for? A side project? If so, you don't need scalability.

Collapse
madza profile image
Madza Author

Not in a rush to find one now, I was just curious to see the available options if the necessity arises one day πŸ˜‰

Collapse
aghost7 profile image
Jonathan Boudreau

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.

Thread Thread
madza profile image
Madza Author

Thanks for the share! πŸ™β€

Collapse
bobbyiliev profile image
Bobby Iliev

I've been really happy with the DigitalOcean Managed PostgreSQL service:

digitalocean.com/products/managed-...

Collapse
madza profile image
Madza Author

Yeah, I might try it out too, seem promising πŸ˜‰πŸ‘

Collapse
jdgamble555 profile image
Jonathan Gamble

hasura with graphql

Collapse
madza profile image
Madza Author

Thanks for the share πŸ™β€