top | item 46614276

(no title)

dependency_2x | 1 month ago

Postgres will eat the world

discuss

order

cies|1 month ago

I use PGQM and PG_CRON now... Not looking back.

The MySQL + Redis + AWS' elasti-cron (or whatever) was a ghetto compared to Postgres.

saberd|1 month ago

We use pgmq with the pgmq-go client, and it has clients in many different languages, it's amazing. The queues persist on disk and visualizations of queues can easily be made with grafana or just pure sql requests. The fact that the queues lives in the same database as all the other data is also a huge benefit if the 5-15ms time penalty is not an issue.

this_user|1 month ago

At least until people - in a couple of years - figure out that the "Postgres for everything" fad was just as much of a bad idea as "MongoDB for everything" and "Put Redis into everything".

stavros|1 month ago

It's not "Postgres for everything", it's "Postgres by default". Nobody is saying you should replace your billion-message-per-second Kafka cluster (or whatever) with Postgres, but plenty of people are saying "don't start with a Kafka cluster when you have two messages a day", which is a much better idea than "MongoDB by default".

dzonga|1 month ago

however mysql is easier to deal with - I say this as Postgres guy

mysql less maintenance + more performant

pjmlp|1 month ago

RDMS will eat the world.

Turns out it is a matter of feature set.

yawboakye|1 month ago

schema migrations will save our careers! \o/