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.
August 2025 At Releem - Recommendations Impact & Redundant Index Detection

August 2025 At Releem - Recommendations Impact & Redundant Index Detection

Comments
2 min read
Tesla Financial Analysis Dashboard using Python, SQL & Power BI

Tesla Financial Analysis Dashboard using Python, SQL & Power BI

Comments
1 min read
MySQL Views & Window Functions: Advanced Data Analysis Techniques

MySQL Views & Window Functions: Advanced Data Analysis Techniques

Comments
2 min read
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
8 min read
MySQL Lab: Building a University Information Query System with Database Views

MySQL Lab: Building a University Information Query System with Database Views

Comments
2 min read
Composite Indexes in MySQL

Composite Indexes in MySQL

Comments
1 min read
100 Days of DevOps: Day 18

100 Days of DevOps: Day 18

Comments
2 min read
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
Install and configure Zabbix 7 with Apache and MySQL for Ubuntu 24.04 LTS

Install and configure Zabbix 7 with Apache and MySQL for Ubuntu 24.04 LTS

Comments
3 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
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
Create ER Diagrams for MySQL with a Free Design Tool

Create ER Diagrams for MySQL with a Free Design Tool

6
Comments
4 min read
Simplifying SQL Date Data Types with Practical Tips

Simplifying SQL Date Data Types with Practical Tips

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