PostgreSQL for Everything
Points and comments are a snapshot, not live.
PostgreSQL can replace many specialized systems, simplifying IT setups.
Raphael Bauer argues PostgreSQL's flexibility, stability, and active community let it replace full-text search (Solr/Elastic), document storage (MongoDB), message queues (Kafka/RabbitMQ), time-series stores (Clickhouse), vector databases for AI, caching (Redis), and even the filesystem for raw data. He draws on experience since 2003 and recommends always asking "Can't PostgreSQL do this?" before adopting new technology.
What commenters are saying
Commenters largely agree with the PostgreSQL enthusiasm. Several advocate SQLite for simpler apps due to minimal setup and easy upgrade paths, though others warn the type system is poor and dev/prod mismatches can cause bugs. A debate recurs: MySQL vs. PostgreSQL history-commenters note MySQL's early MyISAM speed vs. PostgreSQL's standards compliance and richer features. A common PSA: PostgreSQL lacks plan stability controls, but pg19 adds planner hints.