-
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 …
-
v3.4: MySQL Wire-Compatibility and Improvements
2025-03-31 in Releases
After a month of intensive development, Pigsty v3.4 is officially released! This release brings support for a new PostgreSQL kernel and significant architectural optimizations, addressing several key concerns from customers and users: Support for …
-
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 …
-
Database Planet Collision: When PG Falls for DuckDB
2025-03-12 in Database
When I published “PostgreSQL Is Eating the Database World” last year, I tossed out this wild idea: Could Postgres really unify OLTP and OLAP? I had no clue we’d see fireworks so quickly. The PG community’s now in an all-out frenzy to stitch DuckDB …
-
v3.3：Extension 404，Odoo, Dify, Supabase, Nginx Enhancement
2025-02-25 in Releases
After two months of careful polishing, Pigsty v3.3 is officially released! As an open-source, “battery-included” PostgreSQL distribution, Pigsty aims to optimize the PostgreSQL ecosystem and provide smooth self-hosting experience just …
-
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 …
-
v3.2: The pig CLI, ARM64 Repo, Self-hosting Supabase
2024-12-29 in Releases
The New Year is just around the corner, and Pigsty is celebrating the last release of 2024 with v3.2. This release introduces a new command-line tool, pig, and enhanced ARM extension support. Together, these features deliver a smooth PostgreSQL …
-
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 …
-
Self-Hosting Supabase on PostgreSQL
2024-11-25 in Database
Supabase is great, own your own Supabase is even better. Here’s a comprehensive tutorial for self-hosting production-grade supabase on local/cloud VM/BMs. What is Supabase? Supabase is an open-source Firebase alternative, a Backend as a Service …