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.
The Marie Kondo Method for MySQL: A Data Lifecycle Story

The Marie Kondo Method for MySQL: A Data Lifecycle Story

Comments
6 min read
Code is the execution. Thinking is the strategy.

Code is the execution. Thinking is the strategy.

1
Comments
1 min read
8 MySQL security mistakes that expose your database to attackers

8 MySQL security mistakes that expose your database to attackers

Comments
9 min read
Cloud SQL Enterprise Plus for Developers- Online Webinar

Cloud SQL Enterprise Plus for Developers- Online Webinar

Comments
1 min read
MariaDB vs MySQL — 8 reasons developers are switching in 2026

MariaDB vs MySQL — 8 reasons developers are switching in 2026

Comments
7 min read
JSON Validator And Why MySQL 8.3's New Rules Matter

JSON Validator And Why MySQL 8.3's New Rules Matter

1
Comments
6 min read
MySQL vs PostgreSQL in 2026 — 7 key differences you should know before choosing

MySQL vs PostgreSQL in 2026 — 7 key differences you should know before choosing

Comments
7 min read
The Silent Connection Killer: MySQL2 and AWS Lambda's Freeze/Thaw Problem

The Silent Connection Killer: MySQL2 and AWS Lambda's Freeze/Thaw Problem

Comments
3 min read
What is MySQL's Optimizer Trace? Why is it Essential for SQL Optimization?

What is MySQL's Optimizer Trace? Why is it Essential for SQL Optimization?

1
Comments
4 min read
MySQL 8.0 vs 9.0: The Upgrade That Almost Broke Production

MySQL 8.0 vs 9.0: The Upgrade That Almost Broke Production

2
Comments
4 min read
20 Essential MySQL Optimization Tips for Better Database

20 Essential MySQL Optimization Tips for Better Database

Comments
5 min read
How to Create Indexes in MySQL: A Complete Guide

How to Create Indexes in MySQL: A Complete Guide

Comments
5 min read
MySQL backup to cloud — Backing up MySQL databases to AWS S3 and Google Cloud

MySQL backup to cloud — Backing up MySQL databases to AWS S3 and Google Cloud

Comments
8 min read
myanon — how I anonymize 200GB of MySQL nightly for GDPR-safe dev

myanon — how I anonymize 200GB of MySQL nightly for GDPR-safe dev

Comments
1 min read
Stop hand-writing INSERTs: JSON SQL with dialect-aware output(Postgres/MySQL/SQLite)

Stop hand-writing INSERTs: JSON SQL with dialect-aware output(Postgres/MySQL/SQLite)

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