Posts tagged "mysql" - Thomas Tsoi

May 14, 2026

When MySQL 8 Stopped Respecting Implicit Ordering

Upgrading to MySQL 8 reveals hidden dependencies on implicit row ordering as the optimizer gains flexibility. Explicitly defining query order ensures consistency in data retrieval.

mysql database query sql backend migration

Evaluate Index Strategies Beyond Big-O Complexity

Explores why theoretical data structures faster than O(log n) rarely outperform the practical, hardware-conscious index types used in modern databases.

database indexing algorithm performance mysql postgresql b-tree backend big-o

Moving from MySQL JSON to Postgres arrays

Transitioning from JSON columns to native Postgres arrays provides a more efficient approach for handling simple list-based data structures through indexing and direct querying.

mysql postgresql database schema optimization array json indexing performance