Blog Columns
Six thematic columns, each with its own dedicated RSS feed.
Database Guru
77posts
Database news, industry surveys, architecture, and best practices.
Cloud-Exiter
67posts
Cloud economics, repatriation, and building sovereign infrastructure.
Postgres Mage
130posts
PostgreSQL ecosystem, internals, extensions, and production tuning.
AI Agent Explorer
100posts
Practical engineering with coding agents, LLMs, AI4DB, and DB4AI.
Travel Notes
12posts
Trips, hikes, landscapes, and field notes across mountains and seas.
Miscellaneous
41posts
Essays, reflections, and personal writing inside and outside of tech.

Database Planet Collision: When PG Falls for DuckDB
If you ask me, we’re on the brink of a cosmic collision in database-land, and Postgres + DuckDB is the meteor we should all be watching.

Alicloud’s rds_duckdb: Tribute or Rip-Off?
Does bolting DuckDB onto RDS suddenly make open-source Postgres ‘trash’? Business and open source should be symbiotic. If a vendor only extracts without giving back, the community will spit it out."

Comparing Oracle and PostgreSQL Transaction Systems
The PG community has started punching up: Cybertec's Laurenz Albe breaks down how Oracle's transaction system stacks against PostgreSQL.

Pigsty v3.3: 404 Extensions, Turnkey Apps, New Website
Pigsty v3.3 pushes available extensions to 404, adds turnkey app deployment with app.yml, delivers Certbot integration for automated HTTPS, and launches a redesigned website.

PostgreSQL Ecosystem Frontier Developments
Sharing some interesting recent developments in the PG ecosystem.

Database as Business Architecture
Databases are the core of business architecture, but what happens if we go further and let databases become the business architecture itself?

Escaping Cloud Computing Scam Mills: The Big Fool Paying for Pain
A user consulted about distributed databases, but he wasn't dealing with data bursting through server cabinet doors—rather, he'd fallen into another cloud computing pig-butchering scam.

Pigsty v3.2: The pig CLI, Full ARM Support, Supabase & Grafana Enhancements
Pigsty v3.2 introduces the pig CLI for PostgreSQL package management, complete ARM64 extension repository support, and Supabase & Grafana enhancements.

Pig, The Postgres Extension Wizard
Why would we need yet another package manager for PostgreSQL & extensions?

OpenAI Global Outage Postmortem: K8S Circular Dependencies
Even trillion-dollar unicorns can be a house of cards when operating outside their core expertise.

Solving the 24-Point Card Game with a Single SQL Query
A fun but devious challenge: solve the 24-point card game in SQL. Here is the PostgreSQL answer.

7 Databases in 7 Weeks (2025)
Is PostgreSQL the king of boring databases? Here are seven databases worth studying in 2025: PostgreSQL, SQLite, DuckDB, ClickHouse, FoundationDB, TigerBeetle, and CockroachDB—each deserving a week of …

Self-Hosting Supabase on PostgreSQL
Supabase is great, own your own Supabase is even better. A tutorial for self-hosting production-grade supabase on local/cloud/ VM/BMs.

Pigsty v3.1: One-Click Supabase, PG17 Default, ARM & Ubuntu 24
Pigsty v3.1 makes PostgreSQL 17 the default, delivers one-click Supabase self-hosting, adds ARM64 and Ubuntu 24.04 support, and simplifies configuration management.

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.

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.

The Ideal Way to Deliver PostgreSQL Extensions
PostgreSQL is eating the database world through extensibility. This post introduces the Pigsty extension repository, which packaged 390 PostgreSQL extensions at launch and keeps growing through the …

Open-Source "Tyrant" Linus's Purge
The Linux community is essentially imperial — and Linus himself is the earliest and most successful technical dictator. People are used to Linus's generosity but forget this point.

WordPress Community Civil War: On Community Boundary Demarcation
When open source ideals meet commercial conflicts, what insights can this conflict between open source software communities and cloud vendors bring? On the importance of community boundary …

Cloud Database: Michelin Prices for Cafeteria Pre-made Meals
The paradigm shift brought by RDS, whether cloud databases are overpriced cafeteria meals. Quality, security, efficiency, and cost analysis, cloud exit database self-building: how to implement in …

PostgreSQL 17 Released: No More Pretending!
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.

Alibaba-Cloud: High Availability Disaster Recovery Myth Shattered
Seven days after Singapore Zone C failure, availability not even reaching 8, let alone multiple 9s. But compared to data loss, availability is just a minor issue

Optimize Bio Cores First, CPU Cores Second
Programmers are expensive, scarce biological computing cores, the anchor point of software costs — please prioritize optimizing biological cores before optimizing CPU cores.

MongoDB Has No Future: Good Marketing Can't Save a Rotten Mango
MongoDB has a terrible track record on integrity, lackluster products and technology, gets beaten by PG in correctness, performance, and functionality, with collapsing developer reputation, declining …

Database Planet Collision: When PG Falls for DuckDB
If you ask me, we’re on the brink of a cosmic collision in database-land, and Postgres + DuckDB is the meteor we should all be watching.

Alicloud’s rds_duckdb: Tribute or Rip-Off?
Does bolting DuckDB onto RDS suddenly make open-source Postgres ‘trash’? Business and open source should be symbiotic. If a vendor only extracts without giving back, the community will spit it out."

Comparing Oracle and PostgreSQL Transaction Systems
The PG community has started punching up: Cybertec's Laurenz Albe breaks down how Oracle's transaction system stacks against PostgreSQL.

Pigsty v3.3: 404 Extensions, Turnkey Apps, New Website
Pigsty v3.3 pushes available extensions to 404, adds turnkey app deployment with app.yml, delivers Certbot integration for automated HTTPS, and launches a redesigned website.

PostgreSQL Ecosystem Frontier Developments
Sharing some interesting recent developments in the PG ecosystem.

Database as Business Architecture
Databases are the core of business architecture, but what happens if we go further and let databases become the business architecture itself?

Escaping Cloud Computing Scam Mills: The Big Fool Paying for Pain
A user consulted about distributed databases, but he wasn't dealing with data bursting through server cabinet doors—rather, he'd fallen into another cloud computing pig-butchering scam.

Pigsty v3.2: The pig CLI, Full ARM Support, Supabase & Grafana Enhancements
Pigsty v3.2 introduces the pig CLI for PostgreSQL package management, complete ARM64 extension repository support, and Supabase & Grafana enhancements.

Pig, The Postgres Extension Wizard
Why would we need yet another package manager for PostgreSQL & extensions?

OpenAI Global Outage Postmortem: K8S Circular Dependencies
Even trillion-dollar unicorns can be a house of cards when operating outside their core expertise.

Solving the 24-Point Card Game with a Single SQL Query
A fun but devious challenge: solve the 24-point card game in SQL. Here is the PostgreSQL answer.

7 Databases in 7 Weeks (2025)
Is PostgreSQL the king of boring databases? Here are seven databases worth studying in 2025: PostgreSQL, SQLite, DuckDB, ClickHouse, FoundationDB, TigerBeetle, and CockroachDB—each deserving a week of …

Self-Hosting Supabase on PostgreSQL
Supabase is great, own your own Supabase is even better. A tutorial for self-hosting production-grade supabase on local/cloud/ VM/BMs.

Pigsty v3.1: One-Click Supabase, PG17 Default, ARM & Ubuntu 24
Pigsty v3.1 makes PostgreSQL 17 the default, delivers one-click Supabase self-hosting, adds ARM64 and Ubuntu 24.04 support, and simplifies configuration management.

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.

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.

The Ideal Way to Deliver PostgreSQL Extensions
PostgreSQL is eating the database world through extensibility. This post introduces the Pigsty extension repository, which packaged 390 PostgreSQL extensions at launch and keeps growing through the …

Open-Source "Tyrant" Linus's Purge
The Linux community is essentially imperial — and Linus himself is the earliest and most successful technical dictator. People are used to Linus's generosity but forget this point.

WordPress Community Civil War: On Community Boundary Demarcation
When open source ideals meet commercial conflicts, what insights can this conflict between open source software communities and cloud vendors bring? On the importance of community boundary …

Cloud Database: Michelin Prices for Cafeteria Pre-made Meals
The paradigm shift brought by RDS, whether cloud databases are overpriced cafeteria meals. Quality, security, efficiency, and cost analysis, cloud exit database self-building: how to implement in …

PostgreSQL 17 Released: No More Pretending!
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.

Alibaba-Cloud: High Availability Disaster Recovery Myth Shattered
Seven days after Singapore Zone C failure, availability not even reaching 8, let alone multiple 9s. But compared to data loss, availability is just a minor issue

Optimize Bio Cores First, CPU Cores Second
Programmers are expensive, scarce biological computing cores, the anchor point of software costs — please prioritize optimizing biological cores before optimizing CPU cores.

MongoDB Has No Future: Good Marketing Can't Save a Rotten Mango
MongoDB has a terrible track record on integrity, lackluster products and technology, gets beaten by PG in correctness, performance, and functionality, with collapsing developer reputation, declining …
Database Planet Collision: When PG Falls for DuckDB

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 …
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 …
Alicloud’s rds_duckdb: Tribute or Rip-Off?

A viral post titled “Heavenly ‘PostgreSQL’ Calls Earthly Postgres ‘Little Trash’” hyped up Alicloud RDS’s new rds_duckdb plugin for OLAP and declared that managed RDS PG is noble while open-source Postgres is garbage. That take is ridiculous. I know …
A viral post titled “Heavenly ‘PostgreSQL’ Calls Earthly Postgres ‘Little Trash’” hyped up Alicloud RDS’s new rds_duckdb plugin for OLAP and declared that managed RDS PG is noble while open-source Postgres is garbage. That take is ridiculous. I know …
Comparing Oracle and PostgreSQL Transaction Systems

Original by Laurenz Albe. Translation and commentary by Feng Ruohang. Transactions sit at the heart of relational databases. They guarantee data integrity for applications. SQL defines some transactional behavior but leaves plenty unspecified, so …
Original by Laurenz Albe. Translation and commentary by Feng Ruohang. Transactions sit at the heart of relational databases. They guarantee data integrity for applications. SQL defines some transactional behavior but leaves plenty unspecified, so …
Pigsty v3.3: 404 Extensions, Turnkey Apps, New Website

GitHub Release | Release Note After two months of careful refinement, Pigsty v3.3 is officially released. As an open-source “batteries-included” PostgreSQL distribution, Pigsty aims to harness the collective power of the PG ecosystem, delivering a …
GitHub Release | Release Note After two months of careful refinement, Pigsty v3.3 is officially released. As an open-source “batteries-included” PostgreSQL distribution, Pigsty aims to harness the collective power of the PG ecosystem, delivering a …
PostgreSQL Ecosystem Frontier Developments

Dear readers, I’m starting my vacation today. I might stop posting for two weeks, so Happy New Year in advance. Of course, before starting vacation, this article shares some interesting recent developments in the PG ecosystem. Yesterday I also …
Dear readers, I’m starting my vacation today. I might stop posting for two weeks, so Happy New Year in advance. Of course, before starting vacation, this article shares some interesting recent developments in the PG ecosystem. Yesterday I also …
Database as Business Architecture

Databases are the core of business architecture - this is self-evident consensus. But what if we go further and treat databases as business architecture itself, putting business logic, web servers, and even entire front and back ends into databases? …
Databases are the core of business architecture - this is self-evident consensus. But what if we go further and treat databases as business architecture itself, putting business logic, web servers, and even entire front and back ends into databases? …
Escaping Cloud Computing Scam Mills: The Big Fool Paying for Pain

This article comes from a real consultation case. Any resemblance to your situation is purely due to cloud vendors’ deep affinity with your wallet. Yesterday a user came to consult, asking if PostgreSQL distributed database extension Citus has any …
This article comes from a real consultation case. Any resemblance to your situation is purely due to cloud vendors’ deep affinity with your wallet. Yesterday a user came to consult, asking if PostgreSQL distributed database extension Citus has any …
Pigsty v3.2: The pig CLI, Full ARM Support, Supabase & Grafana Enhancements

GitHub Release | Release Note Pigsty wraps up 2024 with its final release: v3.2. This release brings the pig command-line tool and complete ARM extension support. Together, they deliver silky-smooth PostgreSQL delivery across 10 major Linux …
GitHub Release | Release Note Pigsty wraps up 2024 with its final release: v3.2. This release brings the pig command-line tool and complete ARM extension support. Together, they deliver silky-smooth PostgreSQL delivery across 10 major Linux …
Pig, The Postgres Extension Wizard

Title: Meet Pig: The Postgres Extension Wizard 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 …
Title: Meet Pig: The Postgres Extension Wizard 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 …
OpenAI Global Outage Postmortem: K8S Circular Dependencies

On December 11th, OpenAI experienced a global service outage affecting ChatGPT, API, Sora, Playground, and Labs. The outage lasted from 3:16 PM to 7:38 PM PT, spanning over four hours with significant impact. According to OpenAI’s incident report …
On December 11th, OpenAI experienced a global service outage affecting ChatGPT, API, Sora, Playground, and Labs. The outage lasted from 3:16 PM to 7:38 PM PT, spanning over four hours with significant impact. According to OpenAI’s incident report …
Solving the 24-Point Card Game with a Single SQL Query

Here is the challenge: Database Programming Contest: Solve the 24-Point Card Game with One SQL Query, hosted by the database tooling platform NineData. There is a table named cards. Its auto-incrementing numeric primary key is id, and it has 4 …
Here is the challenge: Database Programming Contest: Solve the 24-Point Card Game with One SQL Query, hosted by the database tooling platform NineData. There is a table named cards. Its auto-incrementing numeric primary key is id, and it has 4 …
7 Databases in 7 Weeks (2025)

Author: Matt Blewitt, Original: 7 Databases in 7 Weeks (2025) Translator: Feng Ruohang, database veteran, cloud computing mudslide https://matt.blwt.io/post/7-databases-in-7-weeks-for-2025/ For a long time, I’ve been running Databases-as-a-Service, …
Author: Matt Blewitt, Original: 7 Databases in 7 Weeks (2025) Translator: Feng Ruohang, database veteran, cloud computing mudslide https://matt.blwt.io/post/7-databases-in-7-weeks-for-2025/ For a long time, I’ve been running Databases-as-a-Service, …
Self-Hosting Supabase on PostgreSQL

Supabase is great, but having your own Supabase is even better. Pigsty helps you build enterprise-grade Supabase on your own servers (physical/virtual machines/cloud servers) with one-click deployment —more extensions, better performance, deeper …
Supabase is great, but having your own Supabase is even better. Pigsty helps you build enterprise-grade Supabase on your own servers (physical/virtual machines/cloud servers) with one-click deployment —more extensions, better performance, deeper …
Pigsty v3.1: One-Click Supabase, PG17 Default, ARM & Ubuntu 24

GitHub Release | Release Note With PostgreSQL 17.2 released just days ago, Pigsty immediately follows up with v3.1. In this version, PostgreSQL 17 becomes the default major version, with nearly 340 extensions available out of the box. Additionally, …
GitHub Release | Release Note With PostgreSQL 17.2 released just days ago, Pigsty immediately follows up with v3.1. In this version, PostgreSQL 17 becomes the default major version, with nearly 340 extensions available out of the box. Additionally, …
Don't Upgrade! Released and Immediately Pulled - Even PostgreSQL Isn't Immune to Epic Fails

The old saying goes: never deploy code on Friday. The PostgreSQL minor releases issued two days ago deliberately avoided Friday deployment, but still gave the community a week’s worth of extra work — the PostgreSQL community will release an unusual …
The old saying goes: never deploy code on Friday. The PostgreSQL minor releases issued two days ago deliberately avoided Friday deployment, but still gave the community a week’s worth of extra work — the PostgreSQL community will release an unusual …
PostgreSQL 12 End-of-Life, PG 17 Takes the Throne

According to PostgreSQL’s versioning policy, PostgreSQL 12, released in 2019, will officially exit its support lifecycle today (2024-11-14). PG 12’s final minor version is 12.21, released on 2024-11-14, and this will be PG 12’s ultimate version. …
According to PostgreSQL’s versioning policy, PostgreSQL 12, released in 2019, will officially exit its support lifecycle today (2024-11-14). PG 12’s final minor version is 12.21, released on 2024-11-14, and this will be PG 12’s ultimate version. …
The Ideal Way to Deliver PostgreSQL Extensions

PostgreSQL Is Eating the Database World through the power of extensibility. When this post was first published, the repository packaged 390 PostgreSQL extensions as RPM / DEB packages for mainstream Linux distributions. The live Pigsty Extension …
PostgreSQL Is Eating the Database World through the power of extensibility. When this post was first published, the repository packaged 390 PostgreSQL extensions as RPM / DEB packages for mainstream Linux distributions. The live Pigsty Extension …
Open-Source "Tyrant" Linus's Purge

Recently, Linus kicked out several Russian developers from the project, triggering an outcry in the open source world. But many people forget that Linux is Linus’s personal project — it was 30 years ago, and it still is today. Linus himself has …
Recently, Linus kicked out several Russian developers from the project, triggering an outcry in the open source world. But many people forget that Linux is Linus’s personal project — it was 30 years ago, and it still is today. Linus himself has …
WordPress Community Civil War: On Community Boundary Demarcation

“I want to be blunt: for years, we’ve been like fools while they made a fortune off what we developed.” — This famous quote from Redis Labs CEO Ofer Bengal has become a vivid footnote to the WordPress community civil war and the conflict between open …
“I want to be blunt: for years, we’ve been like fools while they made a fortune off what we developed.” — This famous quote from Redis Labs CEO Ofer Bengal has become a vivid footnote to the WordPress community civil war and the conflict between open …
Cloud Database: Michelin Prices for Cafeteria Pre-made Meals

Are cloud databases overpriced cafeteria meals The paradigm shift brought by RDS Quality, security, efficiency, and cost analysis, Cloud exit database self-building: how to implement in practice! TL;DR From commercial software to open source software …
Are cloud databases overpriced cafeteria meals The paradigm shift brought by RDS Quality, security, efficiency, and cost analysis, Cloud exit database self-building: how to implement in practice! TL;DR From commercial software to open source software …
PostgreSQL 17 Released: No More Pretending!

The annual PostgreSQL major version release is here! What surprises does PostgreSQL 17 bring us this time? In this major version release announcement, the PostgreSQL global community has finally come clean — Sorry, no more pretending — “PostgreSQL is …
The annual PostgreSQL major version release is here! What surprises does PostgreSQL 17 bring us this time? In this major version release announcement, the PostgreSQL global community has finally come clean — Sorry, no more pretending — “PostgreSQL is …
Alibaba-Cloud: High Availability Disaster Recovery Myth Shattered

On September 10, 2024, Alibaba-Cloud’s Singapore Availability Zone C data center experienced a fire caused by lithium battery explosion. It’s been a week now and services have not been fully restored yet. According to the monthly SLA availability …
On September 10, 2024, Alibaba-Cloud’s Singapore Availability Zone C data center experienced a fire caused by lithium battery explosion. It’s been a week now and services have not been fully restored yet. According to the monthly SLA availability …
Optimize Bio Cores First, CPU Cores Second

Optimize Bio Cores First, Silicon Cores Second A big part of the reason that companies are going ga-ga over AI right now is the promise that it might materially lower their payroll for programmers. If a company currently needs 10 programmers to do a …
Optimize Bio Cores First, Silicon Cores Second A big part of the reason that companies are going ga-ga over AI right now is the promise that it might materially lower their payroll for programmers. If a company currently needs 10 programmers to do a …
MongoDB Has No Future: Good Marketing Can't Save a Rotten Mango

These past few days, MongoDB’s marketing stunts have been dazzling: “MongoDB Declares War on PostgreSQL”, “MongoDB Defeats PostgreSQL to Win $30 Billion Project”, and the original article from The Register “MongoDB Prepares to Pummel PostgreSQL After …
These past few days, MongoDB’s marketing stunts have been dazzling: “MongoDB Declares War on PostgreSQL”, “MongoDB Defeats PostgreSQL to Win $30 Billion Project”, and the original article from The Register “MongoDB Prepares to Pummel PostgreSQL After …