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.
Beyond Nested Queries: A Practical Guide to SQL Subquery Flattening

Beyond Nested Queries: A Practical Guide to SQL Subquery Flattening

Comments
5 min read
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
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.