PostgreSQL

Posts in 2025
  • PostgreSQL Has Dominated the Database World

    July 31, 2025 in PostgreSQL

    PostgreSQL Has Dominated the Database World

    The 2025 SO global developer survey results are fresh out, and PostgreSQL has become the most popular, most loved, and most wanted database for the third consecutive year. Nothing can stop PostgreSQL from consolidating the entire database world!

    The 2025 SO global developer survey results are fresh out, and PostgreSQL has become the most popular, most loved, and most wanted database for the third consecutive year. Nothing can stop PostgreSQL from consolidating the entire database world!

  • PGDG Cuts Off Mirror Sync Channel

    July 07, 2025 in PostgreSQL

    PGDG Cuts Off Mirror Sync Channel

    PGDG cuts off FTP rsync sync channels, global mirror sites universally disconnected - this time they really strangled global users' supply chain.

    PGDG cuts off FTP rsync sync channels, global mirror sites universally disconnected - this time they really strangled global users' supply chain.

  • Postgres Extension Day - See You There!

    April 09, 2025 in PostgreSQL

    Postgres Extension Day - See You There!

    The annual PostgreSQL developer conference will be held in Montreal in May. Like the first PG Con.Dev, there's also an additional dedicated event - Postgres Extensions Day

    The annual PostgreSQL developer conference will be held in Montreal in May. Like the first PG Con.Dev, there's also an additional dedicated event - Postgres Extensions Day

  • OrioleDB is Coming! 4x Performance, Eliminates Pain Points, Storage-Compute Separation

    April 06, 2025 in PostgreSQL

    OrioleDB is Coming! 4x Performance, Eliminates Pain Points, Storage-Compute Separation

    A PG kernel fork acquired by Supabase, claiming to solve PG's XID wraparound problem, eliminate table bloat issues, improve performance by 4x, and support cloud-native storage. Now part of the Pigsty family.

    A PG kernel fork acquired by Supabase, claiming to solve PG's XID wraparound problem, eliminate table bloat issues, improve performance by 4x, and support cloud-native storage. Now part of the Pigsty family.

  • OpenHalo: MySQL Wire-Compatible PostgreSQL is Here!

    April 03, 2025 in PostgreSQL

    OpenHalo: MySQL Wire-Compatible PostgreSQL is Here!

    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

    PGFS: Using Database as a Filesystem

    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

    PostgreSQL Ecosystem Frontier Developments

    Sharing some interesting recent developments in the PG ecosystem.

    Sharing some interesting recent developments in the PG ecosystem.

Posts in 2024
  • Pig, The Postgres Extension Wizard

    December 23, 2024 in PostgreSQL

    Pig, The Postgres Extension Wizard

    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

    Don't Upgrade! Released and Immediately Pulled - Even PostgreSQL Isn't Immune to Epic Fails

    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

    PostgreSQL 12 End-of-Life, PG 17 Takes the Throne

    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.