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

How to Find and Fix Slow MySQL Queries in Laravel

Comments 1
7 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
Relationships in a Relational Database: MySQL vs NebulaGraph from 1 Million to 500 Million Rows

Relationships in a Relational Database: MySQL vs NebulaGraph from 1 Million to 500 Million Rows

Comments
12 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.