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.
Help! My database was compromised!

Help! My database was compromised!

9
Comments 1
7 min read
How AI made my Amazon RDS for MySQL queries 23x faster

How AI made my Amazon RDS for MySQL queries 23x faster

1
Comments
10 min read
MariaDB vs MySQL: The Ultimate Comparison

MariaDB vs MySQL: The Ultimate Comparison

1
Comments
8 min read
Configurando Docker com MySQL no Arch Linux e conectando ao Workbench 👨🏽‍💻

Configurando Docker com MySQL no Arch Linux e conectando ao Workbench 👨🏽‍💻

Comments
3 min read
Self-hosting Ghost with Docker and PlanetScale

Self-hosting Ghost with Docker and PlanetScale

1
Comments
10 min read
How to Write a SQL Subquery with Drizzle ORM

How to Write a SQL Subquery with Drizzle ORM

Comments
2 min read
How To Design a MySQL Database for your Basic Notification System?

How To Design a MySQL Database for your Basic Notification System?

25
Comments 1
3 min read
Harnessing MySQL Document Store: A Guide to Transforming Documents into Data

Harnessing MySQL Document Store: A Guide to Transforming Documents into Data

1
Comments
2 min read
Pessimistic vs. Optimistic Locking in MySQL

Pessimistic vs. Optimistic Locking in MySQL

39
Comments
5 min read
How to Connect to MySQL through SSH Tunnel

How to Connect to MySQL through SSH Tunnel

1
Comments
1 min read
Solving Common MySQL Issues on macOS: A Guide for Developers

Solving Common MySQL Issues on macOS: A Guide for Developers

5
Comments
2 min read
MySqlException (0x80004005): The Command Timeout expired before the operation completed

MySqlException (0x80004005): The Command Timeout expired before the operation completed

1
Comments
2 min read
Tips and Tricks for isolating long running queries in MySQL

Tips and Tricks for isolating long running queries in MySQL

1
Comments
2 min read
Tuning InnoDB for efficient compression

Tuning InnoDB for efficient compression

Comments
2 min read
Implementing nested loop joins in MySQL for performance

Implementing nested loop joins in MySQL for performance

1
Comments
2 min read
How do you perform the compressed back of the InnoDB Cluster?

How do you perform the compressed back of the InnoDB Cluster?

1
Comments
2 min read
SQL Script for Monitoring Query Performance Latency in Amazon RDS for MySQL

SQL Script for Monitoring Query Performance Latency in Amazon RDS for MySQL

Comments
2 min read
Free SQL Database Schema Generator

Free SQL Database Schema Generator

2
Comments 2
1 min read
Working with Numeric Data Types in MySQL: A Comprehensive Guide

Working with Numeric Data Types in MySQL: A Comprehensive Guide

Comments
5 min read
Newsletter Repost - OpenLampTech issue #112

Newsletter Repost - OpenLampTech issue #112

Comments
1 min read
SQL Database Index Basics

SQL Database Index Basics

5
Comments 6
10 min read
How can display data from a table (patient_category) in the database using php-mysql and codeIgniter?

How can display data from a table (patient_category) in the database using php-mysql and codeIgniter?

Comments
2 min read
A key constraint blunder ruined my MySQL practical exam. Don't let it happen to you.

A key constraint blunder ruined my MySQL practical exam. Don't let it happen to you.

13
Comments
3 min read
Discover DbVisualizer Security Features for MySQL

Discover DbVisualizer Security Features for MySQL

Comments
7 min read
🐳 Setting up MySQL on Docker container in 2 minutes

🐳 Setting up MySQL on Docker container in 2 minutes

1
Comments
2 min read
Defining Custom Many-to-many Relationship in NestJS TypeORM.

Defining Custom Many-to-many Relationship in NestJS TypeORM.

12
Comments 1
3 min read
Newsletter Repost - OpenLampTech issue #111

Newsletter Repost - OpenLampTech issue #111

Comments
1 min read
Finding the best SQL query for the task.

Finding the best SQL query for the task.

Comments
4 min read
Efficiently Managing Data with SELECT During INSERT Queries

Efficiently Managing Data with SELECT During INSERT Queries

1
Comments
2 min read
How to save Hibernate Entity changes to Database

How to save Hibernate Entity changes to Database

Comments
1 min read
Let's learn InnoDB!

Let's learn InnoDB!

5
Comments 1
2 min read
MySQL: Everything You Need To Know

MySQL: Everything You Need To Know

15
Comments
2 min read
Simple Database Software For MySQL

Simple Database Software For MySQL

Comments
8 min read
Your Database Doesn’t Like Your Data – Reserved Words in MySQL

Your Database Doesn’t Like Your Data – Reserved Words in MySQL

Comments
6 min read
Passkey Example Implementation in Node.js, MySQL & Vanilla JS/HTML

Passkey Example Implementation in Node.js, MySQL & Vanilla JS/HTML

8
Comments
2 min read
NULLs Are Not The Same – A Guide

NULLs Are Not The Same – A Guide

Comments
4 min read
How to deploy wordpress website with nginx and mysql

How to deploy wordpress website with nginx and mysql

Comments
2 min read
Newsletter Repost - OpenLampTech issue #109

Newsletter Repost - OpenLampTech issue #109

Comments
1 min read
FastAPI & SQLAlchemy: MySQL Setup Guide

FastAPI & SQLAlchemy: MySQL Setup Guide

8
Comments
4 min read
SQL Interview Questions (MySQL): Part 1

SQL Interview Questions (MySQL): Part 1

Comments 1
5 min read
MySQL vs PostgreSQL: Which one is better?

MySQL vs PostgreSQL: Which one is better?

Comments
2 min read
A laravel-like database management library for nodejs

A laravel-like database management library for nodejs

1
Comments
3 min read
Newsletter Repost - OpenLampTech issue #108

Newsletter Repost - OpenLampTech issue #108

Comments
1 min read
Difference between PostgreSQL and MySQL

Difference between PostgreSQL and MySQL

2
Comments
4 min read
MySQL Analyze Query Execution Plans: How to Reach Top Query SpeedMemory storage engine

MySQL Analyze Query Execution Plans: How to Reach Top Query SpeedMemory storage engine

5
Comments 1
20 min read
Triggers

Triggers

Comments
2 min read
For loops in MySQL...kind of

For loops in MySQL...kind of

2
Comments 2
3 min read
Store images/files for API, using MySQL/MariaDB, Express and Sequelize

Store images/files for API, using MySQL/MariaDB, Express and Sequelize

Comments
4 min read
Scaling AWS RDS Instance Vertically and Horizontally

Scaling AWS RDS Instance Vertically and Horizontally

Comments
3 min read
Copy large files into MySQL DB

Copy large files into MySQL DB

2
Comments 2
1 min read
Newsletter Repost - OpenLampTech issue #107

Newsletter Repost - OpenLampTech issue #107

Comments
1 min read
Servidor para Blog, com Autenticação JWT - Node.Js & Mysql

Servidor para Blog, com Autenticação JWT - Node.Js & Mysql

Comments
13 min read
Understanding Databases: SQL vs NoSQL

Understanding Databases: SQL vs NoSQL

2
Comments 3
7 min read
MySQL Operators – A Guide

MySQL Operators – A Guide

Comments
5 min read
SQL Math Functions with Use Cases

SQL Math Functions with Use Cases

8
Comments 4
2 min read
Contributing to a larger open source project!

Contributing to a larger open source project!

2
Comments
4 min read
Indexes in MySQL – Notes

Indexes in MySQL – Notes

2
Comments
5 min read
Newsletter Repost - OpenLampTech issue #106

Newsletter Repost - OpenLampTech issue #106

Comments
1 min read
Como importar um arquivo CSV via formulário, em Golang

Como importar um arquivo CSV via formulário, em Golang

Comments
2 min read
Keep on working on open-source Spring Boot project

Keep on working on open-source Spring Boot project

1
Comments
2 min read
loading...