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.
August 2025 At Releem - Recommendations Impact & Redundant Index Detection
Cover image for 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
Cover image for 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
Cover image for 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
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
8 min read
MySQL Lab: Building a University Information Query System with Database Views
Cover image for 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
Cover image for 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
Cover image for 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
Cover image for 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
Cover image for 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
Cover image for 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
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 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
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
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
loading...