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.

DDIA 2nd Edition, Chinese Translation
The second edition of Designing Data-Intensive Applications has released ten chapters. I translated them into Chinese and rebuilt a clean Hugo/Hextra web version for the community.

Column: Postgres Mage
Navigation of articles about PostgreSQL development, administration, principles, ecosystem, tools, architecture design, performance optimization, troubleshooting, and more.

Column: Database Guru
The database world is full of hype and marketing fog. This column cuts through it with blunt commentary, case studies, and technical deep dives.

Column: Cloud-Exit
A whole generation of developers has been told “cloud-first.” This column collects data, case studies, and commentary on the real economics—and traps—of public cloud rental models.

PostgreSQL Dominates Database World, but Who Will Devour PG?
The same forces that once led MongoDB and MySQL toward closure are now at work in the PostgreSQL ecosystem. The PG world needs a distribution that represents "software freedom" values.

KubeSphere: Trust Crisis Behind Open-Source Supply Cut
Deleting images and running away - this isn't about commercial closed-source issues, but supply cut problems that directly destroy years of accumulated community trust.

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 …

Dongchedi Just Exposed “Smart Driving.” Where’s Our Dongku-Di?
Imagine a “closed-course” shootout for domestic databases and clouds, the way Dongchedi just humiliated 30+ autonomous cars. This industry needs its own stress test.

Pigsty v3.6: The Ultimate PostgreSQL Distribution
New doc site, PITR playbook, Percona PG TDE kernel support, and Supabase self-hosting optimization make v3.6 the last major release before 4.0.

Google AI Toolbox: Production-Ready Database MCP is Here?
Google recently launched a database MCP toolbox, perhaps the first production-ready solution.

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.

Where Will Databases and DBAs Go in the AI Era?
Who will be revolutionized first - OLTP or OLAP? Integration vs specialization, how to choose? Where will DBAs go in the AI era? Feng's views from the HOW 2025 conference roundtable, organized and …

Pigsty v3.5: 4K Stars, PG18 Beta, 421 Extensions
Pigsty crosses 4K GitHub stars, adds PG18 beta support, pushes extensions to 421, ships new doc site, and completes OrioleDB/OpenHalo full-platform support.

Stop Arguing, The AI Era Database Has Been Settled
The database for the AI era has been settled. Capital markets are making intensive moves on PostgreSQL targets, with PG having become the default database for the AI era.

Scaling Postgres to the next level at OpenAI
At PGConf.Dev 2025, Bohan Zhang from OpenAI shared a session titled Scaling Postgres to the next level at OpenAI, giving us a peek into the database usage of a top-tier unicorn.

How Many Shops Has etcd Torched?
Plenty. If you’re rolling your own Kubernetes, odds are you’ll crash because etcd ships with a 2 GB time bomb.

In the AI Era, Software Starts at the Database
Future software = Agent + Database. No middle tiers, just agents issuing CRUD. Database skills age well, and PostgreSQL is poised to be the agent-era default.

MySQL vs. PostgreSQL @ 2025
A 2025 reality check on where PostgreSQL stands relative to MySQL across features, performance, quality, and ecosystem.

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

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 …

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 …

Dify Gets Humiliated Again: It Can't Catch a Break
Livzon Pharmaceutical's logo-swapping PR landed out of nowhere. As if being ripped off by DeepSeek appliance vendors were not enough, someone marched into Dify's own repository to rub it in. Dify just …

PGFS: Using Database as a Filesystem
Leverage JuiceFS to turn PostgreSQL into a filesystem with PITR capabilities!

Pigsty v3.4: PITR Enhancement, Locale Best Practices, Auto Certificates
Pigsty v3.4 adds pgBackRest backup monitoring, cross-cluster PITR restore, automated HTTPS certificates, locale best practices, and full-platform IvorySQL and Apache AGE support.

DDIA 2nd Edition, Chinese Translation
The second edition of Designing Data-Intensive Applications has released ten chapters. I translated them into Chinese and rebuilt a clean Hugo/Hextra web version for the community.

Column: Postgres Mage
Navigation of articles about PostgreSQL development, administration, principles, ecosystem, tools, architecture design, performance optimization, troubleshooting, and more.

Column: Database Guru
The database world is full of hype and marketing fog. This column cuts through it with blunt commentary, case studies, and technical deep dives.

Column: Cloud-Exit
A whole generation of developers has been told “cloud-first.” This column collects data, case studies, and commentary on the real economics—and traps—of public cloud rental models.

PostgreSQL Dominates Database World, but Who Will Devour PG?
The same forces that once led MongoDB and MySQL toward closure are now at work in the PostgreSQL ecosystem. The PG world needs a distribution that represents "software freedom" values.

KubeSphere: Trust Crisis Behind Open-Source Supply Cut
Deleting images and running away - this isn't about commercial closed-source issues, but supply cut problems that directly destroy years of accumulated community trust.

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 …

Dongchedi Just Exposed “Smart Driving.” Where’s Our Dongku-Di?
Imagine a “closed-course” shootout for domestic databases and clouds, the way Dongchedi just humiliated 30+ autonomous cars. This industry needs its own stress test.

Pigsty v3.6: The Ultimate PostgreSQL Distribution
New doc site, PITR playbook, Percona PG TDE kernel support, and Supabase self-hosting optimization make v3.6 the last major release before 4.0.

Google AI Toolbox: Production-Ready Database MCP is Here?
Google recently launched a database MCP toolbox, perhaps the first production-ready solution.

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.

Where Will Databases and DBAs Go in the AI Era?
Who will be revolutionized first - OLTP or OLAP? Integration vs specialization, how to choose? Where will DBAs go in the AI era? Feng's views from the HOW 2025 conference roundtable, organized and …

Pigsty v3.5: 4K Stars, PG18 Beta, 421 Extensions
Pigsty crosses 4K GitHub stars, adds PG18 beta support, pushes extensions to 421, ships new doc site, and completes OrioleDB/OpenHalo full-platform support.

Stop Arguing, The AI Era Database Has Been Settled
The database for the AI era has been settled. Capital markets are making intensive moves on PostgreSQL targets, with PG having become the default database for the AI era.

Scaling Postgres to the next level at OpenAI
At PGConf.Dev 2025, Bohan Zhang from OpenAI shared a session titled Scaling Postgres to the next level at OpenAI, giving us a peek into the database usage of a top-tier unicorn.

How Many Shops Has etcd Torched?
Plenty. If you’re rolling your own Kubernetes, odds are you’ll crash because etcd ships with a 2 GB time bomb.

In the AI Era, Software Starts at the Database
Future software = Agent + Database. No middle tiers, just agents issuing CRUD. Database skills age well, and PostgreSQL is poised to be the agent-era default.

MySQL vs. PostgreSQL @ 2025
A 2025 reality check on where PostgreSQL stands relative to MySQL across features, performance, quality, and ecosystem.

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

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 …

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 …

Dify Gets Humiliated Again: It Can't Catch a Break
Livzon Pharmaceutical's logo-swapping PR landed out of nowhere. As if being ripped off by DeepSeek appliance vendors were not enough, someone marched into Dify's own repository to rub it in. Dify just …

PGFS: Using Database as a Filesystem
Leverage JuiceFS to turn PostgreSQL into a filesystem with PITR capabilities!

Pigsty v3.4: PITR Enhancement, Locale Best Practices, Auto Certificates
Pigsty v3.4 adds pgBackRest backup monitoring, cross-cluster PITR restore, automated HTTPS certificates, locale best practices, and full-platform IvorySQL and Apache AGE support.
DDIA 2nd Edition, Chinese Translation

The new DDIA—Designing Data-Intensive Applications, 2nd Edition—has published its first ten chapters. With Claude Code Max 20× on my side, it took two days to translate the released chapters into Chinese and re-render them via Hugo + Hextra for a …
The new DDIA—Designing Data-Intensive Applications, 2nd Edition—has published its first ten chapters. With Claude Code Max 20× on my side, it took two days to translate the released chapters into Chinese and re-render them via Hugo + Hextra for a …
Column: Postgres Mage

Ecosystem PGEXT.DAY 2025, See You There OrioleDB Is Coming! OpenHalo: MySQL-Compatible PG PGFS: Database as Filesystem PostgreSQL Ecosystem Frontier Progress Pig on Elephant: PG Package Manager Pig Release Day Halt: PG Also Can’t Escape Major …
Ecosystem PGEXT.DAY 2025, See You There OrioleDB Is Coming! OpenHalo: MySQL-Compatible PG PGFS: Database as Filesystem PostgreSQL Ecosystem Frontier Progress Pig on Elephant: PG Package Manager Pig Release Day Halt: PG Also Can’t Escape Major …
Column: Database Guru

WeChat Sovereignty & Self-Reliance Build a China-rooted, world-facing PG distribution Supply-chain trust: I won’t bet on absentee maintainers PG “export controls” and supply-chain trust Any domestic DBs that actually deliver? Stop embarrassing us …
WeChat Sovereignty & Self-Reliance Build a China-rooted, world-facing PG distribution Supply-chain trust: I won’t bet on absentee maintainers PG “export controls” and supply-chain trust Any domestic DBs that actually deliver? Stop embarrassing us …
Column: Cloud-Exit

People praise the cloud as carefree, with managed services easing every pain. I say clouds are pig-butchering schemes, hundredfold markups with smug disdain. Cyber landlords hold monopolies, hike the price, extract your vein. They outsource ops, …
People praise the cloud as carefree, with managed services easing every pain. I say clouds are pig-butchering schemes, hundredfold markups with smug disdain. Cyber landlords hold monopolies, hike the price, extract your vein. They outsource ops, …
PostgreSQL Dominates Database World, but Who Will Devour PG?

Percona is a banner-bearer and major third-party vendor in the MySQL ecosystem, and has been advancing into the PostgreSQL space in recent years. The English original of this article was published on the Percona blog this morning. Of course, Percona …
Percona is a banner-bearer and major third-party vendor in the MySQL ecosystem, and has been advancing into the PostgreSQL space in recent years. The English original of this article was published on the Percona blog this morning. Of course, Percona …
KubeSphere: Trust Crisis Behind Open-Source Supply Cut

KubeSphere Sudden Supply Cut: When Open-Source Trust Gets “Unplugged” A “Run” That Shocked the Cloud Native Circle The day before yesterday, QingCloud announced KubeSphere open source edition stops downloads and support, requiring users to migrate …
KubeSphere Sudden Supply Cut: When Open-Source Trust Gets “Unplugged” A “Run” That Shocked the Cloud Native Circle The day before yesterday, QingCloud announced KubeSphere open source edition stops downloads and support, requiring users to migrate …
PostgreSQL Has Dominated the Database World

The 2025 StackOverflow Global Developer Survey results are fresh out, with high-quality questionnaire feedback from 50,000 developers across 177 countries and regions. As a database veteran, I’m most interested in the “Database” section of this …
The 2025 StackOverflow Global Developer Survey results are fresh out, with high-quality questionnaire feedback from 50,000 developers across 177 countries and regions. As a database veteran, I’m most interested in the “Database” section of this …
Dongchedi Just Exposed “Smart Driving.” Where’s Our Dongku-Di?

I rented a car today, drove from Shanghai back to Ningbo. Yesterday I watched Dongchedi’s autonomous-driving showdown—closed highway + real city roads + 30+ “smart driving” models. Everyone faceplanted except Tesla. The episode aired and every Tesla …
I rented a car today, drove from Shanghai back to Ningbo. Yesterday I watched Dongchedi’s autonomous-driving showdown—closed highway + real city roads + 30+ “smart driving” models. Everyone faceplanted except Tesla. The episode aired and every Tesla …
Pigsty v3.6: The Ultimate PostgreSQL Distribution

GitHub Release | Release Note Pigsty v3.6 is officially released. After two months of careful refinement, this will be the last major version before v4.0, featuring extensive refactoring and improvements that lay a solid foundation for building the …
GitHub Release | Release Note Pigsty v3.6 is officially released. After two months of careful refinement, this will be the last major version before v4.0, featuring extensive refactoring and improvements that lay a solid foundation for building the …
Google AI Toolbox: Production-Ready Database MCP is Here?

In “SaaS is Dead? In the AI Era, Software Starts with Databases”, Microsoft CEO Nadella once stated that in the Agent era, SaaS is Dead, and the future form of software will be Agent + Database. That is, Agents directly performing CRUD operations on …
In “SaaS is Dead? In the AI Era, Software Starts with Databases”, Microsoft CEO Nadella once stated that in the Agent era, SaaS is Dead, and the future form of software will be Agent + Database. That is, Agents directly performing CRUD operations on …
PGDG Cuts Off Mirror Sync Channel

Recently, while building Pigsty offline packages, I discovered that the PostgreSQL version installed during local testing wasn’t quite right - 17.4 was behind the latest 17.5 by one minor version. Also, when testing on EL10, I found several …
Recently, while building Pigsty offline packages, I discovered that the PostgreSQL version installed during local testing wasn’t quite right - 17.4 was behind the latest 17.5 by one minor version. Also, when testing on EL10, I found several …
Where Will Databases and DBAs Go in the AI Era?

The day before yesterday at the HOW 2025 conference roundtable, Chairman Xiao asked some interesting questions about AI, databases, and DBAs. Here are Feng’s views, organized and published. OLTP / OLAP: Who Gets Revolutionized First? Question: In …
The day before yesterday at the HOW 2025 conference roundtable, Chairman Xiao asked some interesting questions about AI, databases, and DBAs. Here are Feng’s views, organized and published. OLTP / OLAP: Who Gets Revolutionized First? Question: In …
Pigsty v3.5: 4K Stars, PG18 Beta, 421 Extensions

GitHub Release | Release Note Pigsty v3.5 is officially released. The project has crossed the 4,000+ Star milestone on GitHub — a remarkable achievement for a database infrastructure project. This version brings a brand-new documentation website, …
GitHub Release | Release Note Pigsty v3.5 is officially released. The project has crossed the 4,000+ Star milestone on GitHub — a remarkable achievement for a database infrastructure project. This version brings a brand-new documentation website, …
Stop Arguing, The AI Era Database Has Been Settled

This morning, the industry exploded with news of an acquisition. Following Databricks’ $1 billion acquisition of Neon, its rival Snowflake immediately followed by acquiring CrunchyData. According to insiders, this deal was priced at $250 million. …
This morning, the industry exploded with news of an acquisition. Following Databricks’ $1 billion acquisition of Neon, its rival Snowflake immediately followed by acquiring CrunchyData. According to insiders, this deal was priced at $250 million. …
Scaling Postgres to the next level at OpenAI

At PGConf.Dev 2025, Bohan Zhang from OpenAI shared a session titled Scaling Postgres to the next level at OpenAI, giving us a peek into the database usage of a top-tier unicorn. “At OpenAl, we’ve proven that PostgreSQL can scale to support massive …
At PGConf.Dev 2025, Bohan Zhang from OpenAI shared a session titled Scaling Postgres to the next level at OpenAI, giving us a peek into the database usage of a top-tier unicorn. “At OpenAl, we’ve proven that PostgreSQL can scale to support massive …
How Many Shops Has etcd Torched?

A few days ago Yingshi Hurricane shared their Pigsty/PostgreSQL HA incident. The root cause? etcd hit its default 2 GB limit because auto-compaction wasn’t enabled. As @ayanamist put it on X: “Let’s see how many companies this stupid 2 GB design can …
A few days ago Yingshi Hurricane shared their Pigsty/PostgreSQL HA incident. The root cause? etcd hit its default 2 GB limit because auto-compaction wasn’t enabled. As @ayanamist put it on X: “Let’s see how many companies this stupid 2 GB design can …
In the AI Era, Software Starts at the Database

WeChat The future stack is “Agent + Database.” No front-end/back-end toll booths—agents talk CRUD straight to storage. Database skills hold their value, and PostgreSQL is the database of the agent era. SaaS is dead? Software begins with the DB GenAI …
WeChat The future stack is “Agent + Database.” No front-end/back-end toll booths—agents talk CRUD straight to storage. Database skills hold their value, and PostgreSQL is the database of the agent era. SaaS is dead? Software begins with the DB GenAI …
MySQL vs. PostgreSQL @ 2025

In 2025, PostgreSQL has opened a clear lead over MySQL on features, correctness, performance, and ecosystem—and the gap keeps widening. Here’s the panoramic view. Features Release cadence MySQL just dropped “Innovation” 9.3 (release notes), yet the …
In 2025, PostgreSQL has opened a clear lead over MySQL on features, correctness, performance, and ecosystem—and the gap keeps widening. Here’s the panoramic view. Features Release cadence MySQL just dropped “Innovation” 9.3 (release notes), yet the …
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, focusing on all aspects of PG extension development, delivery, and release. …
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, focusing on all aspects of PG extension development, delivery, and release. …
OrioleDB is Coming! 4x Performance, Eliminates Pain Points, Storage-Compute Separation

OrioleDB, which sounds interesting - though “Oriole” means a type of bird (黄鹂 in Chinese), so it should actually be translated as “Oriole Database” rather than “Cookie Database” or “Bird Database”. The name doesn’t matter much; what’s important is …
OrioleDB, which sounds interesting - though “Oriole” means a type of bird (黄鹂 in Chinese), so it should actually be translated as “Oriole Database” rather than “Cookie Database” or “Bird Database”. The name doesn’t matter much; what’s important is …
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 — allowing users to simultaneously access and manage the same database using both MySQL and …
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 — allowing users to simultaneously access and manage the same database using both MySQL and …
Dify Gets Humiliated Again: It Can't Catch a Break

Today, something straight out of magical realism unfolded in Dify’s GitHub repository. The open-source community was minding its own business, maintaining the project, when a pull request apparently from Livzon Pharmaceutical landed out of …
Today, something straight out of magical realism unfolded in Dify’s GitHub repository. The open-source community was minding its own business, maintaining the project, when a pull request apparently from Livzon Pharmaceutical landed out of …
PGFS: Using Database as a Filesystem

A few days ago, I received a request from the Odoo community asking: “Databases support PITR (Point-in-Time Recovery), but is there a way to roll back the filesystem as well?” Why the “PGFS” Idea? From a veteran database engineer’s perspective, this …
A few days ago, I received a request from the Odoo community asking: “Databases support PITR (Point-in-Time Recovery), but is there a way to roll back the filesystem as well?” Why the “PGFS” Idea? From a veteran database engineer’s perspective, this …
Pigsty v3.4: PITR Enhancement, Locale Best Practices, Auto Certificates

GitHub Release | Release Note After a month of intensive development, Pigsty v3.4 is officially released. This version features significant architectural optimizations, addressing several core concerns highly valued by users and customers: Restore …
GitHub Release | Release Note After a month of intensive development, Pigsty v3.4 is officially released. This version features significant architectural optimizations, addressing several core concerns highly valued by users and customers: Restore …