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.
New to a Large Project? This Is How I Decode Complex Databases

New to a Large Project? This Is How I Decode Complex Databases

1
Comments
2 min read
Building a Multi-Container App using Docker

Building a Multi-Container App using Docker

2
Comments
2 min read
SARGable Condition Rewriting: Practical Solutions for Date Filtering Optimization

SARGable Condition Rewriting: Practical Solutions for Date Filtering Optimization

Comments
9 min read
PostgreSQL MVCC vs MySQL Key-Next Locking: How Transaction Isolation Affects Concurrency

PostgreSQL MVCC vs MySQL Key-Next Locking: How Transaction Isolation Affects Concurrency

Comments
4 min read
Beyond Nested Queries: A Practical Guide to SQL Subquery Flattening

Beyond Nested Queries: A Practical Guide to SQL Subquery Flattening

Comments
5 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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.