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.
How to Back Up and Restore MySQL Using mysqldump

How to Back Up and Restore MySQL Using mysqldump

Comments
2 min read
Day 4 Data Analytics Progress 📈

Day 4 Data Analytics Progress 📈

Comments
1 min read
Part 1: MySQL 8.0 Optimizer Enhancements - SQL Query Optimization Deep Dive

Part 1: MySQL 8.0 Optimizer Enhancements - SQL Query Optimization Deep Dive

Comments
12 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
MySQL Labs: Change Defaults, Add Constraints, Encrypt Passwords & Optimize Indexes

MySQL Labs: Change Defaults, Add Constraints, Encrypt Passwords & Optimize Indexes

Comments
2 min read
Filtering and Retrieving in SQL

Filtering and Retrieving in SQL

1
Comments 2
3 min read
Scaling Read Tracking with Redis Bitmaps

Scaling Read Tracking with Redis Bitmaps

5
Comments
2 min read
BaseDMS - An open-source, intelligent, AI-powered data management system based on browser

BaseDMS - An open-source, intelligent, AI-powered data management system based on browser

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

4
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 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
How to Delete a Foreign Key in SQL (Step-by-Step Guide)

How to Delete a Foreign Key in SQL (Step-by-Step Guide)

Comments
1 min read
Debug Smarter, Not Harder — Releem Now Shows EXPLAIN Plans and Query Examples for MySQL & MariaDB

Debug Smarter, Not Harder — Releem Now Shows EXPLAIN Plans and Query Examples for MySQL & MariaDB

Comments
2 min read
MyDrive - Personal File Manager

MyDrive - Personal File Manager

Comments
1 min read
🚀 Optimizing Costs Without Downtime: My Hands-On Experience Downgrading AWS Lightsail; A Step-by-Step Journey

🚀 Optimizing Costs Without Downtime: My Hands-On Experience Downgrading AWS Lightsail; A Step-by-Step Journey

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

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

2
Comments
3 min read
How I Built a Complete Invoice Management API with Spring Boot

How I Built a Complete Invoice Management API with Spring Boot

Comments
5 min read
Indexes in MySQL: How long do you wait before calling an index "unused"?

Indexes in MySQL: How long do you wait before calling an index "unused"?

5
Comments
1 min read
Hands-On MySQL Labs: CRUD, Constraints & Student Data Management

Hands-On MySQL Labs: CRUD, Constraints & Student Data Management

Comments
2 min read
Clean and Compare Strings in SQL with TRIM

Clean and Compare Strings in SQL with TRIM

Comments
2 min read
How to deploy phpMyAdmin with Docker Compose and Traefik in 5 Minutes

How to deploy phpMyAdmin with Docker Compose and Traefik in 5 Minutes

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

SQL Joins Explained - INNER, LEFT, RIGHT, FULL

7
Comments
3 min read
How to Solve MySQL and Redis Cache Inconsistency Like a Pro

How to Solve MySQL and Redis Cache Inconsistency Like a Pro

7
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
loading...