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

PostgreSQL

1199 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
[–] Endmaker@ani.social 17 points 1 month ago* (last edited 1 month 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.

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

[–] zr0@lemmy.dbzer0.com 1 points 1 month ago

laughs in ClickHouse

[–] veer66@social.vivaldi.net 1 points 1 month ago

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