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

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

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.

This is the English placeholder post for Pigsty v4.2. The content is temporarily filled with the v4.2.0 release notes and will be replaced later.

A migration case with only a JAR and no source code shows why Oracle syntax compatibility is not always a fake requirement, and how IvorySQL + Pigsty can absorb legacy debt at low cost.

Ontology is largely a data-modeling method. In enterprise practice, much of it overlaps with familiar database concepts, while the framing can make it feel newer and more differentiated than it really is.

MinIO’s repo is officially archived and abandoned. And how AI Agents helped bring it back from the dead. This post explains how a community fork restores the admin console and ships binaries via CI/CD pipeline.

Same-day production support for PG 18.2 is the core message of Pigsty v4.1. In this cycle, very few vendors shipped day-zero readiness: AWS RDS, EDB, and Pigsty were among them.

Codex 5.3 xHigh pushed my workflow past a tipping point: writing code is no longer the scarce resource. The real leverage is design quality and engineering acceptance. This is the practical loop I use to ship reliable software with AI agents.

A mediocre local who knows the terrain beats a genius parachuted into unknown territory. Intelligence without context is idle. An agent without a runtime is vapor.

Software stocks are melting down. Who survives? Who rises? AI stripped away software’s skin, exposing the database skeleton underneath. The market isn’t panic-selling — it’s repricing.

Should we still hire fresh grads? Squeezed between AI and senior devs, what’s the play for new programmers? Master the right tools, take initiative, find the right mentor.

Pigsty v4.0 is a milestone release — what I’d call “Finished Software.” The real theme: Built for AI Agents and enabling the DBA Agent.

SaaS and workflow software are dead. From APPs & GUIs to Agents, Databases, and CLI.

Before you hit “one-click deploy” on that cloud AI assistant, ask yourself: what exactly are you giving up? There’s a reason why people by Mac mini rather than running clawdbot on the cloud.

Pigsty switched from AGPLv3 to Apache 2.0. Aren’t you worried about freeloaders? Freeloaders welcome — if you want to become the Debian of databases, a permissive license is table stakes.

LLM = CPU. Context = RAM. Database = Disk. Agent = App. The mapping is surprisingly clean. And if OS history is any guide, we may know what comes next — and what’s still missing.

Yesterday I tweeted: “Built a Claude Code Grafana dashboard to see how it makes decisions, uses tools, and burns through API credits.” Didn’t expect so much interest. So let’s talk about Claude Code observability.

A deep dive into the SOTA approach for PostgreSQL HA. RTO/RPO breakdown, from theory to production. If you’re still wrestling with PG HA, this might save you years.

How to install and use Claude Code? How to achieve similar results at 1/10 of Claude’s cost with alternative models? A one-liner to get CC up and running!

How to instantly clone a massive PostgreSQL database without consuming extra storage? PostgreSQL 18 and XFS can spark some serious magic.

When a company that was “born on the cloud” goes “self-host first,” does that count as cloud exit? A repost of a deleted piece on the infrastructure coming-of-age for China’s internet giants.

A conversation between Mike Stonebraker (MIT CSAIL, Turing Award Winner, Creator of PostgreSQL), Andy Pavlo (Carnegie Mellon University), and the DBOS team.

MySQL is to the internet what baijiu is to China: harsh, hard to swallow, yet worshipped because culture demands obedience. Both are loyalty tests—will you endure discomfort to fit in?