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.
Newsletter Repost - OpenLampTech issue #112

Newsletter Repost - OpenLampTech issue #112

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

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

Finding the best SQL query for the task.

Comments
4 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
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
Newsletter Repost - OpenLampTech issue #109

Newsletter Repost - OpenLampTech issue #109

Comments
1 min read
FastAPI & SQLAlchemy: MySQL Setup Guide

FastAPI & SQLAlchemy: MySQL Setup Guide

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

SQL Interview Questions (MySQL): Part 1

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

4
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

8
Comments 4
2 min read
Indexes in MySQL – Notes

Indexes in MySQL – Notes

2
Comments
5 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
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

4
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?

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

7
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

2
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
Designing a database with MySQL using the Workbench — Part 3

Designing a database with MySQL using the Workbench — Part 3

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

24
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)

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

Schemas em SQL: Indexes e B+ trees

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

6 useful SQL queries for web developers (MySQL)

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

6
Comments
4 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
loading...