Tag: Pigsty
SOW: Postpartum Care for 100,000 Packages
Today, let’s talk about Postpartum Care for Sows—a Chinese meme for the sort of absurdly specialized practical topic nobody expects to discuss. This time, the sow in question is my new open-source project, SOW. When you maintain a PostgreSQL …
Today, let’s talk about Postpartum Care for Sows—a Chinese meme for the sort of absurdly specialized practical topic nobody expects to discuss. This time, the sow in question is my new open-source project, SOW. When you maintain a PostgreSQL …
Instantly Clone PostgreSQL Databases—No Black Magic Required
Six months ago, on January 8, 2026, I wrote Git for Data: Instant PostgreSQL Database and Instance Cloning, introducing a new feature in PostgreSQL 18 and Pigsty v4.0: instant database cloning. With filesystem copy-on-write (CoW) and PostgreSQL 18’s …
Six months ago, on January 8, 2026, I wrote Git for Data: Instant PostgreSQL Database and Instance Cloning, introducing a new feature in PostgreSQL 18 and Pigsty v4.0: instant database cloning. With filesystem copy-on-write (CoW) and PostgreSQL 18’s …
What Is a PostgreSQL Distribution?
People often ask me: what exactly is Pigsty? My usual answer is: a PostgreSQL distribution. The next question is usually: what, then, is a “PostgreSQL distribution”? That is a good question. And the best place to begin is not databases, but operating …
People often ask me: what exactly is Pigsty? My usual answer is: a PostgreSQL distribution. The next question is usually: what, then, is a “PostgreSQL distribution”? That is a good question. And the best place to begin is not databases, but operating …
Give DBA Agents a Body
HOW 2026 keynote: Give DBA Agents a Body Part I: Opening—An Absurd Phenomenon 1. Cover Hello, everyone. I’m Yongjie Xue, the organizer of this tools track. This is a PostgreSQL tools session, but today I don’t want to talk about how many new …
HOW 2026 keynote: Give DBA Agents a Body Part I: Opening—An Absurd Phenomenon 1. Cover Hello, everyone. I’m Yongjie Xue, the organizer of this tools track. This is a PostgreSQL tools session, but today I don’t want to talk about how many new …
Put Your AI Agent's State in a Database
A year ago, I wrote an article called PGFS: Using a Database as a Filesystem. It started with a request from the Odoo community: make files and the PostgreSQL database recoverable together with point-in-time recovery, so both could be rolled back to …
A year ago, I wrote an article called PGFS: Using a Database as a Filesystem. It started with a request from the Odoo community: make files and the PostgreSQL database recoverable together with point-in-time recovery, so both could be rolled back to …
Pigsty Goes Global: 1.44M Visitors, Zero Ad Revenue
Traffic on pigsty.io jumped by roughly an order of magnitude over the last month. I opened the Cloudflare dashboard today and had to stare at it for a second. 1.44 million unique visitors, 18.11 million page views, 1.1 TB of traffic. That is over 30 …
Traffic on pigsty.io jumped by roughly an order of magnitude over the last month. I opened the Cloudflare dashboard today and had to stare at it for a second. 1.44 million unique visitors, 18.11 million page views, 1.1 TB of traffic. That is over 30 …
The Agent Moat: Runtime
3 AM. Database alerts are blowing up. You throw the alert info at a “top-tier” DBA Agent. It’s well-read — knows the PostgreSQL docs inside out, writes beautiful diagnostic SQL, can recite every kernel parameter from memory. It freezes: What’s the …
3 AM. Database alerts are blowing up. You throw the alert info at a “top-tier” DBA Agent. It’s well-read — knows the PostgreSQL docs inside out, writes beautiful diagnostic SQL, can recite every kernel parameter from memory. It freezes: What’s the …
From AGPL to Apache: Why I Changed Pigsty's License
Pigsty is a batteries-included, local-first PostgreSQL distribution. With the v4.0 release, I finally did something I’d been considering for a while: switching from AGPLv3 back to Apache 2.0. Here’s why I changed it, what it means, and my take on …
Pigsty is a batteries-included, local-first PostgreSQL distribution. With the v4.0 release, I finally did something I’d been considering for a while: switching from AGPLv3 back to Apache 2.0. Here’s why I changed it, what it means, and my take on …
Forging a China-Rooted, Global PostgreSQL Distro
Hi, I’m Yongjie Xue, author of Pigsty and an independent open-source contributor. Let’s talk about how to build a PostgreSQL distribution that is rooted in China and useful to the whole world. The question isn’t whether PG will win—it already has. …
Hi, I’m Yongjie Xue, author of Pigsty and an independent open-source contributor. Let’s talk about how to build a PostgreSQL distribution that is rooted in China and useful to the whole world. The question isn’t whether PG will win—it already has. …
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, …
Ready-to-Use PostgreSQL Distribution: Pigsty
What is Pigsty Pigsty is a ready-to-use production-grade open-source PostgreSQL distribution. A distribution refers to a complete database solution consisting of a database kernel and its suite of software packages. For example, Linux is an operating …
What is Pigsty Pigsty is a ready-to-use production-grade open-source PostgreSQL distribution. A distribution refers to a complete database solution consisting of a database kernel and its suite of software packages. For example, Linux is an operating …