-
PGFS: Using DB as FS
2025-03-21 in Postgres
Recently, I received an interesting request from the Odoo community. They were grappling with a fascinating challenge: “If databases can do PITR (Point-in-Time Recovery), is there a way to roll back the file system as well?” The Birth of …
-
PostgreSQL Frontier
2025-01-24 in Postgres
Dear readers, I’m off on vacation starting today—likely no new posts for about two weeks. Let me wish everyone a Happy New Year in advance. Of course, before heading out, I wanted to share some recent interesting developments in the Postgres …
-
Pig, The PostgreSQL Extension Wizard
2024-12-29 in Postgres
Ever wished installing or upgrading PostgreSQL extensions didn’t feel like digging through outdated readmes, cryptic configure scripts, or random GitHub forks & patches? The painful truth is that Postgres’s richness of extension often comes at …
-
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 …
-
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 …