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.
Optimizing SQL Queries by 23x!!!

Optimizing SQL Queries by 23x!!!

202
Comments 38
8 min read
Docker for Beginners: Crafting Your Backend Development Environment

Docker for Beginners: Crafting Your Backend Development Environment

59
Comments 3
6 min read
When to use SQL vs NoSQL

When to use SQL vs NoSQL

49
Comments 4
4 min read
PostgreSQL or MySQL: What Should I Choose for My Full-Stack Project?

PostgreSQL or MySQL: What Should I Choose for My Full-Stack Project?

46
Comments 11
6 min read
How we handled MySQL deadlocks in Productive - Part 1

How we handled MySQL deadlocks in Productive - Part 1

46
Comments
6 min read
Exploring Advanced and Modern Concepts in SQL with Practical Examples.

Exploring Advanced and Modern Concepts in SQL with Practical Examples.

40
Comments 13
4 min read
Garanta a Eficiência: Escolhendo entre tipos String no SQL

Garanta a Eficiência: Escolhendo entre tipos String no SQL

35
Comments 7
4 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
Apache APISIX without etcd

Apache APISIX without etcd

22
Comments 5
5 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
Adding sequence duplicate records in MySQL without a window function

Adding sequence duplicate records in MySQL without a window function

21
Comments
3 min read
Storing and retrieving data from MySQL in Go APIs

Storing and retrieving data from MySQL in Go APIs

19
Comments
4 min read
PHP environment development

PHP environment development

17
Comments
1 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
A unique database for every PR using CodeSandbox

A unique database for every PR using CodeSandbox

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

6 useful SQL queries for web developers (MySQL)

13
Comments
5 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
REST API with Go, Chi, MySQL and sqlx

REST API with Go, Chi, MySQL and sqlx

12
Comments 2
7 min read
The Trade-offs Between Database Normalization and Denormalization

The Trade-offs Between Database Normalization and Denormalization

12
Comments 1
4 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
Benchmarking Trilogy : Is it really the future of Rails ?

Benchmarking Trilogy : Is it really the future of Rails ?

11
Comments 2
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
MySQL: Everything You Need To Know

MySQL: Everything You Need To Know

11
Comments
2 min read
Amazon Aurora is Now 60 Times Faster than RDS for MySQL. Really.

Amazon Aurora is Now 60 Times Faster than RDS for MySQL. Really.

10
Comments
2 min read
Don't underestimate SQL

Don't underestimate SQL

10
Comments 4
2 min read
Spring Boot + MySQL + Spring Data JPA: A Beginner's Guide to REST API CRUD Operations

Spring Boot + MySQL + Spring Data JPA: A Beginner's Guide to REST API CRUD Operations

10
Comments
4 min read
Database GitOps with Bytebase for MySQL

Database GitOps with Bytebase for MySQL

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

🐣 Step-by-Step Guide to Data Masking 🎭

9
Comments
4 min read
Como normalizar banco de dados?

Como normalizar banco de dados?

9
Comments
2 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
🔄 How to Synchronize Database Schemas🔥🚀

🔄 How to Synchronize Database Schemas🔥🚀

7
Comments 1
5 min read
Help! My database was compromised!

Help! My database was compromised!

7
Comments
7 min read
PHP Phone Book

PHP Phone Book

7
Comments 2
2 min read
A Straightforward Guide for Isolation Levels

A Straightforward Guide for Isolation Levels

7
Comments
13 min read
SQL Common Table Expressions and Window functions

SQL Common Table Expressions and Window functions

6
Comments 1
7 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
UTF-8 in MySQL

UTF-8 in MySQL

6
Comments 2
6 min read
how to store html form data in mysql database using hibernate

how to store html form data in mysql database using hibernate

6
Comments
1 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
[TechStory]: Migrating services and databases from an OpenShift (or K8s) cluster to another

[TechStory]: Migrating services and databases from an OpenShift (or K8s) cluster to another

6
Comments
5 min read
SQL Database Index Basics

SQL Database Index Basics

6
Comments 6
10 min read
Restore your MySQL Database on PlanetScale

Restore your MySQL Database on PlanetScale

5
Comments
2 min read
Rust & MySQL: connect, execute SQL statements and stored procs using crate sqlx.

Rust & MySQL: connect, execute SQL statements and stored procs using crate sqlx.

5
Comments 1
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
Concurrency Control in Go with Ent ORM and MySQL

Concurrency Control in Go with Ent ORM and MySQL

5
Comments
10 min read
Use a Stored Column for Indexing Values Stored in JSON [MySQL Tip]

Use a Stored Column for Indexing Values Stored in JSON [MySQL Tip]

5
Comments
2 min read
620. Not Boring Movies leetcode solution

620. Not Boring Movies leetcode solution

5
Comments
1 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
Access MySQL Document Store from NodeJS Application

Access MySQL Document Store from NodeJS Application

5
Comments
4 min read
Comment installer et faire tourner mediawiki Avec Xampp

Comment installer et faire tourner mediawiki Avec Xampp

5
Comments
4 min read
hibernate 6 crud operations

hibernate 6 crud operations

5
Comments
4 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
Creating Dynamic Web Applications with PHP and MySQL

Creating Dynamic Web Applications with PHP and MySQL

5
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
1050. Actors and Directors Who Cooperated At Least Three Times leetcode solution

1050. Actors and Directors Who Cooperated At Least Three Times leetcode solution

5
Comments
1 min read
Unveiling the Mystery: How the `DESCRIBE` Command Can Bring Down a Server

Unveiling the Mystery: How the `DESCRIBE` Command Can Bring Down a Server

5
Comments
3 min read
Storing IP Addresses as Numbers in Your Database

Storing IP Addresses as Numbers in Your Database

5
Comments
2 min read
# Let's learn InnoDB!

# Let's learn InnoDB!

5
Comments 1
2 min read
A Beginner-friendly Approach to Developing a REST API with Go, Gin and MSQL

A Beginner-friendly Approach to Developing a REST API with Go, Gin and MSQL

5
Comments
9 min read
How to create a Linux VM and Install MySQL Server using Cloudshell

How to create a Linux VM and Install MySQL Server using Cloudshell

5
Comments
4 min read
loading...