Tag: MySQL
If There Was No Impact, Please Ignore This
A reader sent me this story: his RDS MySQL instance underwent two primary/standby failovers in five days. The cloud provider’s explanation was remarkable: its own back-end monitoring had queried the instance to death. The provider then promised to …
A reader sent me this story: his RDS MySQL instance underwent two primary/standby failovers in five days. The cloud provider’s explanation was remarkable: its own back-end monitoring had queried the instance to death. The provider then promised to …
MySQL 9.7: Same Old Leftovers, Reheated
Two years ago, I wrote MySQL Is Dead, Long Live PostgreSQL. MySQL 9.0 had just shipped, and Oracle had unveiled a VECTOR data type with great fanfare, billing it as “MySQL for the AI era.” One look was enough: it was a BLOB in a cheap disguise. No …
Two years ago, I wrote MySQL Is Dead, Long Live PostgreSQL. MySQL 9.0 had just shipped, and Oracle had unveiled a VECTOR data type with great fanfare, billing it as “MySQL for the AI era.” One look was enough: it was a BLOB in a cheap disguise. No …
PostgreSQL vs. MySQL in 2026
PostgreSQL has won the market for new database deployments, and its installed base is now comparable to MySQL’s. With one rising and the other declining, there is little suspense left in the contest for the database kernel of the future. I. Developer …
PostgreSQL has won the market for new database deployments, and its installed base is now comparable to MySQL’s. With one rising and the other declining, there is little suspense left in the contest for the database kernel of the future. I. Developer …
MySQL and Baijiu: The Internet’s Obedience Test
1. Two Painful Shots Remember your first sip of baijiu? It scorched down your throat like a wire of fire. Your face contorted, eyes watered, stomach flipped. Every instinct screamed: this isn’t food, it’s poison. The senior at the table grinned: …
1. Two Painful Shots Remember your first sip of baijiu? It scorched down your throat like a wire of fire. Your face contorted, eyes watered, stomach flipped. Every instinct screamed: this isn’t food, it’s poison. The senior at the table grinned: …
MySQL vs. PostgreSQL @ 2025
In 2025, PostgreSQL has opened a clear lead over MySQL on features, correctness, performance, and ecosystem—and the gap keeps widening. Here’s the panoramic view. Features Release cadence MySQL just dropped “Innovation” 9.3 (release notes), yet the …
In 2025, PostgreSQL has opened a clear lead over MySQL on features, correctness, performance, and ecosystem—and the gap keeps widening. Here’s the panoramic view. Features Release cadence MySQL just dropped “Innovation” 9.3 (release notes), yet the …
OpenHalo: MySQL Wire-Compatible PostgreSQL is Here!
What? PostgreSQL can now be accessed using MySQL clients? That’s right, openHalo, which was open-sourced on April Fool’s Day, provides exactly this capability — allowing users to simultaneously access and manage the same database using both MySQL and …
What? PostgreSQL can now be accessed using MySQL clients? That’s right, openHalo, which was open-sourced on April Fool’s Day, provides exactly this capability — allowing users to simultaneously access and manage the same database using both MySQL and …
Solving the 24-Point Card Game with a Single SQL Query
Here is the challenge: Database Programming Contest: Solve the 24-Point Card Game with One SQL Query, hosted by the database tooling platform NineData. There is a table named cards. Its auto-incrementing numeric primary key is id, and it has 4 …
Here is the challenge: Database Programming Contest: Solve the 24-Point Card Game with One SQL Query, hosted by the database tooling platform NineData. There is a table named cards. Its auto-incrementing numeric primary key is id, and it has 4 …
Can PostgreSQL Replace Microsoft SQL Server?
Many people don’t have an intuitive impression of how far PostgreSQL’s ecosystem has developed. Beyond devouring the database world and its all-encompassing extension ecosystem, PostgreSQL can directly replace Oracle, SQL Server, and MongoDB at the …
Many people don’t have an intuitive impression of how far PostgreSQL’s ecosystem has developed. Beyond devouring the database world and its all-encompassing extension ecosystem, PostgreSQL can directly replace Oracle, SQL Server, and MongoDB at the …
MySQL's ACID is a real mess
MySQL was once the world’s most popular open-source relational database. However, popularity doesn’t mean advanced, and popular things can have big problems. JEPSEN’s evaluation of MySQL’s isolation levels pierced through this veneer — in …
MySQL was once the world’s most popular open-source relational database. However, popularity doesn’t mean advanced, and popular things can have big problems. JEPSEN’s evaluation of MySQL’s isolation levels pierced through this veneer — in …