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
Come estrarre una singola tabella da un file dump MySQL

Come estrarre una singola tabella da un file dump MySQL

Comments
1 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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.