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 Find and Fix Slow MySQL Queries in Laravel

How to Find and Fix Slow MySQL Queries in Laravel

Comments
7 min read
Instalando LEMP no Deepin 25: Nginx, MySQL, PHP 8.5 e Composer

Instalando LEMP no Deepin 25: Nginx, MySQL, PHP 8.5 e Composer

1
Comments 1
8 min read
The Day My "Index Optimization" Melted Our Database 🔥

The Day My "Index Optimization" Melted Our Database 🔥

Comments
9 min read
Automating MySQL Database Migrations in AWS CI/CD using Knex.js and TypeScript

Automating MySQL Database Migrations in AWS CI/CD using Knex.js and TypeScript

2
Comments
3 min read
Respaldo y recuperación de MySQL con Railway Aiven y GitHub Actions

Respaldo y recuperación de MySQL con Railway Aiven y GitHub Actions

1
Comments
10 min read
Laravel Migrations: Add Foreign Keys Without Locking

Laravel Migrations: Add Foreign Keys Without Locking

Comments
5 min read
SQL Server / MySQL / PostgreSQL — the index differences

SQL Server / MySQL / PostgreSQL — the index differences

Comments
2 min read
Demystifying ACID Transactions: How to Keep Your Database from Making a Mess

Demystifying ACID Transactions: How to Keep Your Database from Making a Mess

Comments
3 min read
Laravel Migrations: Add & Change Columns Without Downtime

Laravel Migrations: Add & Change Columns Without Downtime

Comments 1
8 min read
MySQL Connector/Python Fails to Close Pooled Sockets on App Termination: Solution Explored

MySQL Connector/Python Fails to Close Pooled Sockets on App Termination: Solution Explored

Comments
8 min read
Squashing Laravel Migrations: 5 Ways schema:dump --prune Bites a Real Team

Squashing Laravel Migrations: 5 Ways schema:dump --prune Bites a Real Team

1
Comments
8 min read
"Duplicate entry '0' for key PRIMARY" usually means your database lost AUTO_INCREMENT

"Duplicate entry '0' for key PRIMARY" usually means your database lost AUTO_INCREMENT

Comments
4 min read
PostgreSQL vs MySQL: 7 syntax differences that break migrations

PostgreSQL vs MySQL: 7 syntax differences that break migrations

Comments
4 min read
ROW_NUMBER vs RANK vs DENSE_RANK: one of them silently duplicates your Top-N

ROW_NUMBER vs RANK vs DENSE_RANK: one of them silently duplicates your Top-N

Comments
4 min read
The NOT IN trap: why your SQL query returns zero rows

The NOT IN trap: why your SQL query returns zero rows

Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.