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.
Zabbix Server Kurulumu

Zabbix Server Kurulumu

2
Comments
2 min read
Indexing JSON Data in MySQL 🐬

Indexing JSON Data in MySQL 🐬

2
Comments 2
2 min read
Changes in procedures/functions while migrating from MySQL to PostgreSQL

Changes in procedures/functions while migrating from MySQL to PostgreSQL

4
Comments
3 min read
Integration Test MySQL with testcontainers-dotnet

Integration Test MySQL with testcontainers-dotnet

6
Comments
5 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
Storing IP Addresses as Numbers in Your Database

Storing IP Addresses as Numbers in Your Database

8
Comments
2 min read
Integration Testing MySQL Store

Integration Testing MySQL Store

1
Comments
10 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
Deploy a Ghost Blog in Production to Koyeb

Deploy a Ghost Blog in Production to Koyeb

Comments
8 min read
MySQL usar tipo SET para validar

MySQL usar tipo SET para validar

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

76
Comments
4 min read
SQL Common Table Expressions and Window functions

SQL Common Table Expressions and Window functions

11
Comments 1
7 min read
Setup a Local Database

Setup a Local Database

7
Comments
2 min read
Apache APISIX without etcd

Apache APISIX without etcd

23
Comments 5
5 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.

15
Comments
2 min read
Resetting MySQL Root Password in Ubuntu: A Step-by-Step Guide

Resetting MySQL Root Password in Ubuntu: A Step-by-Step Guide

45
Comments 1
2 min read
How to JSON in MySQL

How to JSON in MySQL

Comments
1 min read
SQL::Inserter for faster/multi-row inserting

SQL::Inserter for faster/multi-row inserting

1
Comments
4 min read
Creating a Countries API in Django with MySQL Database

Creating a Countries API in Django with MySQL Database

5
Comments 2
3 min read
How to Build MySQL Admin Tools in 6 Steps [VIDEO]

How to Build MySQL Admin Tools in 6 Steps [VIDEO]

Comments
8 min read
How to use the MySQL Terraform Provider

How to use the MySQL Terraform Provider

1
Comments
5 min read
S Database Explorer (SDE) v3.0.0

S Database Explorer (SDE) v3.0.0

Comments
3 min read
Using MySQL Variables

Using MySQL Variables

2
Comments
6 min read
MySql: Compact sensor data to minute averages

MySql: Compact sensor data to minute averages

Comments
1 min read
PHP for Beginners

PHP for Beginners

5
Comments
3 min read
How WeBank Reduced Their Batch Processing Time by 58% With a Scale-Out MySQL Alternative

How WeBank Reduced Their Batch Processing Time by 58% With a Scale-Out MySQL Alternative

Comments
5 min read
Scale up: a MySQL bug story, or why Aiven works

Scale up: a MySQL bug story, or why Aiven works

Comments
5 min read
Multi-Role System in Laravel

Multi-Role System in Laravel

2
Comments
2 min read
Deploy Node-Express-MySQL app on Railway for free (no credit card required)

Deploy Node-Express-MySQL app on Railway for free (no credit card required)

1
Comments 2
8 min read
How to Reset MySQL or MariaDB Root Password on Ubuntu 20.04

How to Reset MySQL or MariaDB Root Password on Ubuntu 20.04

Comments
2 min read
Migrate a MySQL database to a new version and cloud provider

Migrate a MySQL database to a new version and cloud provider

Comments
9 min read
How To Add A New Column In An Existing Table Using MySQL

How To Add A New Column In An Existing Table Using MySQL

2
Comments
2 min read
How to Create a Pseudo MySQL Foreign Data Wrapper for Supabase with PostgreSQL and Edge Functions

How to Create a Pseudo MySQL Foreign Data Wrapper for Supabase with PostgreSQL and Edge Functions

1
Comments
8 min read
Connect Python with MySQL database ( mysql-connector )

Connect Python with MySQL database ( mysql-connector )

Comments
1 min read
REST API with Go, Chi, MySQL and sqlx

REST API with Go, Chi, MySQL and sqlx

17
Comments 2
7 min read
Migrating Sequences from Dynamo to MySQL

Migrating Sequences from Dynamo to MySQL

2
Comments
3 min read
Don't underestimate SQL

Don't underestimate SQL

11
Comments 4
2 min read
Order by random Optimization

Order by random Optimization

Comments
5 min read
A Guide to Subqueries in MySQL

A Guide to Subqueries in MySQL

Comments
5 min read
mysql: three things you (probably) didn't know you could do with the mysql command

mysql: three things you (probably) didn't know you could do with the mysql command

3
Comments 1
4 min read
Desbravando os Segredos do SQL: Um Guia Completo para Dominar a Linguagem de Bancos de Dados

Desbravando os Segredos do SQL: Um Guia Completo para Dominar a Linguagem de Bancos de Dados

2
Comments
3 min read
Stop Using whereDate() Laravel

Stop Using whereDate() Laravel

1
Comments 1
1 min read
Character Sets vs. Collations in a MySQL Database Infrastructure

Character Sets vs. Collations in a MySQL Database Infrastructure

Comments
7 min read
ClickHouse Advanced Tutorial: Apply CDC from MySQL to ClickHouse

ClickHouse Advanced Tutorial: Apply CDC from MySQL to ClickHouse

5
Comments 1
7 min read
Speeding up MySQL for testing or development

Speeding up MySQL for testing or development

Comments
3 min read
mysql support! — pebl supports mysql with release 0.0.6

mysql support! — pebl supports mysql with release 0.0.6

Comments
2 min read
Docker for Beginners: Crafting Your Backend Development Environment

Docker for Beginners: Crafting Your Backend Development Environment

74
Comments 3
6 min read
Connecting to MySQL database with Sequelize in Node.js

Connecting to MySQL database with Sequelize in Node.js

2
Comments
4 min read
ClickHouse Advanced Tutorial: Performance Comparison with MySQL

ClickHouse Advanced Tutorial: Performance Comparison with MySQL

18
Comments 1
6 min read
Create a Spring Boot application with a MySQL backend

Create a Spring Boot application with a MySQL backend

2
Comments
7 min read
Data Validation In SQL: 5 Powerful Data Validation Techniques

Data Validation In SQL: 5 Powerful Data Validation Techniques

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

8
Comments
5 min read
Join Elimination - Advanced SQL tuning

Join Elimination - Advanced SQL tuning

74
Comments 1
3 min read
Stepping into Success: Building a PHP Sneakers E-commerce Website from Scratch

Stepping into Success: Building a PHP Sneakers E-commerce Website from Scratch

1
Comments 1
3 min read
Create a trigger in MySQL in SQLAlchemy migration

Create a trigger in MySQL in SQLAlchemy migration

2
Comments
1 min read
How to use Emojis in a Python + Django + MySQL project

How to use Emojis in a Python + Django + MySQL project

1
Comments
1 min read
Fixed MariaDB/MySQL: “2006, MySQL server has gone away"

Fixed MariaDB/MySQL: “2006, MySQL server has gone away"

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

The Trade-offs Between Database Normalization and Denormalization

13
Comments 1
4 min read
Migrating from MySQL to PostgreSQL: A Step-by-Step Guide

Migrating from MySQL to PostgreSQL: A Step-by-Step Guide

22
Comments 2
3 min read
store JSON data in a non-relational table in the MySQL database ( Laravel )

store JSON data in a non-relational table in the MySQL database ( Laravel )

Comments
8 min read
loading...