Best of MySQL — June 2025

1. 1
   Article

   Programming Digest·50w

   How Databases Store Your Tables on Disk

   Databases store tables using a hierarchical structure of pages and heap files. Data is organized in fixed-size pages (typically 8KB-16KB) that contain multiple rows, with databases reading entire pages rather than individual rows for efficiency. Tables are stored in heap files where pages can be unordered, making full table scans expensive. Indexes solve this by creating separate B-tree structures that point to specific pages in the heap, dramatically reducing I/O operations. Clustered indexes physically organize table data based on the index key, with databases like MySQL's InnoDB storing all tables as clustered indexes by default. The choice of primary key affects performance significantly, as random values like UUIDs can cause page splits and fragmentation.

   214

   6
2. 2
   Article

   Towards Dev·50w

   Blazing Fast Leaderboards using Redis

   A gaming platform faced severe performance issues with MySQL-based leaderboards, taking 30+ seconds to load for 1 million users. By migrating to Redis sorted sets (ZSETs), they reduced response times from 30 seconds to under 50 milliseconds. The implementation uses ZADD for storing user scores, ZCOUNT for ranking, and ZREVRANGE for pagination. While Redis dramatically improved performance, challenges remain with initial data loading for large datasets and concurrent write operations affecting query response times.

   94

   4
3. 3
   Article

   Data Engineer Things·49w

   I Stopped Using SQL for Database Management. Because I use the MCP Server with GitHub Copilot in VS Code

   A developer demonstrates how to replace traditional SQL database management with AI-powered tools by using GitHub Copilot and GibsonAI's MCP server in VS Code. The approach allows creating complete database schemas, deploying serverless databases, and generating CRUD APIs through simple prompts, eliminating manual schema design and boilerplate code. The tutorial shows building a travel agency database schema in under 60 seconds using natural language descriptions.

   85

   6
4. 4
   Video

   Laravel Daily·51w

   3 Tools to Draw/Manage Database Schema

   Three visual database design tools are showcased for Laravel developers: DrawDB for drag-and-drop visual schema creation, DBDiagram.io for code-based DBML syntax with version control benefits, and RunSQL for testing queries on mock data. The workflow demonstrates using AI to generate database schemas, visualizing relationships, and converting designs to Laravel migrations without writing initial code.

   76