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.
How to Install MySQL 8 on macOS Using Homebrew

How to Install MySQL 8 on macOS Using Homebrew

4
Comments
6 min read
Docker on Windows 10: mysql:8.0.30-debian log files

Docker on Windows 10: mysql:8.0.30-debian log files

6
Comments
4 min read
Python: executing MySQL stored procedures which return multiple result sets.

Python: executing MySQL stored procedures which return multiple result sets.

3
Comments
4 min read
MariaDB Xpand Distributed MySQL - Foreign key but no Serializable

MariaDB Xpand Distributed MySQL - Foreign key but no Serializable

2
Comments
8 min read
Docker, NodeJS, and MySQL 8

Docker, NodeJS, and MySQL 8

2
Comments
1 min read
Aurora, Where Is My Data? Extreme IOPS Optimization for MySQL

Aurora, Where Is My Data? Extreme IOPS Optimization for MySQL

7
Comments
4 min read
PostgreSQL unit-11

PostgreSQL unit-11

Comments
1 min read
Flutter Youtube List With PHP & MySql

Flutter Youtube List With PHP & MySql

2
Comments
2 min read
After 6 years of practicing MongoDB, Here are my thoughts on MongoDB vs MySQL

After 6 years of practicing MongoDB, Here are my thoughts on MongoDB vs MySQL

6
Comments
4 min read
How to start a MySQL Instance with Podman

How to start a MySQL Instance with Podman

5
Comments 1
3 min read
Transitioning from NoSQL to also implementing SQL

Transitioning from NoSQL to also implementing SQL

3
Comments
1 min read
How to Setup Keycloak With MySQL Database using CLI in Docker

How to Setup Keycloak With MySQL Database using CLI in Docker

1
Comments
3 min read
Here is the Java Backend to my IMDb Clone!

Here is the Java Backend to my IMDb Clone!

9
Comments
5 min read
How to Connect WSL2 (with Laravel App) to a XAMPP MySql Server on Windows

How to Connect WSL2 (with Laravel App) to a XAMPP MySql Server on Windows

3
Comments
3 min read
PostgreSQL unit-9

PostgreSQL unit-9

Comments
1 min read
PostgreSQL unit-8

PostgreSQL unit-8

Comments
1 min read
PostgreSQL unit-7

PostgreSQL unit-7

Comments
1 min read
PostgresSQL unit-6

PostgresSQL unit-6

Comments
1 min read
Create a Grant Application

Create a Grant Application

3
Comments 2
4 min read
Create a database and associate it to a user - MySQL

Create a database and associate it to a user - MySQL

1
Comments
1 min read
8 Week SQL Challenge: Case Study #2 Pizza Runner

8 Week SQL Challenge: Case Study #2 Pizza Runner

Comments 2
10 min read
Partitioning InnoDB tables by time-based pseudo-sequential UUIDs

Partitioning InnoDB tables by time-based pseudo-sequential UUIDs

1
Comments
12 min read
8 Week SQL Challenge: Case Study #1 Danny’s Diner

8 Week SQL Challenge: Case Study #1 Danny’s Diner

1
Comments
9 min read
Python ETL: Creating and automating a pipeline from Mysql to postgresql

Python ETL: Creating and automating a pipeline from Mysql to postgresql

5
Comments
5 min read
APIban-mysql client

APIban-mysql client

Comments
2 min read
How to back up and restore MySQL database on Linux using cron

How to back up and restore MySQL database on Linux using cron

Comments
1 min read
[Solved] Error while Installing mysql2 Gem in M1 Mac

[Solved] Error while Installing mysql2 Gem in M1 Mac

Comments
2 min read
The mysql.session exists but is not correctly configured

The mysql.session exists but is not correctly configured

1
Comments
3 min read
How to monitor long running ALTERS in AWS RDS MySQL 5.7+ using the Performance Schema

How to monitor long running ALTERS in AWS RDS MySQL 5.7+ using the Performance Schema

Comments
2 min read
This SQL solution is GENIUS!!🤩

This SQL solution is GENIUS!!🤩

1
Comments
2 min read
REST API con ASP.NET 6 y MySQL

REST API con ASP.NET 6 y MySQL

9
Comments
7 min read
sqltrace: A low-code intrusion library that provides SQL tracing capabilities

sqltrace: A low-code intrusion library that provides SQL tracing capabilities

6
Comments
2 min read
Designing SQL databases for rock solid data quality

Designing SQL databases for rock solid data quality

33
Comments 3
5 min read
Setup Docker Container for MySQL to use it with Laravel app

Setup Docker Container for MySQL to use it with Laravel app

3
Comments
1 min read
Extracting user data tree from relational databases

Extracting user data tree from relational databases

Comments 1
2 min read
Searching in JAVA: Elasticsearch vs MySQL vs Hibernate

Searching in JAVA: Elasticsearch vs MySQL vs Hibernate

Comments
7 min read
MySQL in Mac (M1)

MySQL in Mac (M1)

3
Comments
1 min read
Autentifikácia v Ionic (ver.5) aplikácii cez REST API (3.časť) - prihlasovanie

Autentifikácia v Ionic (ver.5) aplikácii cez REST API (3.časť) - prihlasovanie

Comments
5 min read
How to Migrate from MySQL to PostgreSQL RDBMS: An Enterprise Approach

How to Migrate from MySQL to PostgreSQL RDBMS: An Enterprise Approach

4
Comments
7 min read
How FullText index works in MySQL

How FullText index works in MySQL

5
Comments
3 min read
Deploy MySQL in Ubuntu server

Deploy MySQL in Ubuntu server

6
Comments 2
2 min read
Difference between joins and foreign key in DBMS

Difference between joins and foreign key in DBMS

15
Comments
4 min read
Using Indexes in MySQL

Using Indexes in MySQL

4
Comments 1
4 min read
What is an Index in MySQL

What is an Index in MySQL

5
Comments
4 min read
Stuck in SQL query

Stuck in SQL query

6
Comments 4
2 min read
MySQL Queries: Basics of MySQL

MySQL Queries: Basics of MySQL

13
Comments
9 min read
How to Deploy Strapi MySQL on a Traditional Hosting Provider

How to Deploy Strapi MySQL on a Traditional Hosting Provider

1
Comments
5 min read
Build a to-do Node.js CLI with Prisma and Next.js

Build a to-do Node.js CLI with Prisma and Next.js

4
Comments
8 min read
Use JDBC to connect TiDB Cloud through TLS

Use JDBC to connect TiDB Cloud through TLS

5
Comments 2
5 min read
MySQL’s UTF-8 Isn’t Real

MySQL’s UTF-8 Isn’t Real

4
Comments
5 min read
MariaDB Quick-tip #7 - Find stored procedure

MariaDB Quick-tip #7 - Find stored procedure

5
Comments
1 min read
Install and configure MySQL Server and MySQL InnoDB Cluster

Install and configure MySQL Server and MySQL InnoDB Cluster

2
Comments
15 min read
MariaDB Quick-tip #8 - All foreign key constraints

MariaDB Quick-tip #8 - All foreign key constraints

4
Comments
1 min read
Docker on Windows 10: running mysql:8.0.30-debian with a custom config file.

Docker on Windows 10: running mysql:8.0.30-debian with a custom config file.

5
Comments
3 min read
How to create a minimal backend API service using Dart Frog with MySQL database

How to create a minimal backend API service using Dart Frog with MySQL database

11
Comments 2
5 min read
MariaDd Quick-tip #10 - Select table definition

MariaDd Quick-tip #10 - Select table definition

Comments 2
2 min read
Escalando uma aplicação para 100M+ jobs e dezenas de milhares de requisições por minuto com Laravel

Escalando uma aplicação para 100M+ jobs e dezenas de milhares de requisições por minuto com Laravel

6
Comments
6 min read
mariabak: Making MariaDB and MySQL backups a breeze

mariabak: Making MariaDB and MySQL backups a breeze

4
Comments
1 min read
How to Insert Form Data into a Database Using HTML & PHP

How to Insert Form Data into a Database Using HTML & PHP

5
Comments 4
6 min read
How to uninstall MySQL Server from Ubuntu 22.04.

How to uninstall MySQL Server from Ubuntu 22.04.

1
Comments 6
2 min read
loading...