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.
Why I, as Someone Who Likes MySQL, Now Want to Recommend PostgreSQL

Why I, as Someone Who Likes MySQL, Now Want to Recommend PostgreSQL

42
Comments 4
13 min read
How to Set Up Automated Database Backups on Linux (PostgreSQL and MySQL)

How to Set Up Automated Database Backups on Linux (PostgreSQL and MySQL)

Comments
2 min read
MongoDB vs MySQL: Choosing the Right Database for Your Project

MongoDB vs MySQL: Choosing the Right Database for Your Project

12
Comments 1
7 min read
mysh — A MySQL Connection Manager That Auto-Masks PII in Query Output

mysh — A MySQL Connection Manager That Auto-Masks PII in Query Output

Comments
5 min read
MySQL InnoDB Locking: The Silent Killer Behind Database Crashes

MySQL InnoDB Locking: The Silent Killer Behind Database Crashes

Comments 1
24 min read
MySQL Too many connections: How I Debugged It and Scaled the Connection Pool

MySQL Too many connections: How I Debugged It and Scaled the Connection Pool

3
Comments
9 min read
Missing Database Indexes Are Killing Your Page Speed

Missing Database Indexes Are Killing Your Page Speed

3
Comments
2 min read
Building a Hotjar-Class Analytics Platform in PHP: Heatmaps, Replays, Funnels, and Feedback

Building a Hotjar-Class Analytics Platform in PHP: Heatmaps, Replays, Funnels, and Feedback

3
Comments
4 min read
Connecting Power BI to a SQL Database:local & cloud option

Connecting Power BI to a SQL Database:local & cloud option

3
Comments
9 min read
From Stream to Database: Processing Market Data with Spring Boot, Redis, and Flyway

From Stream to Database: Processing Market Data with Spring Boot, Redis, and Flyway

Comments
3 min read
What’s New At Releem - January 2026

What’s New At Releem - January 2026

1
Comments
3 min read
From Image to Vector: Building Image Similarity Search with Python and MySQL

From Image to Vector: Building Image Similarity Search with Python and MySQL

1
Comments
10 min read
I Cut My Rails Hosting Costs by 70%: Migrating from Heroku to Railway

I Cut My Rails Hosting Costs by 70%: Migrating from Heroku to Railway

2
Comments
4 min read
5 MySQL InnoDB settings you should change right now

5 MySQL InnoDB settings you should change right now

1
Comments
5 min read
PostgreSql(Aggregative Functions)

PostgreSql(Aggregative Functions)

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