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.
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
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
Streamlining CDC with MySQL, Debezium, Azure Event Hubs, and Functions

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

1
Comments
6 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
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
Restore or Migrate your MySQL Database to Railway

Restore or Migrate your MySQL Database to Railway

4
Comments
3 min read
PHP environment development

PHP environment development

17
Comments
1 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
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
MacOS Sonoma: libmysqlclient.21.dylib (no such file, not in dyld cache)

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

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

6
Comments
4 min read
CRUD Operations in SQL

CRUD Operations in SQL

2
Comments 1
14 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
Villámgyors MySQL ORDER BY RAND() lekérdezés

Villámgyors MySQL ORDER BY RAND() lekérdezés

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

6
Comments 2
6 min read
Understanding Joins in SQL

Understanding Joins in SQL

4
Comments 2
3 min read
An Introduction to MySQL Database

An Introduction to MySQL Database

Comments
2 min read
Integration Test MySQL Store (Go)

Integration Test MySQL Store (Go)

1
Comments 1
11 min read
How to Create a Discussion Forum Using PHP and MySQL?

How to Create a Discussion Forum Using PHP and MySQL?

34
Comments 6
9 min read
Access MySQL Document Store from NodeJS Application

Access MySQL Document Store from NodeJS Application

5
Comments
4 min read
Rust & MySQL: executing MySQL stored procedures which return multiple result sets using crate sqlx.

Rust & MySQL: executing MySQL stored procedures which return multiple result sets using crate sqlx.

1
Comments
10 min read
loading...