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

a year ago by cm0002 to c/postgresql

We need to talk about something that's been bothering me for months. I've been watching indie hackers...
Endmaker 19 points a year ago

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.

path: 0 17675930, hotness: undefined, score: 19, children: 1
jubilationtcornpone 8 points a year ago

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).

path: 0 17675930 17679076, hotness: undefined, score: 8, children: 0
veer66 2 points a year ago
path: 0 17684129, hotness: undefined, score: 2, children: 0
zr0 1 point a year ago

laughs in ClickHouse

path: 0 17679647, hotness: undefined, score: 1, children: 0
postgresql
postgresql

@programming.dev

login for more options
2251
203
21

The world's most advanced open source relational database

Project
Events
Podcasts
Related Fediverse communities

go to feed...