Skip to content

Tags: Database

  • Why PostgreSQL Won in the AI Era

    In AI

    AIPostgreSQLDatabaseAgent

    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?

    In Database

    AIIndustryDatabase

    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

    In Database

    DatabaseDBOSPostgreSQL

    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?

    In Database

    DatabasePostgreSQLAIAgent

    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

    In Database

    MySQLDatabase

    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?

    In Database

    DatabaseMinIO

    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

    In Database

    DatabaseMinIOOpen Source

    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

    In PostgreSQL

    PostgreSQLAIDatabase

    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

    In Database

    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?

    In Database

    DatabasePostgreSQL

    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?

    In Database

    MCPDatabasePostgreSQL

    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?

    In Database

    DatabaseAIDBA

    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

    In Database

    DatabaseAIPostgreSQL

    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

    In Database

    DatabasePostgreSQLOpenTelemetryIceberg

    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

    In Database

    DatabaseDuckDBOLAP

    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?

    In Database

    Databaseetcd

    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

    In Database

    DatabasePostgreSQLAI

    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

    In Database

    DatabaseMySQLPostgreSQL

    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

    In Database

    PostgreSQLDuckDBDatabase

    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

    In Database

    DatabasePostgreSQLOracle

    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

    In Database

    DatabasePostgreSQLMySQL

    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)

    In Database

    DatabasePostgreSQLSQLiteDuckDBClickHouse

    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

    In Database

    DatabaseSupabase

    Supabase is an open-source PostgreSQL-based BaaS. It provides authentication, Realtime, Edge Functions, object storage, and REST APIs generated from the database schema; enabling pg_graphql on demand also provides GraphQL APIs. Self-hosting can make …

    Supabase is an open-source PostgreSQL-based BaaS. It provides authentication, Realtime, Edge Functions, object storage, and REST APIs generated from the database schema; enabling pg_graphql on demand also provides GraphQL APIs. Self-hosting can make …

  • Modern Hardware for Future Databases

    In Database

    DatabaseHardwarePerformance

    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?

    In Database

    DatabaseMySQLPostgreSQL

    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

    In Database

    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?

    In Database

    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!

    In Database

    DatabaseMySQLPostgreSQL

    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?

    In Database

    DatabaseMySQLOracle

    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

    In Database

    DatabaseMySQLOracle

    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?

    In Database

    DatabaseMySQLPerformance

    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?

    In Database

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

    In Database

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

    In Database

    DatabaseOpen SourceRedis

    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?

    In Database

    DatabaseMySQL

    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

    In Database

    DatabaseKubernetes

    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

    In Featured

    DatabaseKubernetes

    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?

    In Database

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

    In Database

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

    In Database

    DatabaseOperating-System

    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?

    In Database

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

    In Database

    DatabaseCloudArchitectureTech Commentary

    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

    In Database

    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

    In Database

    DatabaseNewSQL

    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?

    In Database

    DatabaseDocker

    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

    In Database

    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

    In Database

    DatabaseEncoding

    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

    In Database

    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

    In Database

    DatabaseDistributed

    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

    In Database

    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

    In Database

    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.