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.
Beginner’s Guide to Designing a Relational Database Schema

Beginner’s Guide to Designing a Relational Database Schema

13
Comments 5
4 min read
Best MySQL Database Design Tools in 2025

Best MySQL Database Design Tools in 2025

11
Comments 2
8 min read
Comprehensive Guide to MySQL Full-Text Indexing: Examples, Creation, and Performance Optimization

Comprehensive Guide to MySQL Full-Text Indexing: Examples, Creation, and Performance Optimization

1
Comments
8 min read
How to Implement Mixed Computations Between Oracle and MySQL with esProc

How to Implement Mixed Computations Between Oracle and MySQL with esProc

6
Comments 2
4 min read
Postgres 🐘 vs. MySQL 🐬: DDL Transaction Difference

Postgres 🐘 vs. MySQL 🐬: DDL Transaction Difference

5
Comments 1
4 min read
Understanding and Inspecting Indexes in MySQL: A Comprehensive Guide

Understanding and Inspecting Indexes in MySQL: A Comprehensive Guide

5
Comments
8 min read
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
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
👋 Sign in for the ability to sort posts by relevant, latest, or top.