Forem

# 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.
Filtering and Retrieving in SQL

Filtering and Retrieving in SQL

1
Comments 2
3 min read
SQL Rewriting vs. Indexing: How AI-Powered Structural Optimization Achieves 20x Scalability Gains
Cover image for SQL Rewriting vs. Indexing: How AI-Powered Structural Optimization Achieves 20x Scalability Gains

SQL Rewriting vs. Indexing: How AI-Powered Structural Optimization Achieves 20x Scalability Gains

1
Comments 1
14 min read
Scaling Read Tracking with Redis Bitmaps
Cover image for 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

1
Comments
3 min read
Simplifying SQL Date Data Types with Practical Tips
Cover image for 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)
Cover image for 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
Cover image for 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)
Cover image for 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
Cover image for 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
Cover image for 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
Cover image for 🚀 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
Is Cloud SQL Enterprise Plus Worth It? Evaluating the MySQL upgrade at SpareRoom
Cover image for 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?
Cover image for 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
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
HAVING Condition Pushdown: Optimizing Query Performance
Cover image for HAVING Condition Pushdown: Optimizing Query Performance

HAVING Condition Pushdown: Optimizing Query Performance

Comments
3 min read
Hands-On MySQL Labs: CRUD, Constraints & Student Data Management
Cover image for 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
Cover image for 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
Cover image for 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
Cover image for Create MySQL ER Diagrams with a Free Design Tool

Create MySQL ER Diagrams with a Free Design Tool

6
Comments
4 min read
Building a Simple SQL Parser in Python: From Basics to Hands-On
Cover image for Building a Simple SQL Parser in Python: From Basics to Hands-On

Building a Simple SQL Parser in Python: From Basics to Hands-On

Comments 1
8 min read
loading...