Hacker Remix

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

15 points by pier25 9 months ago | 15 comments

codeptualize 9 months 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...

geekodour 9 months 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?

kiwicopple 9 months 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

geekodour 9 months ago

I meant while using the db, i want to use sqlc and pgx with the postgres db instead of supabase api(s) that should work out right? i haven't tried but i think that should work ootb.

edit: yes that should be possible that's what op mentioned

kiwicopple 9 months ago

Yes, we have plenty of customers doing just that. You can connect to the pg instance directly or using the connection pooler. You can also disable the Data API (PostgREST) if you want so that you have less security surface area to manage (eg, you don’t need to set up RLS policies if you are connecting only from the server)

geekodour 9 months ago

awesome to know! but disabling rls and the data api does sabotage the use of supabase auth right? (in ref. to my previous message, just confirming if my checks were correct) i actually just wanted to use supabase because how convient it was for the entire auth flow. password email, reset etc. having to manually built a ui for it is out of question but the solution I am using right now (ory/kratos) has some cli utilities so that helps but still not as good as supabase auth ui ofc. keep making it better!

kiwicopple 9 months ago

You can still use all the Authentication features of supabase Auth if you disable the data APIs (you just don’t need to use RLS for managing Authorization to your data)

Supabase is designed to work like LEGO, you add the blocks you want, and we keep everything as modular as possible so that you can combine it with other services like kratos if you prefer

mmarian 9 months 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 9 months ago

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

samokhvalov 9 months ago

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

rwdf 9 months ago

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

mahin 9 months ago

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

sph 9 months ago

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

StickyRibbs 9 months ago

Google Cloud SQL

leros 9 months ago

Render

mergisi 9 months ago

[flagged]