DEV Community

Cover image for Where do you host your PostgreSQL?

Where do you host your PostgreSQL?

Madza on September 21, 2021

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

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

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

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

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

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

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

Yeah, I might try it out too, seem promising 😉👍

Collapse
 
jdgamble555 profile image
Jonathan Gamble

hasura with graphql

Collapse
 
madza profile image
Madza

Thanks for the share 🙏❤