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.
Postgres vs. MySQL: DDL Transaction Difference
op3ratordec profile

Postgres vs. MySQL: DDL Transaction Difference

#postgres #mysql #sql #database
5
Comments 1
4 min read
Understanding and Inspecting Indexes in MySQL: A Comprehensive Guide
drupaladmin profile

Understanding and Inspecting Indexes in MySQL: A Comprehensive Guide

#database #devops #mysql #webdev
5
Comments
8 min read
New in Releem: Live MySQL Process List for Instantly Spotting Long Queries
drupaladmin profile

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

#database #devops #mysql #webdev
5
Comments
2 min read
The Best Tools to Design Database Schemas Visually in 2025
roxana_haidiner profile

The Best Tools to Design Database Schemas Visually in 2025

#database #sql #mysql #postgres
10
Comments 3
7 min read
Master-Slave Replication and Read-Write Separation
woodyxin profile

Master-Slave Replication and Read-Write Separation

#mysql
Comments 1
1 min read
🚀 Supercharge Your Laravel App with Highly Optimized Eloquent Queries
tahsin000 profile

🚀 Supercharge Your Laravel App with Highly Optimized Eloquent Queries

#laravel #performance #eloquent #mysql
6
Comments 2
2 min read
How to get Bitcoin data and save it in MySQL using Spring Boot
shelner profile

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

#bitcoin #mysql #springboot
Comments 1
4 min read
Can simple 4 Core, 16 GB RAM reach 1000 tps?
djinn profile

Can simple 4 Core, 16 GB RAM reach 1000 tps?

#mysql #devops #kubernetes #webdev
Comments
9 min read
PlanetScale vs. ⚔ Neon: the Continued Saga between MySQL 🐬 and PostgreSQL 🐘
op3ratordec profile

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

#sql #mysql #postgres #database
6
Comments
9 min read
MySQL Timeout 🐬⏰ Explained
op3ratordec profile

MySQL Timeout 🐬⏰ Explained

#mysql #database #sql #learning
5
Comments
5 min read
How to Implement Mixed Computations Between Oracle and MySQL with esProc
esproc_spl profile
Judy

How to Implement Mixed Computations Between Oracle and MySQL with esProc

#mysql #oracle #devops #esproc
6
Comments 2
4 min read
Building a Secure Node.js REST API with JWT Auth and Role-Based Access Using MySQL
vdelitz profile

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

#jwt #mysql #webdev #node
1
Comments
3 min read
🚚 One-Time MySQL to PostgreSQL Migration with pgloader + Docker (Windows-Friendly)
capwellmurimi profile

🚚 One-Time MySQL to PostgreSQL Migration with pgloader + Docker (Windows-Friendly)

#docker #database #mysql #postgres
10
Comments 2
2 min read
Architecture of Academialink: Full Stack Flow (Angular Spring Boot MySQL)
aryan_karpe_aee2efca6e002 profile

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

#fullstack #angular #springboot #mysql
Comments
2 min read
SQL vs. NoSQL | Schema Design Differences Explained Visually
roxana_haidiner profile

SQL vs. NoSQL | Schema Design Differences Explained Visually

#sql #nosql #database #mysql
13
Comments 2
5 min read
Lessons from the Trenches: Indexing a 200M Row Table in MySQL [MySQL part 2]
thefreepeak profile

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

#mysql #indexing #devjournal #learning
Comments
2 min read
SQL Server for NoSQL
hasanmonsur profile

SQL Server for NoSQL

#sql #nosql #mysql #webdev
Comments
1 min read
Best ETL Tools for MySQL: A Guide to Free and Paid Solutions
kuznetsova profile
Nata

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

#etl #data #mysql
Comments
3 min read
Do You Use SELECT * or Explicit Columns in Production Queries?
codeliner profile

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

#discuss #mysql #webdev #database
7
Comments 8
1 min read
Deploying Microsoft SQL Server on Railway
realtalks profile

Deploying Microsoft SQL Server on Railway

#database #mysql #cloud #railway
Comments
1 min read
SQL Joins Demystified: LEFT, RIGHT, INNER, FULL Explained with Tables
crit3cal profile

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

#mysql #database #tutorial #webdev
1
Comments
4 min read
MySQL Performance Optimization Pitfalls: 9 Common Mistakes and How to Avoid Them
drupaladmin profile

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

#mysql #database #devops #webdev
Comments
9 min read
Rediscovering ACID – The Foundation of Reliable Databases
mandarg13 profile

Rediscovering ACID – The Foundation of Reliable Databases

#sql #database #postgres #mysql
Comments
3 min read
Understanding MySQL Composite Indexes: Structure, Search Behavior, and Optimization Principles
jing_li profile
Jing for Chat2DB

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

#mysql #database #ai
Comments
5 min read
What’s Really Running in MySQL? Use SHOW PROCESSLIST to Find Out
drupaladmin profile

What’s Really Running in MySQL? Use SHOW PROCESSLIST to Find Out

#database #devops #mysql #webdev
1
Comments
2 min read
loading...