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.
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
Connection Strings for MySQL, PostgreSQL and Redis: A Practical Reference

Connection Strings for MySQL, PostgreSQL and Redis: A Practical Reference

Comments
3 min read
Upgrade MySQL 8.0 to 8.4: What Breaks and How to Check

Upgrade MySQL 8.0 to 8.4: What Breaks and How to Check

Comments
9 min read
Diagnosing "utf8mb3 is not supported" in .NET Framework apps

Diagnosing "utf8mb3 is not supported" in .NET Framework apps

Comments
4 min read
Getting Started with MOCO Part 4: Troubleshooting Failed MySQL Replicas

Getting Started with MOCO Part 4: Troubleshooting Failed MySQL Replicas

Comments
5 min read
From 1 Minute 56 Seconds to 3 Seconds: Optimizing Database Inserts with Batch Processing

From 1 Minute 56 Seconds to 3 Seconds: Optimizing Database Inserts with Batch Processing

Comments
2 min read
When the Disparate Must Become One: On Honest Distributed Systems

When the Disparate Must Become One: On Honest Distributed Systems

Comments
2 min read
Turning old Facebook Page posts into a dated build log in Laravel

Turning old Facebook Page posts into a dated build log in Laravel

Comments
7 min read
SaaS Backup & Disaster Recovery: RPO, RTO and PITR

SaaS Backup & Disaster Recovery: RPO, RTO and PITR

Comments
7 min read
CVE-2026-83404: Turning a Broad MySQL Exposure Count into a Defensible Response

CVE-2026-83404: Turning a Broad MySQL Exposure Count into a Defensible Response

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