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.
Optimizing Sorting and Filtering on JSON Columns in Laravel with Indexed Virtual Columns

Optimizing Sorting and Filtering on JSON Columns in Laravel with Indexed Virtual Columns

Comments
5 min read
Dicas de SQL para Iniciantes: Consultando Proprietários de Animais de Estimação (Joins)

Dicas de SQL para Iniciantes: Consultando Proprietários de Animais de Estimação (Joins)

Comments 2
7 min read
📂 Building a Simple File Management System with PHP & MySQL 🚀

📂 Building a Simple File Management System with PHP & MySQL 🚀

15
Comments
3 min read
Query Optimization in MySQL: Optimizing Top Queries vs. Slow Queries

Query Optimization in MySQL: Optimizing Top Queries vs. Slow Queries

9
Comments
4 min read
⚡ 🚀 Quickly Start Dev Environment For MySQL, PostgreSQL, MongoDB, Redis, and Kafka Using Docker Compose 🔥

⚡ 🚀 Quickly Start Dev Environment For MySQL, PostgreSQL, MongoDB, Redis, and Kafka Using Docker Compose 🔥

10
Comments
10 min read
What Is a NoSQL Database and When Should You Use It?

What Is a NoSQL Database and When Should You Use It?

7
Comments 4
6 min read
mysql: “thai food near me”, or: doing geo distance calculations in your database.

mysql: “thai food near me”, or: doing geo distance calculations in your database.

1
Comments
13 min read
🔥Must Notes When Using Open Sources 🧩

🔥Must Notes When Using Open Sources 🧩

2
Comments
4 min read
Adding a Serial ID to MySQL Tables Based on Creation Date: A Step-by-Step Guide

Adding a Serial ID to MySQL Tables Based on Creation Date: A Step-by-Step Guide

1
Comments
3 min read
Mastering MySQL Performance: What It MySQL Latency and Why It Matters

Mastering MySQL Performance: What It MySQL Latency and Why It Matters

Comments
4 min read
🛠️ DB Migration For Golang Services, Why it matters? 🐹

🛠️ DB Migration For Golang Services, Why it matters? 🐹

2
Comments
8 min read
Migrating to Amazon RDS

Migrating to Amazon RDS

5
Comments
6 min read
Simple Ways to Identify the MySQL Port

Simple Ways to Identify the MySQL Port

2
Comments
2 min read
Enhance Your SQL Skills: 'Project - Modify Primary Key of Countrylanguage Table'

Enhance Your SQL Skills: 'Project - Modify Primary Key of Countrylanguage Table'

Comments
3 min read
Unlocking speed: the power of indexing in database performance

Unlocking speed: the power of indexing in database performance

4
Comments
4 min read
Mastering MySQL Performance: A Guide to Slow Query Monitoring

Mastering MySQL Performance: A Guide to Slow Query Monitoring

Comments
4 min read
Upsert a row in a DB that doesn't use primary keys or unique constraints

Upsert a row in a DB that doesn't use primary keys or unique constraints

2
Comments
3 min read
MySQL Terminal: Create Databases, Tables and more.

MySQL Terminal: Create Databases, Tables and more.

Comments
3 min read
Unlock the Power of Stored Procedures and Cursors: A Project-Based Course on Database Retrieval

Unlock the Power of Stored Procedures and Cursors: A Project-Based Course on Database Retrieval

Comments
2 min read
How to FIX: Error: MySQL shutdown unexpectedly

How to FIX: Error: MySQL shutdown unexpectedly

2
Comments 1
1 min read
🧪 GOLANG INTEGRATION TEST WITH GIN, GORM, TESTIFY, MYSQL

🧪 GOLANG INTEGRATION TEST WITH GIN, GORM, TESTIFY, MYSQL

4
Comments
5 min read
📝 30 COMMON MYSQL INTERVIEW QUESTIONS 🐬

📝 30 COMMON MYSQL INTERVIEW QUESTIONS 🐬

Comments
5 min read
Choosing the Right Primary Key for the Database

Choosing the Right Primary Key for the Database

1
Comments
6 min read
MySQL Terminal: Login, Users and Permissions

MySQL Terminal: Login, Users and Permissions

Comments
2 min read
Build a CDC Pipeline from MySQL to ClickHouse with BladePipe

Build a CDC Pipeline from MySQL to ClickHouse with BladePipe

2
Comments
3 min read
loading...