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.
30 DAYS OF SQL - DAY1

30 DAYS OF SQL - DAY1

1
Comments
3 min read
EAV: a fascinating, but often dangerous pattern

EAV: a fascinating, but often dangerous pattern

1
Comments
2 min read
PostgreSql(Aggregative Functions)

PostgreSql(Aggregative Functions)

8
Comments
1 min read
PostgreSql - Relationships(joins)

PostgreSql - Relationships(joins)

8
Comments
2 min read
PostgreSQL-constraints

PostgreSQL-constraints

9
Comments
1 min read
PostgreSql(Filtering & Sorting)

PostgreSql(Filtering & Sorting)

8
Comments
1 min read
PostgreSQL(Alternations)

PostgreSQL(Alternations)

8
Comments
1 min read
postgreSQL - CRUD

postgreSQL - CRUD

10
Comments
2 min read
PostgreSQL vs MySQL in 2026: Why the Debate Is Already Over [Compared]

PostgreSQL vs MySQL in 2026: Why the Debate Is Already Over [Compared]

1
Comments
6 min read
Run WordPress on SQLite: A Zero-Server Local Development Revolution

Run WordPress on SQLite: A Zero-Server Local Development Revolution

2
Comments
3 min read
Code is the execution. Thinking is the strategy.

Code is the execution. Thinking is the strategy.

1
Comments
1 min read
8 MySQL security mistakes that expose your database to attackers

8 MySQL security mistakes that expose your database to attackers

Comments
9 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
Fix: MySQL "Shutdown Unexpectedly" Error in XAMPP (Restore Your Databases)

Fix: MySQL "Shutdown Unexpectedly" Error in XAMPP (Restore Your Databases)

2
Comments
3 min read
JSON Validator And Why MySQL 8.3's New Rules Matter

JSON Validator And Why MySQL 8.3's New Rules Matter

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