Wiki search
SQL in 10 Minutes — Your First Queries and Core Mental Model
Complete beginner guide to SQL querying, clause execution order, SELECT, WHERE, ORDER BY, LIMIT, NULL logic, grouping, and transaction safety.
SQL JOINs Explained with Visual Examples and Code
Master INNER JOIN, LEFT JOIN, RIGHT JOIN, and anti-joins with step-by-step beginner explanations, table diagrams, and syntax breakdowns.
SQL Indexes and EXPLAIN — How to Optimize Database Queries
Complete beginner guide to understanding B-tree indexes, reading EXPLAIN query plans, avoiding full table scans, and knowing when indexes hurt performance.
Choosing MySQL vs MariaDB in 2026
A practical comparison of MySQL and MariaDB, historical divergence, architectural differences, authentication plugins, and choosing the right database for your project.
MySQL and MariaDB Backups with mysqldump
Complete beginner guide to creating, automating, and restoring database backups using mysqldump and mariadb-dump with comprehensive command and flag breakdowns.
Install and Secure phpMyAdmin on Ubuntu & Debian
Step-by-step beginner guide to installing phpMyAdmin, configuring blowfish cookie encryption, custom URL aliases, and securing access behind IP and VPN allow-lists.
PDO and MySQL in PHP — Prepared Statements Done Right
Complete beginner guide to secure database access in PHP with PDO, eliminating SQL injection with prepared statements, connection options, and transactions.