DEV Community

#mysql

Posts on tips and tricks, using and learning about MySQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Transactional DDL in PostgreSQL, MySQL and CockroachDB: Which Failed Migrations Roll Back?

Transactional DDL in PostgreSQL, MySQL and CockroachDB: Which Failed Migrations Roll Back?

Comments
10 min read
Receipt Archives: Object Storage or Managed Database Backups for SaaS Postgres/MySQL

Receipt Archives: Object Storage or Managed Database Backups for SaaS Postgres/MySQL

Comments
7 min read
# From Database Tables to Long-Term Memory with Hindsight

# From Database Tables to Long-Term Memory with Hindsight

Comments
8 min read
Laravel's Missing DB Connect Timeout: Four Attempts, Two Minutes

Laravel's Missing DB Connect Timeout: Four Attempts, Two Minutes

1
Comments
6 min read
Soft Deletes vs. Unique Constraints: The Duplicate SKU Bug That Hid for a Year

Soft Deletes vs. Unique Constraints: The Duplicate SKU Bug That Hid for a Year

Comments
6 min read
Back up MySQL and MariaDB to S3: from mysqldump to a verified restore

Back up MySQL and MariaDB to S3: from mysqldump to a verified restore

Comments
6 min read
The query that took too long

The query that took too long

Comments
7 min read
PostgreSQL vs MySQL en 2026 : versions, syntaxe, index et grille de choix

PostgreSQL vs MySQL en 2026 : versions, syntaxe, index et grille de choix

Comments
15 min read
How to Create a Production-Ready Dockerfile for Node.js Applications: A Step-by-Step Guide

How to Create a Production-Ready Dockerfile for Node.js Applications: A Step-by-Step Guide

Comments 1
7 min read
A PHP + MySQL attendance register: a weekend project for PHP training students

A PHP + MySQL attendance register: a weekend project for PHP training students

Comments
2 min read
SQL INNER JOIN vs LEFT JOIN vs RIGHT JOIN vs FULL OUTER JOIN: Differences With Examples (Tested in MySQL 8.4 and SQLite)

SQL INNER JOIN vs LEFT JOIN vs RIGHT JOIN vs FULL OUTER JOIN: Differences With Examples (Tested in MySQL 8.4 and SQLite)

Comments
12 min read
MySQL Too Many Connections (Error 1040): Causes and Fixes

MySQL Too Many Connections (Error 1040): Causes and Fixes

Comments
5 min read
Managed MySQL hosting compared: prices and backups in 2026

Managed MySQL hosting compared: prices and backups in 2026

1
Comments
10 min read
MySQL ALTER TABLE: Which Changes Lock the Table, and How to Make One Fail Instead of Copying

MySQL ALTER TABLE: Which Changes Lock the Table, and How to Make One Fail Instead of Copying

Comments
11 min read
Moving from MySQL to PostgreSQL: Building Flexible Search for the Next Phase of AI

Moving from MySQL to PostgreSQL: Building Flexible Search for the Next Phase of AI

Comments
6 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.