Comment by adeptima | Hacker News Reader

Comment by adeptima | Hacker News Reader

100% agree with brasetvik! So much efforts put in it!

Postgres is not just a database, but "database OS"

Discovered it a few months ago, and going through its last year posts and videos.

Postgres ecosystem is clearly booming with all its extensions like pgvector, paradedb and many many amazing tools, and derived projects

All videos annotated and accompanied with summary article

https://pganalyze.com/blog

Just look at the past 3 episodes

- E118 https://pganalyze.com/blog/5mins-postgres-17-materialized-ct...

- E117 https://pganalyze.com/blog/5mins-postgres-planner-join-equiv...

- E116 https://pganalyze.com/blog/5mins-postgres-17-beta1

Scaling Postgres is a great too

- https://www.youtube.com/@ScalingPostgres/videos

- https://www.scalingpostgres.com/episodes/

Postgres is eating the database world

https://medium.com/@fengruohang/postgres-is-eating-the-datab...

PG Feature Matrix https://www.postgresql.org/about/featurematrix/

I'd also add https://postgres.fm to the list if you are looking for a Postgres in production podcast that explains a lot of things. I always feel like I learn something new even if it's just something small.

thnx!

MySQL has had pluggable storage since at least 2010. A decade and a half later, PostgreSQL still doesn't (although I believe some forks do).

PostgreSQL is a good piece of software. And really good pieces of software -- git, Linux, Redis, tend to collect ecosystems.

Since Postgres 12, there's been support for “Pluggable Storage” where you could even define different storage engines for tables individually. Think of the Oriole extension which bought by Supabase in April 2024.

Whats the difference between DB OS vs Database?

I don’t think “DB OS” is a standard term, but what I believe the commenter means is that postgres has evolved to become an incredibly mature, well built set of DB building blocks that are exposed via extension APIs etc to implement whatever kind of database you want.

Sure, there’s the core row-major RDBMS you get out of the box, but could easily turn that into a distributed column-oriented analytics data warehouse if you wanted to.

Let me do a lazy copy-paste "The phrase "Postgres is the database OS" is often attributed to Bruce Momjian, a co-founder of the PostgreSQL Global Development Group and a prominent figure in the PostgreSQL community. He has frequently used this phrase to highlight the extensibility and versatility of PostgreSQL, comparing it to an operating system in terms of its ability to support a wide range of functionalities through extensions and customizations."

Reply on news.ycombinator.com