Get the latest tech news

Using Postgres for Everything


What Postgres for Everything means to a dev deploying all sorts of databases. Spoiler: it’s about collapsing your stack & keeping your world simple.

So, you might end up adopting various existing databases: Postgres for transactional data, Elastic for full-text search, Influx for time series, Pinecone for vector operations, and maybe ClickHouse for analytics. There’s a well-known argument that you should pick the "best tool for the job," which sometimes gets turned on its head as, “If you’ve only got a hammer, everything looks like a nail.” I don’t see the principle of "PostgreSQL for Everything" contradicting these, as long as you make sure you look at the big picture. Given these scenarios, I’d argue that the theoretical future challenges of a PostgreSQL-centric system are preferable to today’s complexities of opting into a multi-database architecture too early.

Get the Android app

Or read this on Hacker News

Read more on:

Photo of Postgres

Postgres

Related news:

News photo

Scaling Clubhouse From 10K to 10M Users In 6 Months With Postgres

News photo

Making a Postgres query 1k times faster

News photo

The notifier pattern for applications that use Postgres