Just use Postgres for everything (amazingcto.com)

Article summary

The article argues that using PostgreSQL for everything can simplify a tech stack, reduce complexity, and boost development speed. It claims that PostgreSQL can replace many backend technologies, such as Redis, MongoDB, and Kafka, for applications serving up to millions of users. The author suggests that this approach can lead to faster feature development, reduced operational overhead, and a single point of expertise. By using PostgreSQL for everything, developers can focus on solving business problems rather than managing multiple specialized tools.

Main themes

• PostgreSQL as a multi-tool
• Simplifying tech stacks
• Specialization vs simplicity
• Database abstraction
• Scalability and performance
• Maintainability and oversight

What commenters say

• Using PostgreSQL for everything can simplify a tech stack and reduce complexity, but may not be suitable for very high traffic or specialized use cases.
• Abstracting away PostgreSQL or SQL can be unnecessary and may even hinder productivity.
• PostgreSQL can be used as a job queue, data warehouse, and for other specialized tasks, but may require additional tools or customization.
• Some commenters disagree with using stored procedures, citing potential issues with maintainability and oversight.
• Others argue that a simple system like PostgreSQL can be sufficient for most projects and can be scaled or replaced as needed.
• There is a trade-off between simplicity and specialization, and the choice of tool depends on the specific needs of the project.
• Using PostgreSQL for everything can lead to a monolithic system that is difficult to maintain or replace if it becomes outdated or insufficient.