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.
I Lost a Client's Database on a $5 VPS. Here's the 12-Line Script That Would Have Saved It.

I Lost a Client's Database on a $5 VPS. Here's the 12-Line Script That Would Have Saved It.

5
Comments 2
3 min read
Stop Guessing in Controllers: Debug MySQL Directly

Stop Guessing in Controllers: Debug MySQL Directly

5
Comments
9 min read
Database Optimization Strategies That Cut Query Execution Time by 60%: A Practical Guide

Database Optimization Strategies That Cut Query Execution Time by 60%: A Practical Guide

1
Comments
9 min read
Managing MySQL Users and Roles as Code: Selecting the Right Terraform Provider

Managing MySQL Users and Roles as Code: Selecting the Right Terraform Provider

Comments
10 min read
Why I Built My Own MySQL Client for macOS (SQL Gnome)

Why I Built My Own MySQL Client for macOS (SQL Gnome)

Comments 1
3 min read
How we tracked down a mysterious latency issue in our AWS Lambda + RDS Proxy stack, and discovered Prisma was the culprit all along.

How we tracked down a mysterious latency issue in our AWS Lambda + RDS Proxy stack, and discovered Prisma was the culprit all along.

5
Comments
7 min read
I built a database backup tool where even I can't read your backups

I built a database backup tool where even I can't read your backups

Comments
2 min read
🌙 Late Night Chronicles: #5 Your First MySQL Commands 🚀

🌙 Late Night Chronicles: #5 Your First MySQL Commands 🚀

Comments
2 min read
Installing the LEMP Stack on Ubuntu 26.04

Installing the LEMP Stack on Ubuntu 26.04

9
Comments
3 min read
I spent 4 years building a production PHP system. Then I turned the framework into a product.

I spent 4 years building a production PHP system. Then I turned the framework into a product.

Comments
2 min read
Late Night Chronicles: #3 Diving into MYSQL

Late Night Chronicles: #3 Diving into MYSQL

Comments
2 min read
🌙 Late Night Chronicles: #4 Understanding MySQL Data Types

🌙 Late Night Chronicles: #4 Understanding MySQL Data Types

Comments
2 min read
Why I Built PureMyHA: A Lightweight MySQL 8.4 HA Manager in Haskell

Why I Built PureMyHA: A Lightweight MySQL 8.4 HA Manager in Haskell

Comments
10 min read
Which Database Should You Self-Host? SQLite vs MySQL vs PostgreSQL vs Redis

Which Database Should You Self-Host? SQLite vs MySQL vs PostgreSQL vs Redis

Comments
3 min read
Database Performance Optimization: A Practical Content Strategy for Engineering Teams

Database Performance Optimization: A Practical Content Strategy for Engineering Teams

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