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.
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
PHP PDO Prepared Statements for Beginners

PHP PDO Prepared Statements for Beginners

Comments
8 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
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
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
Database Concurrency 101: Optimistic vs. Pessimistic Locking

Database Concurrency 101: Optimistic vs. Pessimistic Locking

Comments
3 min read
How I Structured a Java Library Management System with DAO and Service Layers

How I Structured a Java Library Management System with DAO and Service Layers

Comments
8 min read
How I Built a Java Hotel Reservation System with JDBC and MySQL

How I Built a Java Hotel Reservation System with JDBC and MySQL

Comments
9 min read
WHMCS 9.0: check your custom reports for double-counting

WHMCS 9.0: check your custom reports for double-counting

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