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.
Leetcode Hardest SQL 185: Is the Best Solution Still Slow?
rebooter_s profile

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

#leetcode #sql #mysql #postgressql
1
Comments
3 min read
How I Built a Complete Invoice Management API with Spring Boot
5026_mypatideepthi_9b6e44 profile

How I Built a Complete Invoice Management API with Spring Boot

#springboot #java #api #mysql
Comments
5 min read
HAVING Condition Pushdown: Optimizing Query Performance
rebooter_s profile

HAVING Condition Pushdown: Optimizing Query Performance

#mysql #sql
Comments
3 min read
Clean and Compare Strings in SQL with TRIM
dbvismarketing profile

Clean and Compare Strings in SQL with TRIM

#sql #mysql #trim
Comments
2 min read
How to deploy phpMyAdmin with Docker Compose and Traefik in 5 Minutes
satskoweb profile

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

#phpmyadmin #mysql #docker #traefik
Comments
2 min read
SQL Joins Explained - INNER, LEFT, RIGHT, FULL
roxana_haidiner profile

SQL Joins Explained - INNER, LEFT, RIGHT, FULL

#sql #database #mysql #postgres
7
Comments
3 min read
August 2025 At Releem - Recommendations Impact & Redundant Index Detection
drupaladmin profile

August 2025 At Releem - Recommendations Impact & Redundant Index Detection

#mysql #devops #database #webdev
Comments
2 min read
How to Solve MySQL and Redis Cache Inconsistency Like a Pro
xinjie_zou_d67d2805538130 profile

How to Solve MySQL and Redis Cache Inconsistency Like a Pro

#mysql #redis #backend #cacheconsistency
7
Comments
2 min read
Create MySQL ER Diagrams with a Free Design Tool
roxana_haidiner profile

Create MySQL ER Diagrams with a Free Design Tool

#sql #mysql #database #tooling
6
Comments
4 min read
Building a Simple SQL Parser in Python: From Basics to Hands-On
leapcell profile

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

#python #postgres #mysql #django
Comments 1
8 min read
Implementing Transactional Tests with MySQL
kamaev profile

Implementing Transactional Tests with MySQL

#node #mysql #testing #programming
Comments
6 min read
Automating MySQL Backups with Bash Script & Cron
tanjinsarker profile

Automating MySQL Backups with Bash Script & Cron

#bash #mysql #automation #devops
Comments
4 min read
MySQL Can Handle Most Things — Do You Really Need PostgreSQL or Oracle? 🤔💾
xinjie_zou_d67d2805538130 profile

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

#webdev #frontend #mysql #devops
5
Comments 1
3 min read
🛠️ Deploying a LAMP Stack on AWS EC2 (Ubuntu 24.04 LTS) — A DevOps Implementation Guide
princemaxi profile

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

#linux #aws #mysql #php
1
Comments
10 min read
What is Error Code 1451 in MySQL
sanjay_kumar_f68c88b70eaf profile

What is Error Code 1451 in MySQL

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