Tags: Database

  • Why PostgreSQL Won in the AI Era

    April 11, 2026 in AI

    Why PostgreSQL Won in the AI Era

    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

    New Programmers in the AI Era: Where Do You Go?

    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

    Data 2025: Year in Review with Mike Stonebraker

    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

    What Database Does AI Agent Need?

    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 and Baijiu: The Internet’s Obedience Test

    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 Is Dead. Who Picks Up the Pieces?

    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 is Dead

    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

    Why PostgreSQL Will Dominate 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.

    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

    Column: Database Guru

    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

    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.

    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 AI Toolbox: Production-Ready Database MCP is Here?

    Google recently launched a database MCP toolbox, perhaps the first production-ready solution.

    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

    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 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

    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.

    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

    Open Data Standards: Postgres, OTel, and Iceberg

    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

    The Lost Decade of Small Data

    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

    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.

    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

    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.

    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

    MySQL vs. PostgreSQL @ 2025

    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

    Database Planet Collision: When PG Falls for DuckDB

    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

    Comparing Oracle and PostgreSQL Transaction Systems

    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

    Solving Poker 24 with a Single SQL Query

    An interesting but tricky puzzle: solving the 24 game with SQL. The PostgreSQL solution.

    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

    7 Databases in 7 Weeks (2025)

    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

    Modern Hardware for Future Databases

    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

    Can MySQL Still Catch Up with PostgreSQL?

    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

    Optimize Bio Cores First, CPU Cores Second

    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: Now Powered by PostgreSQL?

    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

    MySQL is dead, Long live PostgreSQL!

    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

    Can Oracle Still Save MySQL?

    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

    Oracle Finally Killed MySQL

    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

    MySQL Performance Declining: Where is Sakila Going?

    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

    The $20 Brother PolarDB: What Should Databases Actually Cost?

    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

    Can Chinese Domestic Databases Really Compete?

    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 a Disgrace to "Open-Source" and Public Cloud

    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

    How Can MySQL's Correctness Be This Garbage?

    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

    Database in K8S: Pros & Cons

    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

    Are Specialized Vector Databases Dead?

    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

    Are Databases Really Being Strangled?

    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

    Which EL-Series OS Distribution Is Best?

    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

    What Kind of Self-Reliance Do Infrastructure 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 "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

    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 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

    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 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

    NewSQL: Distributive Nonsense

    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

    Is running postgres in docker a good idea?

    Thou shalt not run a prod database inside a container

    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

    Understanding Time - Leap Years, Leap Seconds, Time and Time Zones

    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

    Understanding Character Encoding Principles

    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

    Concurrency Anomalies Explained

    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

    Blockchain and Distributed Databases

    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

    Consistency: An Overloaded Term

    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

    Why Study Database Principles

    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.