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 backup and restore — Complete guide to MySQL database backup strategies in 2026

MySQL backup and restore — Complete guide to MySQL database backup strategies in 2026

1
Comments 1
8 min read
Developing a PHP Project Across Windows and Mac on Your Home Network

Developing a PHP Project Across Windows and Mac on Your Home Network

Comments
2 min read
[Simple SNS Project] Step 3. Building the Follow System & Timeline (N:M Relationship)

[Simple SNS Project] Step 3. Building the Follow System & Timeline (N:M Relationship)

Comments
2 min read
🔐 How I Recovered My MySQL Root Password on Windows (MySQL 8.0) — Step by Step

🔐 How I Recovered My MySQL Root Password on Windows (MySQL 8.0) — Step by Step

1
Comments
2 min read
NodeJS 101 — Part 3 🗄️MySQL + Sequelize

NodeJS 101 — Part 3 🗄️MySQL + Sequelize

Comments
9 min read
Overview of Real-Time Data Synchronization from MySQL to VeloDB

Overview of Real-Time Data Synchronization from MySQL to VeloDB

5
Comments
5 min read
HackerRank 'The Pads' MySQL

HackerRank 'The Pads' MySQL

Comments
3 min read
MySQL Performance Tuning: From Slow Queries to Lightning-Fast Database

MySQL Performance Tuning: From Slow Queries to Lightning-Fast Database

5
Comments
5 min read
Deploying PHP Web Applications with Amazon EC2 and Aurora MySQL 📦

Deploying PHP Web Applications with Amazon EC2 and Aurora MySQL 📦

1
Comments
5 min read
A (very) Short Look at How MySQL Joins Work

A (very) Short Look at How MySQL Joins Work

2
Comments
2 min read
PostgreSQL vs MySQL vs MongoDB in 2026: The Honest Comparison Nobody Asked For

PostgreSQL vs MySQL vs MongoDB in 2026: The Honest Comparison Nobody Asked For

Comments
8 min read
MySQL SELECT … FOR UPDATE is causing a table lock during high traffic while generating sequential transaction IDs

MySQL SELECT … FOR UPDATE is causing a table lock during high traffic while generating sequential transaction IDs

1
Comments
1 min read
Stop Using NOT EXISTS? Unveiling the Optimization Secrets of LEFT JOIN Anti-Join

Stop Using NOT EXISTS? Unveiling the Optimization Secrets of LEFT JOIN Anti-Join

Comments
5 min read
I solved the local database problem, so I built a tool

I solved the local database problem, so I built a tool

Comments 3
3 min read
What's New At Releem - November 2025

What's New At Releem - November 2025

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