- SQL Optimization
Practical SQL query tuning guide covering execution order, indexing, keyset pagination, prepared statements, CTEs, and a MariaDB slow-pagination case study.
- SQL Databases
Short overview of relational SQL databases including PostgreSQL, MySQL, TiDB, and ClickHouse, with their typical strengths and use cases.
- MySQL
Guide to MySQL, the popular open-source RDBMS, covering storage engines, data types, CRUD, indexing, views, procedures, triggers, replication, and best practices.
- PostgreSQL
Guide to PostgreSQL, the extensible open-source RDBMS, covering data types, JSON/JSONB, arrays, full-text search, index types, window functions, CTEs, and best practices.