-
v3.1: PG 17 as default, Better Supabase & MinIO, ARM & U24 support
2024-11-24 in Releases
With the release of PostgreSQL 17.2 earlier this week, Pigsty promptly followed up with its v3.1 release. In this version, PostgreSQL 17 has been promoted as the default major version, and nearly 400 PostgreSQL extensions are now available out of the …
-
Don't Update! Rollback Issued on Release Day: PostgreSQL Faces a Major Setback
2024-11-16 in Postgres
As the old saying goes, never release code on Friday. Although PostgreSQL’s recent minor release carefully avoided a Friday launch, it still gave the community a full week of extra work — PostgreSQL will release an unscheduled emergency update …
-
PostgreSQL 12 Reaches End-of-Life as PG 17 Takes the Throne
2024-11-14 in Postgres
According to PostgreSQL’s versioning policy, PostgreSQL 12, released in 2019, officially exits its support lifecycle today (November 14, 2024). PostgreSQL 12’s final minor version, 12.21, released today (November 14, 2024), marks the end …
-
The idea way to install PostgreSQL Extensions
2024-11-02 in Postgres
PostgreSQL Is Eating the Database World through the power of extensibility. With 400 extensions powering PostgreSQL, we may not say it’s invincible, but it’s definitely getting much closer. I believe the PostgreSQL community has reached a …
-
PostgreSQL 17 Released: The Database That's Not Just Playing Anymore!
2024-09-26 in Postgres
The annual PostgreSQL major release is here! What surprises does PostgreSQL 17 have in store for us? In this release announcement, the PostgreSQL global community has finally dropped the act — sorry, we’re not playing anymore — …
-
Can PostgreSQL Replace Microsoft SQL Server?
2024-09-02 in Postgres
Many people don’t have a clear picture of how far the PostgreSQL ecosystem has evolved. Beyond devouring the database world with its all-encompassing extension ecosystem, PostgreSQL can now directly replace Oracle, SQL Server, and MongoDB at …
-
Whoever Integrates DuckDB Best Wins the OLAP World
2024-08-13 in Postgres
In the post “PostgreSQL is Eating the World”, I posed a question: Who will ultimately unify the database world? My take is that it’ll be the PostgreSQL ecosystem coupled with a rich variety of extension plugins. And I believe that to conquer …
-
Pigsty v3.0: Extension Exploding & Plugable Kernels
2024-08-05 in Releases
Get started with: curl -fsSL https://repo.pigsty.io/get | bash cd ~/pigsty; ./bootstrap; ./configure; ./install.yml Highlight Features Extension Exploding: Pigsty now has an unprecedented 400 available extensions for PostgreSQL. This includes 121 …
-
StackOverflow 2024 Survey: PostgreSQL Is Dominating the Field
2024-07-25 in Postgres
2024 StackOverflow Global Developer Survey Results have just been released, featuring high-quality responses from 60,000 developers in 185 countries and regions. Naturally, as a seasoned database aficionado, the part I’m most interested in is the …
-
MySQL is dead, Long live PostgreSQL!
2024-07-08 in Database
This July, MySQL 9.0 was finally released—a full eight years after its last major version, 8.0 (@2016-09). Yet, this hollow “innovation” release feels like a bad joke, signaling that MySQL is on its deathbed. While PostgreSQL continues to …