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.
CDC in AWS: Content Data Capture from AWS RDS MySQL into AWS MSK Kafka topic using Debezium

CDC in AWS: Content Data Capture from AWS RDS MySQL into AWS MSK Kafka topic using Debezium

1
Comments
5 min read
MySQL Views & Window Functions: Advanced Data Analysis Techniques

MySQL Views & Window Functions: Advanced Data Analysis Techniques

Comments
2 min read
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
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
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...