Ask HN: Where are you hosting your Postgres database in 2024?

https://news.ycombinator.com/item?id=41534759

by pier25 • 2 years ago

15 15 2 years ago

news.ycombinator.com

mahin• 2 years ago

Digital Ocean. Easy setup and backups. Can scale it vertically for a while.

codeptualize• 2 years ago

Supabase.

We do also use their auth, storage, api, etc. But even if you just want to host a postgres db it's still worth checking out I think.

It's managed postgres, 2 free db's, connection pooler, super easy read replicas (requires a larger paid instance), backups, lots of tooling/dashboards/advisories, cli for running locally during development, database branching, backups, fdw, and lots more. All of it open source.

You can turn off the data api's etc if you just want to connect directly: https://supabase.com/docs/guides/database/hardening-data-api...

geekodour3• 2 years ago

quick aside note: i heard great things about supabase and wanted to use it for auth. I wanted to maintain my own db, user tables etc.

but using supabase for auth, this means if need to play w RLS but i had a very simple db design and didn't want to include rls yet. supabase won't let me do it afaik.

so i switched to using ory/kratos ultimately.

also q, how heavily are we dependent on supabase ecosystem if all we want is the db?

kiwicopple3• 2 years ago

You are not dependent if you just use the database. You can just pg_dump and and take your data to any other postgres service

mmarian• 2 years ago

For my personal projects - Inside my CapRover managed cluster of services, all on the cheapest Hetzner VPS. At work it's AWS RDS.

rozenmd• 2 years ago

AWS RDS, have clocked 0 downtime in 3.5 years, does the job.

samokhvalov• 2 years ago

have you had minor and major upgrades? with really 0 downtime?

leros• 2 years ago

Render

StickyRibbs• 2 years ago

Google Cloud SQL

rwdf• 2 years ago

In k8s in our on prem private cloud using cloud native Postgres: https://cloudnative-pg.io

sph• 2 years ago

On my server, now a VPS, as I have done for the past 25 years.

Ask HN: Where are you hosting your Postgres database in 2024?

Related Stories