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.
Flyway Migration: From Legacy Database to CI/CD

Flyway Migration: From Legacy Database to CI/CD

1
Comments
3 min read
MySQL vs PostgreSQL in 2026: An Honest Answer After Running Both

MySQL vs PostgreSQL in 2026: An Honest Answer After Running Both

Comments
3 min read
Does AbortSignal Cancel a Node.js Database Query? 4 Drivers Tested

Pool starvation risks revealed across drivers

Does AbortSignal Cancel a Node.js Database Query? 4 Drivers Tested

26
Picked as gem Comments 11
19 min read
Laravel DB::olap() on PlanetScale: When I'd Still Chunk

Laravel DB::olap() on PlanetScale: When I'd Still Chunk

Comments
7 min read
How to Auto-Update an updated_at Column: MySQL ON UPDATE vs a Database Trigger vs the ORM

How to Auto-Update an updated_at Column: MySQL ON UPDATE vs a Database Trigger vs the ORM

Comments
10 min read
Three Docker Compose health checks that say "healthy" too early (tested on Docker 29)

Three Docker Compose health checks that say "healthy" too early (tested on Docker 29)

Comments 1
4 min read
Readyset HA with ProxySQL and MySQL

Readyset HA with ProxySQL and MySQL

Comments
12 min read
My PHP + MySQL Stack for Small Business Software in 2026

My PHP + MySQL Stack for Small Business Software in 2026

Comments
3 min read
Amigose Overseas Education CRM & Student Portal — Architectural Case Study

Amigose Overseas Education CRM & Student Portal — Architectural Case Study

Comments
2 min read
GEAMS (Genesys Employee Appraisal Management System) — Architectural Case Study

GEAMS (Genesys Employee Appraisal Management System) — Architectural Case Study

Comments
1 min read
Round-Tripping Invoice Ninja and Sylius Through a Database Diagram: What MySQL Lost and What We Fixed

Round-Tripping Invoice Ninja and Sylius Through a Database Diagram: What MySQL Lost and What We Fixed

Comments
15 min read
schemagate tops BIRD Mini-Dev in SQLite, PostgreSQL and MySQL

schemagate tops BIRD Mini-Dev in SQLite, PostgreSQL and MySQL

Comments
2 min read
wp_postmeta Has No Index on meta_value — And That Missing Index Is Why Your WooCommerce Store Crawls

wp_postmeta Has No Index on meta_value — And That Missing Index Is Why Your WooCommerce Store Crawls

Comments
2 min read
AI DBA on Bare Metal: Slow Log In, Diagnosis + Fix SQL Out (Data Never Leaves Your Network)

Hacktoberfest Open-Source AI Challenge Week 2: Side Hustle Submission đź’¸

AI DBA on Bare Metal: Slow Log In, Diagnosis + Fix SQL Out (Data Never Leaves Your Network)

Comments
4 min read
Laravel Query Optimization: 4 Simple Fixes for Faster Apps

Laravel Query Optimization: 4 Simple Fixes for Faster Apps

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