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.
Scaling Read Tracking with Redis Bitmaps

Scaling Read Tracking with Redis Bitmaps

5
Comments
2 min read
Eliminating Lost Update Anomalies in Spring Boot with Redlock and Custom AOP

Eliminating Lost Update Anomalies in Spring Boot with Redlock and Custom AOP

1
Comments
3 min read
Simplifying SQL Date Data Types with Practical Tips

Simplifying SQL Date Data Types with Practical Tips

Comments
1 min read
How to Connect React with MySQL (Step by Step Guide)

How to Connect React with MySQL (Step by Step Guide)

Comments
2 min read
How We Reimagined SQL Query Building to Be Smarter, Safer, and Simpler (Introducing `mysql2-dx` v1.1.0)

How We Reimagined SQL Query Building to Be Smarter, Safer, and Simpler (Introducing `mysql2-dx` v1.1.0)

4
Comments
3 min read
Stored Procedures: Organization and Code Quality in SQL

Stored Procedures: Organization and Code Quality in SQL

Comments
2 min read
Is Cloud SQL Enterprise Plus Worth It? Evaluating the MySQL upgrade at SpareRoom

Is Cloud SQL Enterprise Plus Worth It? Evaluating the MySQL upgrade at SpareRoom

2
Comments
4 min read
Leetcode Hardest SQL 185: Is the Best Solution Still Slow?

Leetcode Hardest SQL 185: Is the Best Solution Still Slow?

1
Comments
3 min read
HAVING Condition Pushdown: Optimizing Query Performance

HAVING Condition Pushdown: Optimizing Query Performance

Comments
3 min read
SQL Joins Explained - INNER, LEFT, RIGHT, FULL

SQL Joins Explained - INNER, LEFT, RIGHT, FULL

7
Comments
3 min read
August 2025 At Releem - Recommendations Impact & Redundant Index Detection

August 2025 At Releem - Recommendations Impact & Redundant Index Detection

Comments
2 min read
Create MySQL ER Diagrams with a Free Design Tool

Create MySQL ER Diagrams with a Free Design Tool

6
Comments
4 min read
Automating MySQL Backups with Bash Script & Cron

Automating MySQL Backups with Bash Script & Cron

Comments
4 min read
MySQL Can Handle Most Things — Do You Really Need PostgreSQL or Oracle? 🤔💾

MySQL Can Handle Most Things — Do You Really Need PostgreSQL or Oracle? 🤔💾

5
Comments 1
3 min read
🛠️ Deploying a LAMP Stack on AWS EC2 (Ubuntu 24.04 LTS) — A DevOps Implementation Guide

🛠️ Deploying a LAMP Stack on AWS EC2 (Ubuntu 24.04 LTS) — A DevOps Implementation Guide

1
Comments
10 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.