-
OrioleDB is Here! 4x Performance, Zero Bloat, Decoupled Storage
2025-04-06 in Postgres
OrioleDB - while the name might make you think of cookies, it’s actually named after the songbird. But whether you call it Cookie DB or Bird DB doesn’t matter - what matters is that this PG storage engine extension + kernel fork is …
-
OpenHalo: PostgreSQL Now Speaks MySQL Wire Protocol!
2025-04-03 in Postgres
PostgreSQL speaking MySQL? Yes, you read that right. OpenHalo, freshly open-sourced on April Fools’ Day, brings this capability to life - allowing users to read, write, and manage the same database using both MySQL and PostgreSQL clients. Built …
-
PGFS: Using PostgreSQL as a File System
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 …