3 ms·

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

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 https://pganalyze.com/blog Just look at the past 3 episodes - E118 https://pganalyze.com/blog/5mins-postgres-17-materialized-cte-scans https://pganalyze.com/blog/5mins-postgres-17-materialized-ct... - E117 https://pganalyze.com/blog/5mins-postgres-planner-join-equivalence-class-in-any-filters https://pganalyze.com/blog/5mins-postgres-planner-join-equiv... - E116 https://pganalyze.com/blog/5mins-postgres-17-beta1 https://pganalyze.com/blog/5mins-postgres-17-beta1 Scaling Postgres is a great too - https://www.youtube.com/@ScalingPostgres/videos https://www.youtube.com/@ScalingPostgres/videos - https://www.scalingpostgres.com/episodes/ https://www.scalingpostgres.com/episodes/ Postgres is eating the database world https://medium.com/@fengruohang/postgres-is-eating-the-database-world-157c204dcfc4 https://medium.com/@fengruohang/postgres-is-eating-the-datab... PG Feature Matrix https://www.postgresql.org/about/featurematrix/ https://www.postgresql.org/about/featurematrix/

IamLoading 2y ago
Whats the difference between DB OS vs Database?
- _hl_ 2y ago
  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.
- adeptima 2y ago
  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."
dewey 2y ago
I'd also add https://postgres.fm 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.
- adeptima 2y ago
  thnx!
paulddraper 2y ago
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.
- markoman 2y ago
  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.

IamLoading 2y ago

Whats the difference between DB OS vs Database?

_hl_ 2y ago
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.
adeptima 2y ago
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."

dewey 2y ago

I'd also add https://postgres.fm 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.

adeptima 2y ago
thnx!

paulddraper 2y ago

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.

markoman 2y ago
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.