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.

Pigsty v2.4: Monitor Cloud RDS
Pigsty v2.4 delivers PostgreSQL 16 GA support, RDS/PolarDB monitoring, Redis Sentinel HA, and a wave of new extensions including Apache AGE, zhparser, and pg_embedding.

Modb Interviews Industry Leaders - Feng Ruohang
Recently, a historic debate in the database industry has sparked heated discussion. The post-90s entrepreneur Feng Ruohang, known as the "ace debater" in the database community, has come into public …

What Kind of Self-Reliance Do Infra Software Need?
When we talk about self-reliance and control, what are we really talking about? Operational self-reliance vs. R&D self-reliance - what nations/users truly need is the former, not flashy …

Pigsty v2.3: Richer App Ecosystem
Pigsty v2.3 adds FerretDB MongoDB support, NocoDB integration, L2 VIP for node clusters, PostgreSQL security patches, and Redis 7.2.

Pigsty v2.2: Monitoring System Reborn
Pigsty v2.2 delivers a complete monitoring dashboard overhaul built on Grafana 10, a 42-node production simulation sandbox, Pigsty's own RPM repos, and UOS compatibility.

Cloud Computing Mudslide: Deconstructing Public Cloud with Data
Once upon a time, "going to cloud" was almost politically correct in tech circles, but few people use hard data to analyze the trade-offs involved. I'm willing to be this skeptic: let me use hard data …

DHH: Cloud-Exit Saves Over Ten Million, More Than Expected!
DHH migrated their seven cloud applications from AWS to their own hardware. 2024 is the first year of full savings realization. They're delighted to find the savings exceed initial estimates.

FinOps: Endgame Cloud-Exit
At the SACC 2023 FinOps session, I fiercely criticized cloud vendors. This is a transcript of my speech, introducing the ultimate FinOps concept — Cloud-Exit and its implementation path.

PostgreSQL, The most successful database
StackOverflow 2023 Survey shows PostgreSQL is the most popular, loved, and wanted database, solidifying its status as the 'Linux of Database'.

ISD Dataset: Analyzing 120 Years of Global Climate Change
ISD stands for Integrated Surface Dataset, a dataset published by NOAA (National Oceanic and Atmospheric Administration). I recently reorganized this dataset and provided related analysis tools.

Why Isn't Cloud Computing More Profitable Than Sand Mining?
Public cloud margins worse than sand mining—why are pig-butchering schemes losing money? Resource-selling models heading toward price wars, open source alternatives breaking monopoly dreams! Service …

SLA: Placebo or Insurance?
SLA is a marketing tool rather than insurance. In the worst-case scenario, it's an unavoidable loss; at best, it provides emotional comfort.

Pigsty v2.1: Vector + Full PG Version Support!
Pigsty v2.1 provides support for PostgreSQL 12 through 16, with PGVector for AI embeddings.

Back to Basics: Tech Reflection Chronicles
The cost-cutting imperative has triggered a reevaluation of all technologies, including databases. This series critiques hot DB technologies and poses fundamental questions about their trade-offs: Are …

Database Demand Hierarchy Pyramid
Similar to Maslow's hierarchy of needs, user demands for databases also have a progressive hierarchy: physiological needs, safety needs, belonging needs, esteem needs, cognitive needs, aesthetic …

AI Large Models and Vector Database PGVector
This article focuses on vector databases hyped by AI, introduces the basic principles of AI embeddings and vector storage/retrieval, and demonstrates the functionality, performance, acquisition, and …

NewSQL: Distributive Nonsens
As hardware technology advances, the capacity and performance of standalone databases have reached unprecedented heights. which makes distributed (TP) databases appear utterly powerless, much like the …

Will AI Have Self-Awareness?
Large models can feel “aware,” but self-awareness is another matter. We explore the term from Buddhism, cognitive psychology, and neural nets, then riff on a possible AI religion after bingeing …

AI Cult Rhapsody
A tongue-in-cheek vision of an AI-worshipping religion: scriptures, sects, philosopher-king machines, and the Book of AGI.

EBS: Pig Slaughter Scam
The real business model of cloud: "Cheap" EC2/S3 to attract customers, and fleece with "Expensive" EBS/RDS.

Garbage QCloud CDN: From Getting Started to Giving Up?
I originally believed that at least in IaaS fundamentals — storage, compute, and networking — public cloud vendors could still make significant contributions. However, my personal experience with …

Refuting "Why You Still Shouldn't Hire a DBA"
Guo Degang has a comedy routine: "Say I tell a rocket scientist, your rocket is no good, the fuel is wrong. I think it should burn wood, better yet coal, and it has to be premium coal, not washed …

Pigsty v2.0: Open-Source RDS PostgreSQL Alternative
Pigsty v2.0 delivers major improvements in security, compatibility, and feature integration — truly becoming a local open-source RDS alternative.

Paradigm Shift: From Cloud to Local-First
Cloud databases' exorbitant markups—sometimes 10x or more—are undoubtedly a scam for users outside the applicable spectrum. But we can dig deeper: why are public clouds, especially cloud databases, …

Pigsty v2.4: Monitor Cloud RDS
Pigsty v2.4 delivers PostgreSQL 16 GA support, RDS/PolarDB monitoring, Redis Sentinel HA, and a wave of new extensions including Apache AGE, zhparser, and pg_embedding.

Modb Interviews Industry Leaders - Feng Ruohang
Recently, a historic debate in the database industry has sparked heated discussion. The post-90s entrepreneur Feng Ruohang, known as the "ace debater" in the database community, has come into public …

What Kind of Self-Reliance Do Infra Software Need?
When we talk about self-reliance and control, what are we really talking about? Operational self-reliance vs. R&D self-reliance - what nations/users truly need is the former, not flashy …

Pigsty v2.3: Richer App Ecosystem
Pigsty v2.3 adds FerretDB MongoDB support, NocoDB integration, L2 VIP for node clusters, PostgreSQL security patches, and Redis 7.2.

Pigsty v2.2: Monitoring System Reborn
Pigsty v2.2 delivers a complete monitoring dashboard overhaul built on Grafana 10, a 42-node production simulation sandbox, Pigsty's own RPM repos, and UOS compatibility.

Cloud Computing Mudslide: Deconstructing Public Cloud with Data
Once upon a time, "going to cloud" was almost politically correct in tech circles, but few people use hard data to analyze the trade-offs involved. I'm willing to be this skeptic: let me use hard data …

DHH: Cloud-Exit Saves Over Ten Million, More Than Expected!
DHH migrated their seven cloud applications from AWS to their own hardware. 2024 is the first year of full savings realization. They're delighted to find the savings exceed initial estimates.

FinOps: Endgame Cloud-Exit
At the SACC 2023 FinOps session, I fiercely criticized cloud vendors. This is a transcript of my speech, introducing the ultimate FinOps concept — Cloud-Exit and its implementation path.

PostgreSQL, The most successful database
StackOverflow 2023 Survey shows PostgreSQL is the most popular, loved, and wanted database, solidifying its status as the 'Linux of Database'.

ISD Dataset: Analyzing 120 Years of Global Climate Change
ISD stands for Integrated Surface Dataset, a dataset published by NOAA (National Oceanic and Atmospheric Administration). I recently reorganized this dataset and provided related analysis tools.

Why Isn't Cloud Computing More Profitable Than Sand Mining?
Public cloud margins worse than sand mining—why are pig-butchering schemes losing money? Resource-selling models heading toward price wars, open source alternatives breaking monopoly dreams! Service …

SLA: Placebo or Insurance?
SLA is a marketing tool rather than insurance. In the worst-case scenario, it's an unavoidable loss; at best, it provides emotional comfort.

Pigsty v2.1: Vector + Full PG Version Support!
Pigsty v2.1 provides support for PostgreSQL 12 through 16, with PGVector for AI embeddings.

Back to Basics: Tech Reflection Chronicles
The cost-cutting imperative has triggered a reevaluation of all technologies, including databases. This series critiques hot DB technologies and poses fundamental questions about their trade-offs: Are …

Database Demand Hierarchy Pyramid
Similar to Maslow's hierarchy of needs, user demands for databases also have a progressive hierarchy: physiological needs, safety needs, belonging needs, esteem needs, cognitive needs, aesthetic …

AI Large Models and Vector Database PGVector
This article focuses on vector databases hyped by AI, introduces the basic principles of AI embeddings and vector storage/retrieval, and demonstrates the functionality, performance, acquisition, and …

NewSQL: Distributive Nonsens
As hardware technology advances, the capacity and performance of standalone databases have reached unprecedented heights. which makes distributed (TP) databases appear utterly powerless, much like the …

Will AI Have Self-Awareness?
Large models can feel “aware,” but self-awareness is another matter. We explore the term from Buddhism, cognitive psychology, and neural nets, then riff on a possible AI religion after bingeing …

AI Cult Rhapsody
A tongue-in-cheek vision of an AI-worshipping religion: scriptures, sects, philosopher-king machines, and the Book of AGI.

EBS: Pig Slaughter Scam
The real business model of cloud: "Cheap" EC2/S3 to attract customers, and fleece with "Expensive" EBS/RDS.

Garbage QCloud CDN: From Getting Started to Giving Up?
I originally believed that at least in IaaS fundamentals — storage, compute, and networking — public cloud vendors could still make significant contributions. However, my personal experience with …

Refuting "Why You Still Shouldn't Hire a DBA"
Guo Degang has a comedy routine: "Say I tell a rocket scientist, your rocket is no good, the fuel is wrong. I think it should burn wood, better yet coal, and it has to be premium coal, not washed …

Pigsty v2.0: Open-Source RDS PostgreSQL Alternative
Pigsty v2.0 delivers major improvements in security, compatibility, and feature integration — truly becoming a local open-source RDS alternative.

Paradigm Shift: From Cloud to Local-First
Cloud databases' exorbitant markups—sometimes 10x or more—are undoubtedly a scam for users outside the applicable spectrum. But we can dig deeper: why are public clouds, especially cloud databases, …
Pigsty v2.4: Monitor Cloud RDS

GitHub Release | Release Note PostgreSQL released its new major version 16 today, bringing a series of improvements. Pigsty followed up within 1 hour of release with Pigsty v2.4, providing complete support for PostgreSQL 16 GA. Additionally, v2.4 …
GitHub Release | Release Note PostgreSQL released its new major version 16 today, bringing a series of improvements. Pigsty followed up within 1 hour of release with Pigsty v2.4, providing complete support for PostgreSQL 16 GA. Additionally, v2.4 …
Modb Interviews Industry Leaders - Feng Ruohang

Original WeChat Article | 【Modb Interviews Industry Leaders: Feng Ruohang】 Introduction: Recently, a historic debate in the database industry has sparked heated discussion. The post-90s entrepreneur Feng Ruohang, known as the “ace debater” in the …
Original WeChat Article | 【Modb Interviews Industry Leaders: Feng Ruohang】 Introduction: Recently, a historic debate in the database industry has sparked heated discussion. The post-90s entrepreneur Feng Ruohang, known as the “ace debater” in the …
What Kind of Self-Reliance Do Infra Software Need?

WeChat | Zhihu Original When we talk about self-reliance and control, what are we really talking about? For infrastructure software (operating systems/databases), does self-reliance and control mean: developed, distributed, and controlled by Chinese …
WeChat | Zhihu Original When we talk about self-reliance and control, what are we really talking about? For infrastructure software (operating systems/databases), does self-reliance and control mean: developed, distributed, and controlled by Chinese …
Pigsty v2.3: Richer App Ecosystem

GitHub Release | Release Note Pigsty v2.3 is here! This release further refines the monitoring system, enriches the application ecosystem, and keeps pace with PostgreSQL’s routine minor version updates (CVE fixes). Pigsty v2.3 follows PostgreSQL’s …
GitHub Release | Release Note Pigsty v2.3 is here! This release further refines the monitoring system, enriches the application ecosystem, and keeps pace with PostgreSQL’s routine minor version updates (CVE fixes). Pigsty v2.3 follows PostgreSQL’s …
Pigsty v2.2: Monitoring System Reborn

GitHub Release | Release Note Pigsty v2.2 is here! The world’s most powerful PostgreSQL monitoring system receives an epic upgrade — completely rebuilt on Grafana v10, pushing PG observability to a whole new level with a dramatically improved user …
GitHub Release | Release Note Pigsty v2.2 is here! The world’s most powerful PostgreSQL monitoring system receives an epic upgrade — completely rebuilt on Grafana v10, pushing PG observability to a whole new level with a dramatically improved user …
Cloud Computing Mudslide: Deconstructing Public Cloud with Data

Once upon a time, “going to cloud” was almost politically correct in tech circles, but few people use hard data to analyze the trade-offs involved. I’m willing to be this skeptic: let me use hard data and personal stories to explain the traps and …
Once upon a time, “going to cloud” was almost politically correct in tech circles, but few people use hard data to analyze the trade-offs involved. I’m willing to be this skeptic: let me use hard data and personal stories to explain the traps and …
DHH: Cloud-Exit Saves Over Ten Million, More Than Expected!

Author: DHH, “Our Cloud-Exit savings will now top ten million over five years” Feng’s Commentary As a cloud exit advocate, I’m gratified to see DHH’s tremendous success in the cloud exit process. The world always rewards leaders with the wisdom to …
Author: DHH, “Our Cloud-Exit savings will now top ten million over five years” Feng’s Commentary As a cloud exit advocate, I’m gratified to see DHH’s tremendous success in the cloud exit process. The world always rewards leaders with the wisdom to …
FinOps: Endgame Cloud-Exit

At the SACC 2023 FinOps session, I fiercely criticized cloud vendors. This is a transcript of my speech, introducing the ultimate FinOps concept — Cloud-Exit and its best practice. TL; DR Misaligned FinOps Focus: Total Cost = Unit Price x Quantity. …
At the SACC 2023 FinOps session, I fiercely criticized cloud vendors. This is a transcript of my speech, introducing the ultimate FinOps concept — Cloud-Exit and its best practice. TL; DR Misaligned FinOps Focus: Total Cost = Unit Price x Quantity. …
PostgreSQL, The most successful database

The StackOverflow 2023 Survey, featuring feedback from 90K developers across 185 countries, is out. PostgreSQL topped all three survey categories (used, loved, and wanted), earning its title as the undisputed “Decathlete Database” – it’s hailed as …
The StackOverflow 2023 Survey, featuring feedback from 90K developers across 185 countries, is out. PostgreSQL topped all three survey categories (used, loved, and wanted), earning its title as the undisputed “Decathlete Database” – it’s hailed as …
ISD Dataset: Analyzing 120 Years of Global Climate Change

Original WeChat Article ISD stands for Integrated Surface Dataset, a dataset published by NOAA (National Oceanic and Atmospheric Administration). It contains observational records from nearly 30,000 global surface meteorological stations from 1900 …
Original WeChat Article ISD stands for Integrated Surface Dataset, a dataset published by NOAA (National Oceanic and Atmospheric Administration). It contains observational records from nearly 30,000 global surface meteorological stations from 1900 …
Why Isn't Cloud Computing More Profitable Than Sand Mining?

Public cloud margins worse than sand mining, Why are pig-butchering schemes losing money? Resource-selling models heading toward price wars, Open source alternatives breaking monopoly dreams! Service competitiveness gradually neutralized, Where is …
Public cloud margins worse than sand mining, Why are pig-butchering schemes losing money? Resource-selling models heading toward price wars, Open source alternatives breaking monopoly dreams! Service competitiveness gradually neutralized, Where is …
SLA: Placebo or Insurance?

In the world of cloud computing, Service Level Agreements (SLAs) are seen as a cloud provider’s commitment to the quality of its services. However, a closer examination of these SLAs reveals that they might not offer the safety net one might expect: …
In the world of cloud computing, Service Level Agreements (SLAs) are seen as a cloud provider’s commitment to the quality of its services. However, a closer examination of these SLAs reveals that they might not offer the safety net one might expect: …
Pigsty v2.1: Vector + Full PG Version Support!

GitHub Release | Release Note Following PostgreSQL’s summer minor version updates and the release of PG 16 Beta, Pigsty closely tracks the PG community with the v2.1 release. This update supports PostgreSQL 16 Beta1 high availability and new …
GitHub Release | Release Note Following PostgreSQL’s summer minor version updates and the release of PG 16 Beta, Pigsty closely tracks the PG community with the v2.1 release. This update supports PostgreSQL 16 Beta1 high availability and new …
Back to Basics: Tech Reflection Chronicles

Recently, there have been some hotly debated topics in the tech community: Are cloud databases an IQ tax? Is public cloud a pig-killing scam? Are distributed databases a false need? Are microservices a stupid idea? Do you still need ops and DBAs? Is …
Recently, there have been some hotly debated topics in the tech community: Are cloud databases an IQ tax? Is public cloud a pig-killing scam? Are distributed databases a false need? Are microservices a stupid idea? Do you still need ops and DBAs? Is …
Database Demand Hierarchy Pyramid

Similar to Maslow’s hierarchy of needs, user demands for databases also have a progressive hierarchy. User demands for databases can be divided into eight levels from bottom to top, corresponding to human needs: Physiological Needs: Functionality - …
Similar to Maslow’s hierarchy of needs, user demands for databases also have a progressive hierarchy. User demands for databases can be divided into eight levels from bottom to top, corresponding to human needs: Physiological Needs: Functionality - …
AI Large Models and Vector Database PGVector

New AI applications have shown exponential growth over the past year, and these applications face a common challenge: how to store and query AI embeddings represented as vectors at scale. This article focuses on vector databases hyped by AI, …
New AI applications have shown exponential growth over the past year, and these applications face a common challenge: how to store and query AI embeddings represented as vectors at scale. This article focuses on vector databases hyped by AI, …
NewSQL: Distributive Nonsens

WeChat Column As hardware technology advances, the capacity and performance of standalone databases have reached unprecedented heights. In this transformative era, distributed (TP) databases appear utterly powerless, much like the “data middle …
WeChat Column As hardware technology advances, the capacity and performance of standalone databases have reached unprecedented heights. In this transformative era, distributed (TP) databases appear utterly powerless, much like the “data middle …
Will AI Have Self-Awareness?

WeChat original Large models can appear conscious, but self-awareness is optional—and maybe dangerous before ethics catch up. Pantheon sparked these thoughts. What is self-awareness? When we say “self-awareness,” what do we actually mean? Let’s …
WeChat original Large models can appear conscious, but self-awareness is optional—and maybe dangerous before ethics catch up. Pantheon sparked these thoughts. What is self-awareness? When we say “self-awareness,” what do we actually mean? Let’s …
AI Cult Rhapsody

WeChat original “Humans are the bootloader for silicon life.” —Elon Musk Maybe we’re about to witness an AI-worshipping religion. Imagine this: Humans are lumps of negative entropy, hard-coded to reproduce via clumsy genetics. In digital space, with …
WeChat original “Humans are the bootloader for silicon life.” —Elon Musk Maybe we’re about to witness an AI-worshipping religion. Imagine this: Humans are lumps of negative entropy, hard-coded to reproduce via clumsy genetics. In digital space, with …
EBS: Pig Slaughter Scam

We already answer the question: Is RDS an Idiot Tax?. But when compared to the hundredfold markup of public cloud block storage, cloud databases seem almost reasonable. This article uses real data to reveal the true business model of public cloud: …
We already answer the question: Is RDS an Idiot Tax?. But when compared to the hundredfold markup of public cloud block storage, cloud databases seem almost reasonable. This article uses real data to reveal the true business model of public cloud: …
Garbage QCloud CDN: From Getting Started to Giving Up?

While Swedish Ma and I disagree sharply on cloud databases VS DBA issues, we can reach consensus on one point: domestic public cloud vendors really make garbage. In Ma’s words: “Alibaba-Cloud is a legitimate cloud with poor engineering quality, but …
While Swedish Ma and I disagree sharply on cloud databases VS DBA issues, we can reach consensus on one point: domestic public cloud vendors really make garbage. In Ma’s words: “Alibaba-Cloud is a legitimate cloud with poor engineering quality, but …
Refuting "Why You Still Shouldn't Hire a DBA"

Guo Degang has a comedy routine: “Say I tell a rocket scientist, your rocket is no good, the fuel is wrong. I think it should burn wood, better yet coal, and it has to be premium coal, not washed coal. If that scientist takes me seriously, he …
Guo Degang has a comedy routine: “Say I tell a rocket scientist, your rocket is no good, the fuel is wrong. I think it should burn wood, better yet coal, and it has to be premium coal, not washed coal. If that scientist takes me seriously, he …
Pigsty v2.0: Open-Source RDS PostgreSQL Alternative

GitHub Release | Release Note 2023/02/28, Pigsty v2.0.0 is officially released, bringing a series of major feature updates. PIGSTY now stands for “PostgreSQL In Great STYle” — PostgreSQL at its best. Pigsty’s positioning has also evolved from …
GitHub Release | Release Note 2023/02/28, Pigsty v2.0.0 is officially released, bringing a series of major feature updates. PIGSTY now stands for “PostgreSQL In Great STYle” — PostgreSQL at its best. Pigsty’s positioning has also evolved from …
Paradigm Shift: From Cloud to Local-First

In the previous article, we used data to answer “Are Cloud Databases an Intelligence Tax?"—the exorbitant markups of several to over ten times are undoubtedly a scam for users outside the applicable spectrum. But we can dig deeper: why are public …
In the previous article, we used data to answer “Are Cloud Databases an Intelligence Tax?"—the exorbitant markups of several to over ten times are undoubtedly a scam for users outside the applicable spectrum. But we can dig deeper: why are public …