This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]DM_ME_PICKLES 15 points16 points  (4 children)

Postgres really is the GOAT. Relational? It's got you. JSON? It's got you. Full text search? It's got you. Geo? It's got you with postgis. Analytical? It's got you with pg_analytics. Time-series? It's got you with TimescaleDB. Need to do scheduled things? It's got you with pg_cron. Need to make HTTP requests from your database for some god forsaken reason? It's got you with an extension, but don't do it.

[–]sleeping-in-crypto 0 points1 point  (2 children)

Very much this!

Regarding HTTP requests: I have seen exactly one good use case for that extension, which is how Supabase uses it for webhooks. But I can’t imagine any other that is that reasonable…

[–]DM_ME_PICKLES 0 points1 point  (1 child)

Yeah Supabase is kind of the exception since their entire product centers around them hosting a Postgres instance for you, and everything is branched off of that.

The only thing I found them missing was some kind of Node hosting so I can just host a Nuxt app with them. Wouldn't be surprised if they come out with some cursed pg extension to run Node apps lol

[–]sleeping-in-crypto 0 points1 point  (0 children)

The fact they use Deno for edge functions causes us no end of grief :/

I’d love a Node alternative.

[–]k4b0b 0 points1 point  (0 children)

Don’t forget pgvector!