MySQL and PostgreSQL for Web Projects

MySQL, MariaDB, and PostgreSQL belong to the core of data storage in many web projects. The examples cover connection, rights, backup, and diagnosis.

MySQL and MariaDB

bash

sql

PostgreSQL

bash

sql

Key points

Connections and rights form the basis
Dumps secure recovery and archiving
EXPLAIN and ANALYZE show query paths
Roles and grants control data access

See also