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.
O que é a normalização em um banco de dados ?

O que é a normalização em um banco de dados ?

3
Comments
2 min read
Node Backend Developer Important Packages

Node Backend Developer Important Packages

1
Comments
7 min read
1 billion rows challenge in MySQL

1 billion rows challenge in MySQL

Comments
4 min read
Optimizing SQL Queries by 23x!!!

Optimizing SQL Queries by 23x!!!

202
Comments 38
8 min read
A Closer Look: Exploring the Functions of Apache HTTP Server and Apache httpd

A Closer Look: Exploring the Functions of Apache HTTP Server and Apache httpd

Comments
2 min read
Implementing Columnstore Indexes in PostgreSQL with the cstore_fdw Extension

Implementing Columnstore Indexes in PostgreSQL with the cstore_fdw Extension

2
Comments
2 min read
Unleash the searching power of MySQL by with Full-Text Search

Unleash the searching power of MySQL by with Full-Text Search

4
Comments
5 min read
How to Deploy your Django Web App and connect a MySQL Database in cPanel

How to Deploy your Django Web App and connect a MySQL Database in cPanel

1
Comments 2
7 min read
The 2 Best No-Code Backend Builders

The 2 Best No-Code Backend Builders

2
Comments
7 min read
Deploy Ghost with MySQL DB replication using helm chart

Deploy Ghost with MySQL DB replication using helm chart

Comments
2 min read
RDS MySQL vs. Aurora: A Comprehensive Performance Guide

RDS MySQL vs. Aurora: A Comprehensive Performance Guide

2
Comments
2 min read
Setting up MySQL on Amazon EC2 using Homebrew

Setting up MySQL on Amazon EC2 using Homebrew

5
Comments
2 min read
How does the wrong checkpointing configuration in PostgreSQL affect the performance?

How does the wrong checkpointing configuration in PostgreSQL affect the performance?

4
Comments
2 min read
Free SQL Database Schema Generator

Free SQL Database Schema Generator

2
Comments 2
1 min read
Help! My database was compromised!

Help! My database was compromised!

7
Comments
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
How To Design a MySQL Database for your Basic Notification System?

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

21
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

Comments
2 min read
Pessimistic vs. Optimistic Locking in MySQL

Pessimistic vs. Optimistic Locking in MySQL

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

Solving Common MySQL Issues on macOS: A Guide for Developers

1
Comments
2 min read
Triggers

Triggers

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

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

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 to perform compressed back of InnoDB Cluster?

How to perform compressed back of 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
Working with Numeric Data Types in MySQL: A Comprehensive Guide

Working with Numeric Data Types in MySQL: A Comprehensive Guide

Comments
5 min read
SQL Database Index Basics

SQL Database Index Basics

6
Comments 6
10 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.

1
Comments
3 min read
For loops in MySQL...kind of

For loops in MySQL...kind of

1
Comments 2
3 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

11
Comments
2 min read
Streamlining CDC with MySQL, Debezium, Azure Event Hubs, and Functions

Streamlining CDC with MySQL, Debezium, Azure Event Hubs, and Functions

Comments
6 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
Simple Database Software For MySQL

Simple Database Software For MySQL

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

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

2
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
FastAPI & SQLAlchemy: MySQL Setup Guide

FastAPI & SQLAlchemy: MySQL Setup Guide

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

SQL Interview Questions (MySQL): Part 1

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

A laravel-like database management library for nodejs

1
Comments
3 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

2
Comments 1
20 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
Copy large files into MySQL DB

Copy large files into MySQL DB

2
Comments 2
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
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
MySQL Operators – A Guide

MySQL Operators – A Guide

Comments
5 min read
Contributing to a larger open source project!

Contributing to a larger open source project!

2
Comments
4 min read
SQL Math Functions with Use Cases

SQL Math Functions with Use Cases

4
Comments 4
2 min read
Indexes in MySQL – Notes

Indexes in MySQL – Notes

1
Comments
5 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
5 tips to scale MySQL to the tens of millions

5 tips to scale MySQL to the tens of millions

5
Comments
3 min read
loading...