Tags: Database
Why PostgreSQL Won in the AI Era
April 11, 2026 in AI

Boring technology won the wildest era. A look at extensibility, agent choice, database cloning, and the future of the DBA.
Boring technology won the wildest era. A look at extensibility, agent choice, database cloning, and the future of the DBA.
New Programmers in the AI Era: Where Do You Go?
February 01, 2026 in Database

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.
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.
Data 2025: Year in Review with Mike Stonebraker
December 24, 2025 in Database

A conversation between Mike Stonebraker (Turing Award Winner, Creator of PostgreSQL), Andy Pavlo (Carnegie Mellon), and the DBOS team.
A conversation between Mike Stonebraker (Turing Award Winner, Creator of PostgreSQL), Andy Pavlo (Carnegie Mellon), and the DBOS team.
What Database Does AI Agent Need?
December 21, 2025 in Database

The bottleneck for AI agents isn't in database engines but in upper-layer integration. Muscle memory, associative memory, and trial-and-error courage will be key.
The bottleneck for AI agents isn't in database engines but in upper-layer integration. Muscle memory, associative memory, and trial-and-error courage will be key.
MySQL and Baijiu: The Internet’s Obedience Test
December 20, 2025 in Database

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?
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?
MinIO Is Dead. Who Picks Up the Pieces?
December 08, 2025 in Database

MinIO just entered maintenance mode. What replaces it? Can RustFS step in? I tested the contenders so you don’t have to.
MinIO just entered maintenance mode. What replaces it? Can RustFS step in? I tested the contenders so you don’t have to.
MinIO is Dead
December 04, 2025 in Database

MinIO announces that it is entering maintenance mode: the dragon-slayer has become the dragon. This is how MinIO transformed from an open-source S3 alternative into just another commercial software company.
MinIO announces that it is entering maintenance mode: the dragon-slayer has become the dragon. This is how MinIO transformed from an open-source S3 alternative into just another commercial software company.
Why PostgreSQL Will Dominate the AI Era
December 01, 2025 in PostgreSQL

Context window economics, the polyglot persistence problem, and the triumph of zero-glue architecture make PostgreSQL the database king of the AI era.
Context window economics, the polyglot persistence problem, and the triumph of zero-glue architecture make PostgreSQL the database king of the AI era.
Column: Database Guru
August 08, 2025 in Database

The database world is full of hype and marketing fog. This column cuts through it with blunt commentary on industry trends and product reality.
The database world is full of hype and marketing fog. This column cuts through it with blunt commentary on industry trends and product reality.
Dongchedi Just Exposed “Smart Driving.” Where’s Our Dongku-Di?
July 26, 2025 in Database

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.
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.
Google AI Toolbox: Production-Ready Database MCP is Here?
July 09, 2025 in Database
Google recently launched a database MCP toolbox, perhaps the first production-ready solution.
Where Will Databases and DBAs Go in the AI Era?
June 30, 2025 in Database

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 published.
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 published.
Stop Arguing, The AI Era Database Has Been Settled
June 03, 2025 in Database

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.
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.
Open Data Standards: Postgres, OTel, and Iceberg
May 27, 2025 in Database

Three emerging standards in the data world: Postgres, OpenTelemetry, and Iceberg. Postgres is already the de facto standard.
Three emerging standards in the data world: Postgres, OpenTelemetry, and Iceberg. Postgres is already the de facto standard.
The Lost Decade of Small Data
May 23, 2025 in Database

If DuckDB had launched in 2012, the great migration to distributed analytics might never have happened. Data isn't that big after all.
If DuckDB had launched in 2012, the great migration to distributed analytics might never have happened. Data isn't that big after all.
How Many Shops Has etcd Torched?
May 07, 2025 in Database

Plenty. If you’re rolling your own Kubernetes, odds are you’ll crash because etcd ships with a 2 GB time bomb.
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
April 27, 2025 in 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.
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
April 17, 2025 in Database

A 2025 reality check on where PostgreSQL stands relative to MySQL across features, performance, quality, and ecosystem.
A 2025 reality check on where PostgreSQL stands relative to MySQL across features, performance, quality, and ecosystem.
Database Planet Collision: When PG Falls for DuckDB
March 12, 2025 in Database

If you ask me, we’re on the brink of a cosmic collision in database-land, and Postgres + DuckDB is the meteor we should all be watching.
If you ask me, we’re on the brink of a cosmic collision in database-land, and Postgres + DuckDB is the meteor we should all be watching.
Comparing Oracle and PostgreSQL Transaction Systems
February 27, 2025 in Database

The PG community has started punching up: Cybertec’s Laurenz Albe breaks down how Oracle’s transaction system stacks against PostgreSQL.
The PG community has started punching up: Cybertec’s Laurenz Albe breaks down how Oracle’s transaction system stacks against PostgreSQL.
Solving Poker 24 with a Single SQL Query
December 03, 2024 in Database
An interesting but tricky puzzle: solving the 24 game with SQL. The PostgreSQL solution.
7 Databases in 7 Weeks (2025)
December 03, 2024 in Database

Is PostgreSQL the king of boring databases? Here are seven databases worth studying in 2025: PostgreSQL, SQLite, DuckDB, ClickHouse, FoundationDB, TigerBeetle, and CockroachDB—each deserving a week of deep exploration.
Is PostgreSQL the king of boring databases? Here are seven databases worth studying in 2025: PostgreSQL, SQLite, DuckDB, ClickHouse, FoundationDB, TigerBeetle, and CockroachDB—each deserving a week of deep exploration.
Self-Hosting Supabase on PostgreSQL
November 25, 2024 in Database
Supabase is great, but owning your own Supabase is even better. Here’s a comprehensive tutorial for self-hosting production-grade Supabase on local or cloud VMs/BMs. What is Supabase? Supabase is an open-source Firebase alternative and a …
Supabase is great, but owning your own Supabase is even better. Here’s a comprehensive tutorial for self-hosting production-grade Supabase on local or cloud VMs/BMs. What is Supabase? Supabase is an open-source Firebase alternative and a …
Modern Hardware for Future Databases
November 20, 2024 in Database

A survey on how hardware developments affect database design, covering key advancements in networking, storage, and computing.
A survey on how hardware developments affect database design, covering key advancements in networking, storage, and computing.
Can MySQL Still Catch Up with PostgreSQL?
November 05, 2024 in Database

Percona founder Peter Zaitsev discusses whether MySQL can still keep up with PostgreSQL. His views largely represent the MySQL communitys perspective.
Percona founder Peter Zaitsev discusses whether MySQL can still keep up with PostgreSQL. His views largely represent the MySQL communitys perspective.
Optimize Bio Cores First, CPU Cores Second
September 07, 2024 in Database

Programmers are expensive, scarce biological computing cores, the anchor point of software costs — please prioritize optimizing biological cores before optimizing CPU cores.
Programmers are expensive, scarce biological computing cores, the anchor point of software costs — please prioritize optimizing biological cores before optimizing CPU cores.
MongoDB: Now Powered by PostgreSQL?
September 03, 2024 in Database

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.
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.
MySQL is dead, Long live PostgreSQL!
July 08, 2024 in Database

This July, MySQL 9.0 was finally released—a full eight years after its last major version, 8.0 (@2016-09).
This July, MySQL 9.0 was finally released—a full eight years after its last major version, 8.0 (@2016-09).
Can Oracle Still Save MySQL?
June 21, 2024 in Database

Percona founder Peter Zaitsev publicly expressed disappointment with MySQL and Oracle, criticizing the declining performance with newer versions.
Percona founder Peter Zaitsev publicly expressed disappointment with MySQL and Oracle, criticizing the declining performance with newer versions.
Oracle Finally Killed MySQL
June 20, 2024 in Database

Peter Zaitsev, founder of Percona, criticizes how Oracles actions and inactions have killed MySQL. About 15 years after acquiring Sun and MySQL.
Peter Zaitsev, founder of Percona, criticizes how Oracles actions and inactions have killed MySQL. About 15 years after acquiring Sun and MySQL.
MySQL Performance Declining: Where is Sakila Going?
June 19, 2024 in Database

Higher MySQL versions mean worse performance? Percona monitoring shows slow migration from 5.7 to 8.x. PostgreSQL is pulling ahead.
Higher MySQL versions mean worse performance? Percona monitoring shows slow migration from 5.7 to 8.x. PostgreSQL is pulling ahead.
The $20 Brother PolarDB: What Should Databases Actually Cost?
April 25, 2024 in Database

Today we discuss the fair pricing of commercial databases, open-source databases, cloud databases, and domestic Chinese databases.
Today we discuss the fair pricing of commercial databases, open-source databases, cloud databases, and domestic Chinese databases.
Can Chinese Domestic Databases Really Compete?
April 25, 2024 in Database

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 the database ecosystem landscape and establish more accurate proportional awareness.
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 the database ecosystem landscape and establish more accurate proportional awareness.
Redis Going Non-Open-Source is a Disgrace to "Open-Source" and Public Cloud
March 25, 2024 in Database

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 is just one means to achieve software freedom.
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 is just one means to achieve software freedom.
How Can MySQL's Correctness Be This Garbage?
December 28, 2023 in Database

MySQL's transaction ACID has flaws and doesn't match documentation promises. This may lead to serious correctness issues - use with caution.
MySQL's transaction ACID has flaws and doesn't match documentation promises. This may lead to serious correctness issues - use with caution.
Database in K8S: Pros & Cons
December 06, 2023 in Database
Whether databases should be housed in Kubernetes/Docker remains highly controversial. While Kubernetes (k8s) excels in managing stateless applications, it has fundamental drawbacks with stateful services, especially databases like PostgreSQL and …
Whether databases should be housed in Kubernetes/Docker remains highly controversial. While Kubernetes (k8s) excels in managing stateless applications, it has fundamental drawbacks with stateful services, especially databases like PostgreSQL and …
Database in K8S: Pros & Cons
December 05, 2023 in Featured

Whether databases should be housed in Kubernetes/Docker remains highly controversial. While K8s excels in managing stateless applications, it has fundamental drawbacks with stateful services like databases.
Whether databases should be housed in Kubernetes/Docker remains highly controversial. While K8s excels in managing stateless applications, it has fundamental drawbacks with stateful services like databases.
Are Specialized Vector Databases Dead?
November 21, 2023 in Database

Vector storage and retrieval is a real need, but specialized vector databases are already dead. Small needs are solved by OpenAI directly, standard needs are captured by existing mature databases with vector extensions. The ecological niche left for specialized vector databases might support one company, but trying to build an industry around AI stories is impossible.
Vector storage and retrieval is a real need, but specialized vector databases are already dead. Small needs are solved by OpenAI directly, standard needs are captured by existing mature databases with vector extensions. The ecological niche left for specialized vector databases might support one company, but trying to build an industry around AI stories is impossible.
Are Databases Really Being Strangled?
November 02, 2023 in Database

Many "domestic databases" are just shoddy, inferior products that can't be helped. Xinchuang domestic OS/databases are essentially **IT pre-made meals in schools**. Users hold their noses while migrating, developers pretend to work hard, and everyone plays along with leaders who neither understand nor care about technology. The infrastructure software industry isn't being strangled by anyone - the real chokehold comes from the so-called "insiders."
Many "domestic databases" are just shoddy, inferior products that can't be helped. Xinchuang domestic OS/databases are essentially **IT pre-made meals in schools**. Users hold their noses while migrating, developers pretend to work hard, and everyone plays along with leaders who neither understand nor care about technology. The infrastructure software industry isn't being strangled by anyone - the real chokehold comes from the so-called "insiders."
Which EL-Series OS Distribution Is Best?
October 09, 2023 in Database

RHEL-series OS distribution compatibility level: RHEL = Rocky ≈ Anolis > Alma > Oracle >> Euler. Recommend using RockyLinux 8.8, or Anolis 8.8 for domestic requirements.
RHEL-series OS distribution compatibility level: RHEL = Rocky ≈ Anolis > Alma > Oracle >> Euler. Recommend using RockyLinux 8.8, or Anolis 8.8 for domestic requirements.
What Kind of Self-Reliance Do Infrastructure Software Need?
August 31, 2023 in Database

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 "self-research".
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 "self-research".
Back to Basics: Tech Reflection Chronicles
May 29, 2023 in Database

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 cloud databases, distributed databases, microservices, and containerization real needs or false hype?
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 cloud databases, distributed databases, microservices, and containerization real needs or false hype?
Database Demand Hierarchy Pyramid
May 10, 2023 in Database

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 needs, self-actualization needs, and transcendence needs.
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 needs, self-actualization needs, and transcendence needs.
NewSQL: Distributive Nonsense
May 07, 2023 in Database

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 "data middle platform" wearing the emperor's new clothes.
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 "data middle platform" wearing the emperor's new clothes.
Is running postgres in docker a good idea?
January 13, 2019 in Database
Thou shalt not run a prod database inside a container
Understanding Time - Leap Years, Leap Seconds, Time and Time Zones
December 11, 2018 in Database

A proper understanding of time is very helpful for correctly handling time-related issues in work and life. For example, time representation and processing in computers, as well as time handling in databases and programming languages.
A proper understanding of time is very helpful for correctly handling time-related issues in work and life. For example, time representation and processing in computers, as well as time handling in databases and programming languages.
Understanding Character Encoding Principles
July 01, 2018 in Database

Without understanding the basic principles of character encoding, even simple string operations like comparison, sorting, and random access can easily lead you into pitfalls. This article attempts to clarify these issues through a comprehensive explanation.
Without understanding the basic principles of character encoding, even simple string operations like comparison, sorting, and random access can easily lead you into pitfalls. This article attempts to clarify these issues through a comprehensive explanation.
Concurrency Anomalies Explained
June 19, 2018 in Database

Concurrent programs are hard to write correctly and even harder to write well. Many programmers simply throw these problems at the database... But even the most sophisticated databases won't help if you don't understand concurrency anomalies and isolation levels.
Concurrent programs are hard to write correctly and even harder to write well. Many programmers simply throw these problems at the database... But even the most sophisticated databases won't help if you don't understand concurrency anomalies and isolation levels.
Blockchain and Distributed Databases
June 09, 2018 in Database

The technical essence, functionality, and evolution of blockchain is distributed databases. Specifically, it's a **Byzantine Fault Tolerant (resistant to malicious node attacks) distributed (leaderless replication) database**.
The technical essence, functionality, and evolution of blockchain is distributed databases. Specifically, it's a **Byzantine Fault Tolerant (resistant to malicious node attacks) distributed (leaderless replication) database**.
Consistency: An Overloaded Term
May 08, 2018 in Database

The term "consistency" is heavily overloaded, representing different concepts in different contexts. For example, the C in ACID and the C in CAP actually refer to different concepts.
The term "consistency" is heavily overloaded, representing different concepts in different contexts. For example, the C in ACID and the C in CAP actually refer to different concepts.
Why Study Database Principles
April 20, 2018 in Database

Those who only know how to code are just programmers; **learn databases well, and you can at least make a living**; but for **excellent** engineers, merely **using** databases is far from enough.
Those who only know how to code are just programmers; **learn databases well, and you can at least make a living**; but for **excellent** engineers, merely **using** databases is far from enough.


