Forem

# 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.
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
Cover image for 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
Cover image for 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
Cover image for 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
Cover image for MySQL Performance Optimization

MySQL Performance Optimization

1
Comments
10 min read
How to Load Data From MySQL to Iceberg in Real Time
Cover image for 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 🐘
Cover image for 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
Cover image for MySQL Timeout 🐬⏰ Explained

MySQL Timeout 🐬⏰ Explained

5
Comments
5 min read
SQL vs. NoSQL | Schema Design Differences Explained Visually
Cover image for 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
Cover image for 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
Cover image for 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
Cover image for 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 😻
Cover image for Features I Wish MySQL Had but Postgres 🐘 Already Has 😻

Features I Wish MySQL Had but Postgres 🐘 Already Has 😻

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