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
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

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
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 😻

Features I Wish MySQL Had but Postgres 🐘 Already Has 😻

5
Comments 2
5 min read
How to Create a New MySQL User and Grant All Permissions

How to Create a New MySQL User and Grant All Permissions

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

How to use EXPLAIN to fix slow queries in MySQL

8
Comments 1
6 min read
SQLife - a new client for Oracle, PostgreSQL, MySQL, SQLServer and more databases.

SQLife - a new client for Oracle, PostgreSQL, MySQL, SQLServer and more databases.

1
Comments
3 min read
Can PostgreSQL Be a Search Engine? Yes, You Might Not Need Elasticsearch

Can PostgreSQL Be a Search Engine? Yes, You Might Not Need Elasticsearch

6
Comments
10 min read
Indexing in MySQL for PHP Developers: Do’s and Don’ts

Indexing in MySQL for PHP Developers: Do’s and Don’ts

1
Comments
6 min read
Powering Up PolyDisease Predictor: Backend Integration and Expanding Horizons! 🚀

Powering Up PolyDisease Predictor: Backend Integration and Expanding Horizons! 🚀

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