c/postgresql · by cm0002@lemmy.world · 1y

Postgres is Too Good (And Why That's Actually a Problem)

https://dev.to/shayy/postgres-is-too-good-and-why-thats-actually-a-problem-4imc

44 points · 3 comments · view on lemmy.world

3 Comments

Endmaker@ani.social · 19 pts · 1y (1 reply)

TLDR

Redis for caching, RabbitMQ for queues, Elasticsearch for search, and MongoDB for... reasons?

Postgres can do literally all of this.

Postgres might be too good for its own good. It's so capable that it makes most other databases seem unnecessary for 90% of applications.

Thanks for sharing. The built-in text search sounds helpful for the project I'm working on.

jubilationtcornpone@sh.itjust.works · 8 pts · 1y

The full text search works quite well. Also, if you just HAVE to store a bunch of data in JSON, it will do that too as well as index and query it. No need for MongoDB (which is the wrong tool for the job 99% of the time anyways).

veer66@social.vivaldi.net · 2 pts · 1y

[ removed ]

zr0@lemmy.dbzer0.com · 1 pts · 1y

laughs in ClickHouse