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.
The Best Tools to Design Database Schemas Visually in 2025

The Best Tools to Design Database Schemas Visually in 2025

10
Comments 3
7 min read
MySQL Performance Optimization

MySQL Performance Optimization

1
Comments
10 min read
How to Load Data From MySQL to Iceberg in Real Time

How to Load Data From MySQL to Iceberg in Real Time

1
Comments
5 min read
PlanetScale vs. ⚔ Neon: the Continued Saga between MySQL 🐬 and PostgreSQL 🐘

PlanetScale vs. ⚔ Neon: the Continued Saga between MySQL 🐬 and PostgreSQL 🐘

6
Comments
9 min read
MySQL Timeout 🐬⏰ Explained

MySQL Timeout 🐬⏰ Explained

5
Comments
5 min read
SQL vs. NoSQL | Schema Design Differences Explained Visually

SQL vs. NoSQL | Schema Design Differences Explained Visually

13
Comments 2
5 min read
SQL And PHP: People whose birthday is today

SQL And PHP: People whose birthday is today

Comments
1 min read
Do You Use SELECT * or Explicit Columns in Production Queries?

Do You Use SELECT * or Explicit Columns in Production Queries?

5
Comments 8
1 min read
Mastering Index Creation in MySQL: Practical Examples, Workbench Tips, and Performance Optimization

Mastering Index Creation in MySQL: Practical Examples, Workbench Tips, and Performance Optimization

5
Comments
7 min read
SQL Joins Demystified: LEFT, RIGHT, INNER, FULL Explained with Tables

SQL Joins Demystified: LEFT, RIGHT, INNER, FULL Explained with Tables

1
Comments
4 min read
Supercharge Your Laravel App with Highly Optimized Eloquent Queries

Supercharge Your Laravel App with Highly Optimized Eloquent Queries

6
Comments 2
2 min read
Features I Wish MySQL Had but Postgres 🐘 Already Has 😻

Features I Wish MySQL Had but Postgres 🐘 Already Has 😻

5
Comments 2
5 min read
How to Create a New MySQL User and Grant All Permissions

How to Create a New MySQL User and Grant All Permissions

Comments
2 min read
How to use EXPLAIN to fix slow queries in MySQL

How to use EXPLAIN to fix slow queries in MySQL

8
Comments 1
6 min read
Can PostgreSQL Be a Search Engine? Yes, You Might Not Need Elasticsearch

Can PostgreSQL Be a Search Engine? Yes, You Might Not Need Elasticsearch

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