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.
Understanding ACID Properties with SQL Transactions

Understanding ACID Properties with SQL Transactions

Comments
3 min read
August 2025 At Releem - Recommendations Impact & Redundant Index Detection

August 2025 At Releem - Recommendations Impact & Redundant Index Detection

Comments
2 min read
How to Create Custom Data Types in DbSchema

How to Create Custom Data Types in DbSchema

7
Comments
3 min read
MySQL Lab: Building a University Information Query System with Database Views

MySQL Lab: Building a University Information Query System with Database Views

Comments
2 min read
mysqld Crashes with Signal 11 and Page Corrupt Error

mysqld Crashes with Signal 11 and Page Corrupt Error

Comments
4 min read
Composite Indexes in MySQL

Composite Indexes in MySQL

Comments
1 min read
sqlx4k — first stable release of a high-performance, non-blocking DB driver for Kotlin Multiplatform

sqlx4k — first stable release of a high-performance, non-blocking DB driver for Kotlin Multiplatform

3
Comments
1 min read
MySQL Database Partitioning Tutorial

MySQL Database Partitioning Tutorial

Comments
6 min read
Primary Key vs. Foreign Key in SQL: Explained with Examples

Primary Key vs. Foreign Key in SQL: Explained with Examples

Comments
2 min read
Useful MYSQL functions

Useful MYSQL functions

Comments
2 min read
SQL GROUP BY Explained with Examples

SQL GROUP BY Explained with Examples

6
Comments
4 min read
Building a Dynamic API in Symfony with Doctrine and MySQL

Building a Dynamic API in Symfony with Doctrine and MySQL

63
Comments
8 min read
How to Back Up and Restore MySQL Using mysqldump

How to Back Up and Restore MySQL Using mysqldump

Comments
2 min read
The Ultimate MySQL Queries Cheat Sheet (With Examples & Outputs)

The Ultimate MySQL Queries Cheat Sheet (With Examples & Outputs)

Comments
3 min read
Day 4 Data Analytics Progress 📈

Day 4 Data Analytics Progress 📈

Comments
1 min read
Part 1: MySQL 8.0 Optimizer Enhancements - SQL Query Optimization Deep Dive

Part 1: MySQL 8.0 Optimizer Enhancements - SQL Query Optimization Deep Dive

Comments
12 min read
Is Cloud SQL Enterprise Plus Worth It? Evaluating the MySQL upgrade at SpareRoom

Is Cloud SQL Enterprise Plus Worth It? Evaluating the MySQL upgrade at SpareRoom

2
Comments
4 min read
MySQL Labs: Change Defaults, Add Constraints, Encrypt Passwords & Optimize Indexes

MySQL Labs: Change Defaults, Add Constraints, Encrypt Passwords & Optimize Indexes

Comments
2 min read
Filtering and Retrieving in SQL

Filtering and Retrieving in SQL

1
Comments 2
3 min read
Scaling Read Tracking with Redis Bitmaps

Scaling Read Tracking with Redis Bitmaps

5
Comments
2 min read
BaseDMS - An open-source, intelligent, AI-powered data management system based on browser

BaseDMS - An open-source, intelligent, AI-powered data management system based on browser

Comments
2 min read
Eliminating Lost Update Anomalies in Spring Boot with Redlock and Custom AOP

Eliminating Lost Update Anomalies in Spring Boot with Redlock and Custom AOP

1
Comments
3 min read
Simplifying SQL Date Data Types with Practical Tips

Simplifying SQL Date Data Types with Practical Tips

Comments
1 min read
How to Connect React with MySQL (Step by Step Guide)

How to Connect React with MySQL (Step by Step Guide)

Comments
2 min read
How We Reimagined SQL Query Building to Be Smarter, Safer, and Simpler (Introducing `mysql2-dx` v1.1.0)

How We Reimagined SQL Query Building to Be Smarter, Safer, and Simpler (Introducing `mysql2-dx` v1.1.0)

4
Comments
3 min read
loading...