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.
Understanding and Inspecting Indexes in MySQL: A Comprehensive Guide

Understanding and Inspecting Indexes in MySQL: A Comprehensive Guide

5
Comments
8 min read
New in Releem: Live MySQL Process List for Instantly Spotting Long Queries

New in Releem: Live MySQL Process List for Instantly Spotting Long Queries

5
Comments
2 min read
Beginner’s Guide to Designing a Relational Database Schema

Beginner’s Guide to Designing a Relational Database Schema

13
Comments 5
4 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 vs MongoDB - Visual Design with Real Data Models

MySQL vs MongoDB - Visual Design with Real Data Models

11
Comments 2
5 min read
Master-Slave Replication and Read-Write Separation

Master-Slave Replication and Read-Write Separation

Comments 1
1 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
How to get Bitcoin data and save it in MySQL using Spring Boot

How to get Bitcoin data and save it in MySQL using Spring Boot

Comments 1
4 min read
MySQL Performance Optimization

MySQL Performance Optimization

1
Comments
10 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
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
Building a Secure Node.js REST API with JWT Auth and Role-Based Access Using MySQL

Building a Secure Node.js REST API with JWT Auth and Role-Based Access Using MySQL

1
Comments
3 min read
Architecture of Academialink: Full Stack Flow (Angular Spring Boot MySQL)

Architecture of Academialink: Full Stack Flow (Angular Spring Boot MySQL)

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

SQL vs. NoSQL | Schema Design Differences Explained Visually

13
Comments 2
5 min read
Lessons from the Trenches: Indexing a 200M Row Table in MySQL [MySQL part 2]

Lessons from the Trenches: Indexing a 200M Row Table in MySQL [MySQL part 2]

Comments
2 min read
SQL Server for NoSQL

SQL Server for NoSQL

Comments
1 min read
Best ETL Tools for MySQL: A Guide to Free and Paid Solutions

Best ETL Tools for MySQL: A Guide to Free and Paid Solutions

Comments
3 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
Deploying Microsoft SQL Server on Railway

Deploying Microsoft SQL Server on Railway

Comments
1 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
SQL Subqueries: Power Up Your Data Retrieval

SQL Subqueries: Power Up Your Data Retrieval

Comments
7 min read
MySQL Performance Optimization Pitfalls: 9 Common Mistakes and How to Avoid Them

MySQL Performance Optimization Pitfalls: 9 Common Mistakes and How to Avoid Them

Comments
9 min read
Rediscovering ACID – The Foundation of Reliable Databases

Rediscovering ACID – The Foundation of Reliable Databases

Comments
3 min read
Understanding MySQL Composite Indexes: Structure, Search Behavior, and Optimization Principles

Understanding MySQL Composite Indexes: Structure, Search Behavior, and Optimization Principles

Comments
5 min read
loading...