The JusDB Database Engineering Blog

MySQL's EXPLAIN command reveals exactly how the query optimizer plans to execute your SQL — which indexes it will use, how many rows it expects to examine, and where it may sort or create temporary tables.

Explore TiDB distributed SQL database for HTAP workloads. Learn TiKV/TiFlash architecture, MySQL compatibility, horizontal scaling, and deployment strategies.

Manage SQL schema migrations with Flyway — versioned and repeatable scripts, CI/CD integration, and team workflows

Optimize database performance by choosing the right data types and constraints. Learn about VARCHAR vs TEXT, INT sizes, ENUM optimization, and constraint best practices.

Navigate the complex landscape of database technologies. Compare SQL vs NoSQL, OLTP vs OLAP, and learn decision frameworks for selecting the perfect database for your use case.

MySQL 8.0 significantly improved geospatial support with SRID-aware columns, spatial reference systems, and accurate geographic distance calculations. Here's how to use it in production.

Learn the fundamental principles of database schema design for building scalable applications. This guide covers entity relationships, primary keys, foreign keys, and normalization concepts essential for high-performance databases.

MySQL 8 dramatically improved JSON support with functions that eliminate the need for application-side parsing. Here are 10 JSON functions that will transform how you work with JSON columns in MySQL.