PostgreSQL
OpenHalo: MySQL Wire-Compatible PostgreSQL is Here!
April 03, 2025 in PostgreSQL
What? PostgreSQL can now be accessed using MySQL clients? That's right, openHalo, which was open-sourced on April Fool's Day, provides exactly this capability and has now joined the Pigsty kernel family.
What? PostgreSQL can now be accessed using MySQL clients? That's right, openHalo, which was open-sourced on April Fool's Day, provides exactly this capability and has now joined the Pigsty kernel family.
PGFS: Using Database as a Filesystem
March 21, 2025 in PostgreSQL
Leverage JuiceFS to turn PostgreSQL into a filesystem with PITR capabilities!
Leverage JuiceFS to turn PostgreSQL into a filesystem with PITR capabilities!
PostgreSQL Ecosystem Frontier Developments
January 24, 2025 in PostgreSQL
Sharing some interesting recent developments in the PG ecosystem.
Sharing some interesting recent developments in the PG ecosystem.
Pig, The Postgres Extension Wizard
December 23, 2024 in PostgreSQL
Why would we need yet another package manager for PostgreSQL & extensions?
Why would we need yet another package manager for PostgreSQL & extensions?
Don't Upgrade! Released and Immediately Pulled - Even PostgreSQL Isn't Immune to Epic Fails
November 16, 2024 in PostgreSQL
Never deploy on Friday, or you'll be working all weekend! PostgreSQL minor releases were pulled on the day of release, requiring emergency rollback.
Never deploy on Friday, or you'll be working all weekend! PostgreSQL minor releases were pulled on the day of release, requiring emergency rollback.
PostgreSQL 12 End-of-Life, PG 17 Takes the Throne
November 14, 2024 in PostgreSQL
PG17 achieved extension ecosystem adaptation in half the time of PG16, with 300 available extensions ready for production use. PG 12 officially exits support lifecycle.
PG17 achieved extension ecosystem adaptation in half the time of PG16, with 300 available extensions ready for production use. PG 12 officially exits support lifecycle.
The ideal way to deliver PostgreSQL Extensions
November 02, 2024 in PostgreSQL
PostgreSQL Is Eating the Database World through the power of extensibility. With 390 extensions powering PG, we may not say it's invincible, but it’s definitely getting much closer.
PostgreSQL Is Eating the Database World through the power of extensibility. With 390 extensions powering PG, we may not say it's invincible, but it’s definitely getting much closer.
PostgreSQL Convention 2024
October 09, 2024 in PostgreSQL
No rules, no standards. Some developer conventions for PostgreSQL 16.
No rules, no standards. Some developer conventions for PostgreSQL 16.
PostgreSQL 17 Released: No More Pretending!
September 26, 2024 in PostgreSQL
PostgreSQL is now the world's most advanced open-source database and has become the preferred open-source database for organizations of all sizes, matching or exceeding top commercial databases.
PostgreSQL is now the world's most advanced open-source database and has become the preferred open-source database for organizations of all sizes, matching or exceeding top commercial databases.
Can PostgreSQL Replace Microsoft SQL Server?
September 02, 2024 in PostgreSQL
PostgreSQL can directly replace Oracle, SQL Server, and MongoDB at the kernel level. Of course, the most thorough replacement is SQL Server - AWS's Babelfish provides wire-protocol-level compatibility.
PostgreSQL can directly replace Oracle, SQL Server, and MongoDB at the kernel level. Of course, the most thorough replacement is SQL Server - AWS's Babelfish provides wire-protocol-level compatibility.