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.

MongoDB: Now Powered by PostgreSQL?
MongoDB 3.2's analytics subsystem turned out to be an embedded PostgreSQL database? A whistleblowing story from MongoDB's partner about betrayal and disillusionment.

Can PostgreSQL Replace Microsoft SQL Server?
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 …

Pigsty v3.0: Pluggable Kernels & 340 Extensions
Pigsty v3.0 ships 340 extensions across EL/Deb with full parity, adds pluggable kernels (Babelfish, IvorySQL, PolarDB) for MSSQL/Oracle compatibility, and delivers a local-first state-of-the-art RDS …

Amateur Hour Opera: Alibaba-Cloud PostgreSQL Disaster Chronicle
A customer experienced an outrageous cascade of failures on cloud database last week: a high-availability PG RDS cluster went down completely - both primary and replica servers - after attempting a …

What Can We Learn from NetEase Cloud Music's Outage?
NetEase Cloud Music experienced a two-and-a-half-hour outage this afternoon. Based on circulating online clues, we can deduce that the real cause behind this incident was...

Whoever Integrates DuckDB Best Wins the OLAP World
Just like the vector database extension race two years ago, the current PostgreSQL ecosystem extension competition has begun revolving around DuckDB. MotherDuck's official entry into the PostgreSQL …

StackOverflow 2024 Survey: PostgreSQL Has Gone Completely Berserk
The 2024 StackOverflow Global Developer Survey results are fresh out, and PostgreSQL has become the most popular, most loved, and most wanted database globally for the second consecutive year. Nothing …

Blue Screen Friday: Amateur Hour on Both Sides
Both client and vendor failed to control blast radius, leading to this epic global security incident that will greatly benefit local-first software philosophy.

CVE-2024-6387 SSH Vulnerability Fix
This vulnerability affects EL9, Ubuntu 22.04, Debian 12. Users should promptly update OpenSSH to fix this vulnerability.

Self-Hosting Dify with PG, PGVector, and Pigsty
Dify is an open-source LLM app development platform. This article explains how to self-host Dify using Pigsty.

PGCon.Dev 2024, The conf that shutdown PG for a week
Experience & Feeling on the PGCon.Dev 2024

PostgreSQL 17 Beta1 Released!
The PostgreSQL Global Development Group announces PostgreSQL 17's first Beta version is now available. This time, PostgreSQL has truly burst the toothpaste tube!

How Ahrefs Saved US$400M by NOT Going to the Cloud
After Alibaba-Cloud's epic global outage on Double 11, setting industry records, how should we evaluate this incident and what lessons can we learn from it?

Pigsty v2.7: The Extension Superpack
Pigsty v2.7 bundles 255 PostgreSQL extensions, plus Docker templates for Odoo, Supabase, PolarDB, and Jupyter, with new PITR dashboards.

Database Deletion Supreme - Google Cloud Nuked a Major Fund's Entire Cloud Account
Due to an "unprecedented configuration error," Google Cloud mistakenly deleted trillion-RMB fund giant UniSuper's entire cloud account, cloud environment and all off-site backups, setting a new record …

Cloud Dark Forest: Exploding Cloud Bills with Just S3 Bucket Names
The dark forest law has emerged on public cloud: Anyone who knows your S3 object storage bucket name can explode your cloud bill.

The $20 Brother PolarDB: What Should Databases Actually Cost?
Today we discuss the fair pricing of commercial databases, open-source databases, cloud databases, and domestic Chinese databases.

Can Chinese Domestic Databases Really Compete?
Friends often ask me, can Chinese domestic databases really compete? To be honest, it's a question that offends people. So let's try speaking with data - I hope the charts provided in this article can …

Cloudflare Roundtable Interview and Q&A Record
As a roundtable guest, I was invited to participate in Cloudflare's Immerse conference in Shenzhen. During the dinner, I had in-depth discussions with Cloudflare's APAC CMO, Greater China Technical …

What Can We Learn from Tencent Cloud's Major Outage?
Tencent Cloud's epic global outage after Double 11 set industry records. How should we evaluate and view this failure, and what lessons can we learn from it?

Cloudflare - The Cyber Buddha That Destroys Public Cloud
While I've always advocated for cloud exit, if it's about adopting a cyber bodhisattva cloud like Cloudflare, I'm all in with both hands raised.

Can Luo Yonghao Save Toothpaste Cloud?
Luo Yonghao's livestream first spent half an hour selling robot vacuums, then Luo himself belatedly appeared to read scripts selling "cloud computing" for forty minutes — before seamlessly …

Redis Going Non-Open-Source is a Disgrace to "Open-Source" and Public Cloud
Redis "going non-open source" is not a disgrace to Redis, but a disgrace to "open source/OSI" and even more so to public cloud. What truly matters has always been software freedom, while open source …

Analyzing Alibaba-Cloud Server Computing Cost
Alibaba-Cloud claimed major price cuts, but a detailed analysis of cloud server costs reveals that cloud computing and storage remain outrageously expensive.

MongoDB: Now Powered by PostgreSQL?
MongoDB 3.2's analytics subsystem turned out to be an embedded PostgreSQL database? A whistleblowing story from MongoDB's partner about betrayal and disillusionment.

Can PostgreSQL Replace Microsoft SQL Server?
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 …

Pigsty v3.0: Pluggable Kernels & 340 Extensions
Pigsty v3.0 ships 340 extensions across EL/Deb with full parity, adds pluggable kernels (Babelfish, IvorySQL, PolarDB) for MSSQL/Oracle compatibility, and delivers a local-first state-of-the-art RDS …

Amateur Hour Opera: Alibaba-Cloud PostgreSQL Disaster Chronicle
A customer experienced an outrageous cascade of failures on cloud database last week: a high-availability PG RDS cluster went down completely - both primary and replica servers - after attempting a …

What Can We Learn from NetEase Cloud Music's Outage?
NetEase Cloud Music experienced a two-and-a-half-hour outage this afternoon. Based on circulating online clues, we can deduce that the real cause behind this incident was...

Whoever Integrates DuckDB Best Wins the OLAP World
Just like the vector database extension race two years ago, the current PostgreSQL ecosystem extension competition has begun revolving around DuckDB. MotherDuck's official entry into the PostgreSQL …

StackOverflow 2024 Survey: PostgreSQL Has Gone Completely Berserk
The 2024 StackOverflow Global Developer Survey results are fresh out, and PostgreSQL has become the most popular, most loved, and most wanted database globally for the second consecutive year. Nothing …

Blue Screen Friday: Amateur Hour on Both Sides
Both client and vendor failed to control blast radius, leading to this epic global security incident that will greatly benefit local-first software philosophy.

CVE-2024-6387 SSH Vulnerability Fix
This vulnerability affects EL9, Ubuntu 22.04, Debian 12. Users should promptly update OpenSSH to fix this vulnerability.

Self-Hosting Dify with PG, PGVector, and Pigsty
Dify is an open-source LLM app development platform. This article explains how to self-host Dify using Pigsty.

PGCon.Dev 2024, The conf that shutdown PG for a week
Experience & Feeling on the PGCon.Dev 2024

PostgreSQL 17 Beta1 Released!
The PostgreSQL Global Development Group announces PostgreSQL 17's first Beta version is now available. This time, PostgreSQL has truly burst the toothpaste tube!

How Ahrefs Saved US$400M by NOT Going to the Cloud
After Alibaba-Cloud's epic global outage on Double 11, setting industry records, how should we evaluate this incident and what lessons can we learn from it?

Pigsty v2.7: The Extension Superpack
Pigsty v2.7 bundles 255 PostgreSQL extensions, plus Docker templates for Odoo, Supabase, PolarDB, and Jupyter, with new PITR dashboards.

Database Deletion Supreme - Google Cloud Nuked a Major Fund's Entire Cloud Account
Due to an "unprecedented configuration error," Google Cloud mistakenly deleted trillion-RMB fund giant UniSuper's entire cloud account, cloud environment and all off-site backups, setting a new record …

Cloud Dark Forest: Exploding Cloud Bills with Just S3 Bucket Names
The dark forest law has emerged on public cloud: Anyone who knows your S3 object storage bucket name can explode your cloud bill.

The $20 Brother PolarDB: What Should Databases Actually Cost?
Today we discuss the fair pricing of commercial databases, open-source databases, cloud databases, and domestic Chinese databases.

Can Chinese Domestic Databases Really Compete?
Friends often ask me, can Chinese domestic databases really compete? To be honest, it's a question that offends people. So let's try speaking with data - I hope the charts provided in this article can …

Cloudflare Roundtable Interview and Q&A Record
As a roundtable guest, I was invited to participate in Cloudflare's Immerse conference in Shenzhen. During the dinner, I had in-depth discussions with Cloudflare's APAC CMO, Greater China Technical …

What Can We Learn from Tencent Cloud's Major Outage?
Tencent Cloud's epic global outage after Double 11 set industry records. How should we evaluate and view this failure, and what lessons can we learn from it?

Cloudflare - The Cyber Buddha That Destroys Public Cloud
While I've always advocated for cloud exit, if it's about adopting a cyber bodhisattva cloud like Cloudflare, I'm all in with both hands raised.

Can Luo Yonghao Save Toothpaste Cloud?
Luo Yonghao's livestream first spent half an hour selling robot vacuums, then Luo himself belatedly appeared to read scripts selling "cloud computing" for forty minutes — before seamlessly …

Redis Going Non-Open-Source is a Disgrace to "Open-Source" and Public Cloud
Redis "going non-open source" is not a disgrace to Redis, but a disgrace to "open source/OSI" and even more so to public cloud. What truly matters has always been software freedom, while open source …

Analyzing Alibaba-Cloud Server Computing Cost
Alibaba-Cloud claimed major price cuts, but a detailed analysis of cloud server costs reveals that cloud computing and storage remain outrageously expensive.
MongoDB: Now Powered by PostgreSQL?

Preface Tomorrow I’ll publish an article criticizing MongoDB, as a response to their recent malicious marketing that provocatively targets PostgreSQL. But before that, I want to share a brilliant article from 2015 that exposes some of MongoDB’s dark …
Preface Tomorrow I’ll publish an article criticizing MongoDB, as a response to their recent malicious marketing that provocatively targets PostgreSQL. But before that, I want to share a brilliant article from 2015 that exposes some of MongoDB’s dark …
Can PostgreSQL Replace Microsoft SQL Server?

Many people don’t have an intuitive impression of how far PostgreSQL’s ecosystem has developed. Beyond devouring the database world and its all-encompassing extension ecosystem, PostgreSQL can directly replace Oracle, SQL Server, and MongoDB at the …
Many people don’t have an intuitive impression of how far PostgreSQL’s ecosystem has developed. Beyond devouring the database world and its all-encompassing extension ecosystem, PostgreSQL can directly replace Oracle, SQL Server, and MongoDB at the …
Pigsty v3.0: Pluggable Kernels & 340 Extensions

GitHub Release | Release Note Highlights Extension Explosion: Pigsty v3 ships an unprecedented 340 available PostgreSQL extensions. This includes 121 extension RPM packages and 133 DEB packages — more than the total extension count in the official …
GitHub Release | Release Note Highlights Extension Explosion: Pigsty v3 ships an unprecedented 340 available PostgreSQL extensions. This includes 121 extension RPM packages and 133 DEB packages — more than the total extension count in the official …
Amateur Hour Opera: Alibaba-Cloud PostgreSQL Disaster Chronicle

In “Are Cloud Databases an IQ Tax”, I evaluated cloud database RDS as: “selling sky-high pre-made meals at five-star hotel prices” — but legitimate pre-made meals from industrial kitchens are at least edible and generally won’t kill you. However, a …
In “Are Cloud Databases an IQ Tax”, I evaluated cloud database RDS as: “selling sky-high pre-made meals at five-star hotel prices” — but legitimate pre-made meals from industrial kitchens are at least edible and generally won’t kill you. However, a …
What Can We Learn from NetEase Cloud Music's Outage?

This afternoon around 14:44, NetEase Cloud Music experienced an outage, recovering at 17:11. The rumored cause was infrastructure/cloud/ disk storage related issues. Incident Timeline During the outage, NetEase Cloud Music clients could normally play …
This afternoon around 14:44, NetEase Cloud Music experienced an outage, recovering at 17:11. The rumored cause was infrastructure/cloud/ disk storage related issues. Incident Timeline During the outage, NetEase Cloud Music clients could normally play …
Whoever Integrates DuckDB Best Wins the OLAP World

In my article “[PostgreSQL is Eating the Database World],” I posed this question: Who will ultimately unify the database world? I believe it’s the PostgreSQL ecosystem with various extensions — and my judgment is that to conquer OLAP, the largest and …
In my article “[PostgreSQL is Eating the Database World],” I posed this question: Who will ultimately unify the database world? I believe it’s the PostgreSQL ecosystem with various extensions — and my judgment is that to conquer OLAP, the largest and …
StackOverflow 2024 Survey: PostgreSQL Has Gone Completely Berserk

The 2024 StackOverflow Global Developer Survey results are fresh out, with high-quality questionnaire feedback from 60,000 developers across 185 countries and regions. Of course, as a database veteran, I’m most interested in the “Database” section of …
The 2024 StackOverflow Global Developer Survey results are fresh out, with high-quality questionnaire feedback from 60,000 developers across 185 countries and regions. Of course, as a database veteran, I’m most interested in the “Database” section of …
Blue Screen Friday: Amateur Hour on Both Sides

Recently, due to a configuration update released by cybersecurity company CrowdStrike, countless Windows computers worldwide fell into blue screen death, causing endless chaos — airlines grounded flights, hospitals canceled surgeries, supermarkets, …
Recently, due to a configuration update released by cybersecurity company CrowdStrike, countless Windows computers worldwide fell into blue screen death, causing endless chaos — airlines grounded flights, hospitals canceled surgeries, supermarkets, …
CVE-2024-6387 SSH Vulnerability Fix

Vulnerability description, CVE-2024-6387: https://nvd.nist.gov/vuln/detail/CVE-2024-6387 This basically affects newer versions of operating systems. Older systems like CentOS 7.9, RockyLinux 8.9, Ubuntu 20.04, Debian 11 escaped this due to older …
Vulnerability description, CVE-2024-6387: https://nvd.nist.gov/vuln/detail/CVE-2024-6387 This basically affects newer versions of operating systems. Older systems like CentOS 7.9, RockyLinux 8.9, Ubuntu 20.04, Debian 11 escaped this due to older …
Self-Hosting Dify with PG, PGVector, and Pigsty

Dify – The Innovation Engine for GenAI Applications Dify is an open-source LLM app development platform. Orchestrate LLM apps from agents to complex AI workflows, with an RAG engine. Which claims to be more production-ready than LangChain. Of course, …
Dify – The Innovation Engine for GenAI Applications Dify is an open-source LLM app development platform. Orchestrate LLM apps from agents to complex AI workflows, with an RAG engine. Which claims to be more production-ready than LangChain. Of course, …
PGCon.Dev 2024, The conf that shutdown PG for a week

PGCon.Dev, once known as PGCon—the annual must-attend gathering for PostgreSQL hackers and key forum for its future direction, has been held in Ottawa since its inception in 2007. This year marks a new chapter as the original organizer, Dan, hands …
PGCon.Dev, once known as PGCon—the annual must-attend gathering for PostgreSQL hackers and key forum for its future direction, has been held in Ottawa since its inception in 2007. This year marks a new chapter as the original organizer, Dan, hands …
PostgreSQL 17 Beta1 Released!

The PostgreSQL Global Development Group announces that PostgreSQL 17’s first Beta version is now available for download. This version includes a preview of all features that will be available when PostgreSQL 17 is officially released, though some …
The PostgreSQL Global Development Group announces that PostgreSQL 17’s first Beta version is now available for download. This version includes a preview of all features that will be available when PostgreSQL 17 is officially released, though some …
How Ahrefs Saved US$400M by NOT Going to the Cloud

Original: How Ahrefs Saved US$400M in 3 Years by NOT Going to the Cloud Cloud computing has been very popular in the IT infrastructure space recently, with going to the cloud becoming a trend. Infrastructure as a Service (IaaS) clouds do have many …
Original: How Ahrefs Saved US$400M in 3 Years by NOT Going to the Cloud Cloud computing has been very popular in the IT infrastructure space recently, with going to the cloud becoming a trend. Infrastructure as a Service (IaaS) clouds do have many …
Pigsty v2.7: The Extension Superpack

GitHub Release | Release Note On 2024-05-20, Pigsty v2.7 is released. The number of available extensions in this version reaches an astonishing 255, successfully elevating PostgreSQL’s versatility to a new height! Additionally, we provide some new …
GitHub Release | Release Note On 2024-05-20, Pigsty v2.7 is released. The number of available extensions in this version reaches an astonishing 255, successfully elevating PostgreSQL’s versatility to a new height! Additionally, we provide some new …
Database Deletion Supreme - Google Cloud Nuked a Major Fund's Entire Cloud Account

Due to an “unprecedented configuration error”, Google Cloud mistakenly deleted UniSuper’s cloud account. The Australian pension fund executive and Google Cloud’s global CEO issued a joint statement apologizing for this “extremely frustrating and …
Due to an “unprecedented configuration error”, Google Cloud mistakenly deleted UniSuper’s cloud account. The Australian pension fund executive and Google Cloud’s global CEO issued a joint statement apologizing for this “extremely frustrating and …
Cloud Dark Forest: Exploding Cloud Bills with Just S3 Bucket Names

The dark forest law has emerged on public cloud: Anyone who knows your S3 object storage bucket name can explode your cloud bill. Imagine this: you create an empty, private AWS S3 storage bucket in your favorite region. What would your AWS bill look …
The dark forest law has emerged on public cloud: Anyone who knows your S3 object storage bucket name can explode your cloud bill. Imagine this: you create an empty, private AWS S3 storage bucket in your favorite region. What would your AWS bill look …
The $20 Brother PolarDB: What Should Databases Actually Cost?

WeChat Public Account Yesterday, a bidding news attracted attention and heated discussion: “The IT industry is broken… 16.1 million dollar contract… 2.9 million (won)… maintenance fee 0.01 yuan… PolarDB unit price 130 yuan”. When I first saw this …
WeChat Public Account Yesterday, a bidding news attracted attention and heated discussion: “The IT industry is broken… 16.1 million dollar contract… 2.9 million (won)… maintenance fee 0.01 yuan… PolarDB unit price 130 yuan”. When I first saw this …
Can Chinese Domestic Databases Really Compete?

WeChat Public Account Friends often ask me, can Chinese domestic databases really compete? To be honest, it’s a question that offends people. So let’s try speaking with data - I hope the charts provided in this article can help readers understand …
WeChat Public Account Friends often ask me, can Chinese domestic databases really compete? To be honest, it’s a question that offends people. So let’s try speaking with data - I hope the charts provided in this article can help readers understand …
Cloudflare Roundtable Interview and Q&A Record

Last week, I was invited as a roundtable guest to participate in Cloudflare’s Immerse conference in Shenzhen. During the Cloudflare Immerse cocktail party and dinner, I had in-depth discussions with Cloudflare’s APAC CMO, Greater China Technical …
Last week, I was invited as a roundtable guest to participate in Cloudflare’s Immerse conference in Shenzhen. During the Cloudflare Immerse cocktail party and dinner, I had in-depth discussions with Cloudflare’s APAC CMO, Greater China Technical …
What Can We Learn from Tencent Cloud's Major Outage?

Eight days after the outage, Tencent Cloud published a postmortem report for the April 8th major outage. I think this is a good thing, because Alibaba-Cloud’s Double 11 major outage official postmortem is still overdue. If public cloud vendors want …
Eight days after the outage, Tencent Cloud published a postmortem report for the April 8th major outage. I think this is a good thing, because Alibaba-Cloud’s Double 11 major outage official postmortem is still overdue. If public cloud vendors want …
Cloudflare - The Cyber Buddha That Destroys Public Cloud

At today’s 2024 Developer Week, Cloudflare released a series of exciting new features, such as Python Workers and Workers AI, elevating the convenience of application development and delivery to an entirely new level. Compared to Cloudflare’s …
At today’s 2024 Developer Week, Cloudflare released a series of exciting new features, such as Python Workers and Workers AI, elevating the convenience of application development and delivery to an entirely new level. Compared to Cloudflare’s …
Can Luo Yonghao Save Toothpaste Cloud?

Luo Yonghao was once a brilliant digital product manager with decent IT industry credentials. But as they say, there’s a world of difference between industries. Luo selling cloud is like a street vendor simultaneously hawking meat, vegetables, eggs, …
Luo Yonghao was once a brilliant digital product manager with decent IT industry credentials. But as they say, there’s a world of difference between industries. Luo selling cloud is like a street vendor simultaneously hawking meat, vegetables, eggs, …
Redis Going Non-Open-Source is a Disgrace to "Open-Source" and Public Cloud

Recently, Redis changed its license, causing controversy: starting from version 7.4, it uses RSALv2 and SSPLv1, no longer meeting OSI’s definition of “open source software.” But don’t get it wrong: Redis “going non-open source” is not a disgrace to …
Recently, Redis changed its license, causing controversy: starting from version 7.4, it uses RSALv2 and SSPLv1, no longer meeting OSI’s definition of “open source software.” But don’t get it wrong: Redis “going non-open source” is not a disgrace to …
Analyzing Alibaba-Cloud Server Computing Cost

On Crazy Thursday, February 29, 2024, Alibaba-Cloud staged a major price cut, with promotional content flying everywhere. As the cloud computing mudslide, many followers asked me to comment. The flashy 20%, 50% off banners look impressive, but …
On Crazy Thursday, February 29, 2024, Alibaba-Cloud staged a major price cut, with promotional content flying everywhere. As the cloud computing mudslide, many followers asked me to comment. The flashy 20%, 50% off banners look impressive, but …