this post was submitted on 15 Jun 2025
42 points (100.0% liked)

PostgreSQL

1079 readers
1 users here now

The world's most advanced open source relational database

Project
Events
Podcasts
Related Fediverse communities

founded 2 years ago
MODERATORS
top 4 comments
sorted by: hot top controversial new old
[–] [email protected] 17 points 2 days ago* (last edited 2 days ago) (1 children)

TLDR

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

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.

[–] [email protected] 7 points 2 days 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).

[–] [email protected] 1 points 2 days ago

@cm0002 I'm using PostgreSQL's JSON queries, full-text search, and pattern search with n-gram index.

[–] zr0 1 points 2 days ago

laughs in ClickHouse