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.
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
What’s Really Running in MySQL? Use SHOW PROCESSLIST to Find Out

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

1
Comments
2 min read
DiseΓ±o de un sistema de gestiΓ³n de informaciΓ³n del control de acceso para la biblioteca de mi universidad

DiseΓ±o de un sistema de gestiΓ³n de informaciΓ³n del control de acceso para la biblioteca de mi universidad

Comments
11 min read
🧨 The Hotel California of Managed Services: How DigitalOcean Trapped My 800GB Database

🧨 The Hotel California of Managed Services: How DigitalOcean Trapped My 800GB Database

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

Features I Wish MySQL Had but Postgres 🐘 Already Has 😻

6
Comments 2
5 min read
How to Connect a PHP Script to MySQL: A Step-by-Step Guide

How to Connect a PHP Script to MySQL: A Step-by-Step Guide

Comments
4 min read
Top 5 Alternative Data Career Paths (And How to Learn Each for Free)

Top 5 Alternative Data Career Paths (And How to Learn Each for Free)

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

How to use EXPLAIN to fix slow queries in MySQL

8
Comments
6 min read
SQLife - a new Oracle/PostgreSQL/MySQL Client

SQLife - a new Oracle/PostgreSQL/MySQL Client

1
Comments
2 min read
🧩 Questions about general web development. (Share your knowledge)

🧩 Questions about general web development. (Share your knowledge)

1
Comments
1 min read
loading...
close