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.
A laravel-like database management library for nodejs

A laravel-like database management library for nodejs

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

Comments
20 min read
Triggers

Triggers

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
Discover DbVisualizer Security Features for MySQL

Discover DbVisualizer Security Features for MySQL

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

For loops in MySQL...kind of

1
Comments 2
3 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
NULLs Are Not The Same – A Guide

NULLs Are Not The Same – A Guide

Comments
4 min read
Copy large files into MySQL DB

Copy large files into MySQL DB

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

Contributing to a larger open source project!

2
Comments
4 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
Servidor para Blog, com Autenticação JWT - Node.Js & Mysql

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

Comments
13 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
SQL Math Functions with Use Cases

SQL Math Functions with Use Cases

3
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
Save & Load Images In Database With PHP MYSQL

Save & Load Images In Database With PHP MYSQL

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
Automated MySQL Backup Pipeline on AWS S3 using Jenkin

Automated MySQL Backup Pipeline on AWS S3 using Jenkin

Comments
4 min read
How to Use MySQL Database in Total.js with QueryBuilderMySQL?

How to Use MySQL Database in Total.js with QueryBuilderMySQL?

2
Comments
5 min read
MySQL invisible columns and how to define it with Laravel and Doctrine

MySQL invisible columns and how to define it with Laravel and Doctrine

11
Comments 3
2 min read
Restore or Migrate your MySQL Database to Railway

Restore or Migrate your MySQL Database to Railway

4
Comments
3 min read
A Deep Dive into MySQL Enums: The Good, The Bad, and The Ugly Operations

A Deep Dive into MySQL Enums: The Good, The Bad, and The Ugly Operations

5
Comments
4 min read
How to tabulate a JSON document in MySQL

How to tabulate a JSON document in MySQL

Comments
2 min read
đŸ’Ÿ Automatiser le « backup » d'une base de donnĂ©e MySQL avec NestJS et TypeORM

đŸ’Ÿ Automatiser le « backup » d'une base de donnĂ©e MySQL avec NestJS et TypeORM

1
Comments
12 min read
Image Management and Database Integration with Node.js, Multer, Cloudinary and MySQL

Image Management and Database Integration with Node.js, Multer, Cloudinary and MySQL

1
Comments
5 min read
Restore your MySQL Database on PlanetScale

Restore your MySQL Database on PlanetScale

5
Comments
2 min read
How to Optimize MySQL Tables: A Comprehensive Guide

How to Optimize MySQL Tables: A Comprehensive Guide

Comments
10 min read
How to build an event management application in Amplication

How to build an event management application in Amplication

5
Comments
4 min read
Database GitOps with Bytebase for MySQL

Database GitOps with Bytebase for MySQL

9
Comments
3 min read
CRUD Operations in SQL

CRUD Operations in SQL

2
Comments 1
14 min read
Schemas em SQL: Indexes e B+ trees

Schemas em SQL: Indexes e B+ trees

4
Comments 2
4 min read
Designing a database with MySQL using the Workbench — Part 3

Designing a database with MySQL using the Workbench — Part 3

Comments
6 min read
Fix MySQL Error: Access Denied for User ‘root’@’localhost’

Fix MySQL Error: Access Denied for User ‘root’@’localhost’

Comments
3 min read
The Enigma of MySQL's INT(11): Unraveling the Mystery

The Enigma of MySQL's INT(11): Unraveling the Mystery

11
Comments
3 min read
Building a Node.js Authentication System with MySQL: A Step-by-Step Guide

Building a Node.js Authentication System with MySQL: A Step-by-Step Guide

14
Comments 4
6 min read
Host is not allowed to connect to this MariaDB server XAMPP

Host is not allowed to connect to this MariaDB server XAMPP

1
Comments
2 min read
MacOS Sonoma: libmysqlclient.21.dylib (no such file, not in dyld cache)

MacOS Sonoma: libmysqlclient.21.dylib (no such file, not in dyld cache)

1
Comments 5
2 min read
6 useful SQL queries for web developers (MySQL)

6 useful SQL queries for web developers (MySQL)

13
Comments
5 min read
Multiple-Column Indexes and Hashing: The Ultimate Guide to Boosting Database Performance

Multiple-Column Indexes and Hashing: The Ultimate Guide to Boosting Database Performance

5
Comments 1
4 min read
Rust & MySQL: JSON serialisation of result sets retrieved using crate sqlx.

Rust & MySQL: JSON serialisation of result sets retrieved using crate sqlx.

6
Comments
6 min read
Using MySQL as a NoSQL Document Store - Introduction

Using MySQL as a NoSQL Document Store - Introduction

Comments
7 min read
🐣 Step-by-Step Guide to Data Masking 🎭

🐣 Step-by-Step Guide to Data Masking 🎭

9
Comments
4 min read
Docker on Ubuntu 22.10: running mysql:8.0.34-debian with custom config, socket, database and log files reside on host machine.

Docker on Ubuntu 22.10: running mysql:8.0.34-debian with custom config, socket, database and log files reside on host machine.

2
Comments
20 min read
The Ultimate Guide to MySQL COLLATE: Decoding Modifiers, Combinations, and Real-world Applications

The Ultimate Guide to MySQL COLLATE: Decoding Modifiers, Combinations, and Real-world Applications

5
Comments
4 min read
Benchmarking Trilogy : Is it really the future of Rails ?

Benchmarking Trilogy : Is it really the future of Rails ?

11
Comments 2
5 min read
.Net with MySql

.Net with MySql

2
Comments 2
5 min read
Amazon RDS for MySQL

Amazon RDS for MySQL

Comments
1 min read
MariaDB, MySQL, and Node.js: Why Using the Right Connector Matters

MariaDB, MySQL, and Node.js: Why Using the Right Connector Matters

8
Comments
4 min read
MySQL Database Migration to a Remote Server from a .gz mysqldump file

MySQL Database Migration to a Remote Server from a .gz mysqldump file

Comments
10 min read
Auto-Synchronizing an Entire MySQL Database for Data Analysis

Auto-Synchronizing an Entire MySQL Database for Data Analysis

Comments
5 min read
How to simplify database operations using MySQL stored procedures

How to simplify database operations using MySQL stored procedures

Comments
7 min read
How to update multiple rows based on list of key-val pairs (in MySQL, MariaDB, & PostgreSQL)

How to update multiple rows based on list of key-val pairs (in MySQL, MariaDB, & PostgreSQL)

Comments
2 min read
Integration Test MySQL Store with testcontainers-go

Integration Test MySQL Store with testcontainers-go

1
Comments
4 min read
Revolutionizing Database Services: An Inside Look at Sealos and KubeBlocks

Revolutionizing Database Services: An Inside Look at Sealos and KubeBlocks

1
Comments
4 min read
UTF-8 in MySQL

UTF-8 in MySQL

5
Comments 2
6 min read
Understanding Joins in SQL

Understanding Joins in SQL

4
Comments 2
3 min read
Integration Test MySQL Store (Go)

Integration Test MySQL Store (Go)

1
Comments
11 min read
loading...