News
Your ORM Is Lying to You (And You're Paying for It)
For most of my career, I thought that writing raw SQL is a sign of failure. Senior engineers used ORMs. Junior engineers wrote SQL...
Investigating the "Bus Factor" Risk in MongoDB, MariaDB, and More
The “bus factor” (also called “truck factor’) measures how many people would have to disappear before no one left knows how to fix...
Does MariaDB Depend on MySQL?
Thoughts on how MariaDB is incorrectly perceived merely as a fork of MySQL and how MariaDB is independent from MySQL yet highly co...
Is JOIN Faster Than Correlated Subqueries? Taking a Look and Subsequently Debunk...
The "bad" correlated subquery outperformed the "good" JOIN. The subquery triggered a Nested Loop plan with fast index lookups (25...
Synchronizing Data from MySQL to PostgreSQL Using Apache SeaTunnel
A step-by-step walkthrough of building a real-time data pipeline to merge and synchronize MySQL data sources using Apache SeaTunne...
Navigating MySQL Data Types: Strings
This article covers string types, how they function, what may go wrong, and how to make safe choices. Strings are all over databas...
