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.
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
🚀 Auto-Generate Sequelize Models and Migrations with StackRender

🚀 Auto-Generate Sequelize Models and Migrations with StackRender

4
Comments 1
2 min read
Three practical ways to create a database in MySQL

Three practical ways to create a database in MySQL

Comments
2 min read
The Power of MySQL Indexes: A Comprehensive Guide Part 1

The Power of MySQL Indexes: A Comprehensive Guide Part 1

Comments
3 min read
PawSQL for Jetbrains - Optimize your SQL Queries within Jetbrains IDEs

PawSQL for Jetbrains - Optimize your SQL Queries within Jetbrains IDEs

Comments
1 min read
Setting Up MySQL and MongoDB Together in Laravel 12

Setting Up MySQL and MongoDB Together in Laravel 12

4
Comments 1
2 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
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
🧩 Questions about general web development. (Share your knowledge)

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

1
Comments
1 min read
SQL Fundamentals for Beginners

SQL Fundamentals for Beginners

Comments
4 min read
Health Check for MySQL in a Docker Container

Health Check for MySQL in a Docker Container

Comments
2 min read
Multiversion Concurrency Control (MVCC) – A Deep Dive Part (1/2)

Multiversion Concurrency Control (MVCC) – A Deep Dive Part (1/2)

1
Comments
3 min read
Understanding numeric types in Laravel migration schemas: Integer, Float, Decimal, Double

Understanding numeric types in Laravel migration schemas: Integer, Float, Decimal, Double

Comments
1 min read
Duplicate Rows Detection in MySQL

Duplicate Rows Detection in MySQL

5
Comments
4 min read
Tired of writing repetitive MySQL code in Node.js? Here’s a simple helper I built! - mysql2-helper-lite

Tired of writing repetitive MySQL code in Node.js? Here’s a simple helper I built! - mysql2-helper-lite

Comments
1 min read
Think Twice Before Migrating Between PostgreSQL and MySQL

Think Twice Before Migrating Between PostgreSQL and MySQL

Comments
4 min read
Top 10 MySQL Monitoring Tools

Top 10 MySQL Monitoring Tools

Comments
10 min read
Simplify Eloquent Query Filtering in Laravel with Eloquent Filter

Simplify Eloquent Query Filtering in Laravel with Eloquent Filter

1
Comments
5 min read
AWS Cloud — RDS Upgrade MySQL from Version 5.7 to 8.x.x

AWS Cloud — RDS Upgrade MySQL from Version 5.7 to 8.x.x

Comments
3 min read
Building a Full-Stack CRUD Application with Express.js, MySQL, and Sequelize

Building a Full-Stack CRUD Application with Express.js, MySQL, and Sequelize

1
Comments
4 min read
InnoDB Indexs

InnoDB Indexs

Comments
5 min read
Data Pipeline Tutorial: Synchronizing from MySQL to PostgreSQL Based on Apache SeaTunnel

Data Pipeline Tutorial: Synchronizing from MySQL to PostgreSQL Based on Apache SeaTunnel

Comments
7 min read
SUBSTRING_INDEX in MySQL: A Simple Guide to String Extraction

SUBSTRING_INDEX in MySQL: A Simple Guide to String Extraction

Comments
2 min read
How to build Dashboards from MySQL data

How to build Dashboards from MySQL data

Comments
3 min read
Database Indexes: Why and How?

Database Indexes: Why and How?

Comments
3 min read
loading...