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.
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
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
MySQL, PostgreSQL e SQLite: quando usar cada um (sem dogma)

MySQL, PostgreSQL e SQLite: quando usar cada um (sem dogma)

Comments
2 min read
Setup Nginx and MySQL with Vagrant

Setup Nginx and MySQL with Vagrant

Comments
5 min read
OpenAI's testament to Postgresql reliability

OpenAI's testament to Postgresql reliability

Comments
7 min read
AWS Disk Full? Why Deleting Logs Might Kill Your Database (And How to Fix It)

AWS Disk Full? Why Deleting Logs Might Kill Your Database (And How to Fix It)

Comments
3 min read
Does Apache SeaTunnel MySQL CDC Support Timestamp-Based Startup?

Does Apache SeaTunnel MySQL CDC Support Timestamp-Based Startup?

Comments
4 min read
Releem 2025 Recap: Building a Database Advisor for Developer Teams

Releem 2025 Recap: Building a Database Advisor for Developer Teams

5
Comments
2 min read
Beyond Surrogate Pairs: Hidden Pitfalls in JS Character Counting with PHP/MySQL

Beyond Surrogate Pairs: Hidden Pitfalls in JS Character Counting with PHP/MySQL

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