DEV Community

Discussion on: How much does Postgres cost?

View post
Collapse
 
mayowa profile image
mayowa •

I know your question is heroku specific, but have you considered using a VPS?
A $5 VPS from either DigitalOcean or Linode would make managing your costs a lot more predictable not to talk of cheaper.

AFAICT nothing prevents you from using Heroku for your code and a VPS for your database

Installing postgres on an Ubuntu server is a s simple as

sudo apt install postgresql
Enter fullscreen mode Exit fullscreen mode

Creating the database

sudo -u postgres psql -c "create database myappdb with encoding utf8"
Enter fullscreen mode Exit fullscreen mode

And so on.

My appologies if I've somehow missed the obvious, but if your project requirements/limitations do not bind you to using Heroku for your entire stack, perhaps you might want to consider this alternative

Collapse
 
patarapolw profile image
Pacharapol Withayasakpunt •

I do consider that, but I am not sure if I am ready for sysadmin job.

Other than the database itself, I will need,

  • Monitoring
  • Backup, with crontab

I will consider it later, after I exceed the limit.