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.
Explain Combining Domain-Driven Design and Databases

Explain Combining Domain-Driven Design and Databases

Reactions 2 Comments
8 min read
Deal Scoring- Part 1: Data Pre-processing in MySQL

Deal Scoring- Part 1: Data Pre-processing in MySQL

Reactions 8 Comments
2 min read
Learn MySQL Now!

Learn MySQL Now!

Reactions 6 Comments
1 min read
Postgres Vs MySQL syntax comparison with cheatsheet

Postgres Vs MySQL syntax comparison with cheatsheet

Reactions 6 Comments
1 min read
Wait, I changed my mind.

Wait, I changed my mind.

Reactions 11 Comments 3
5 min read
MariaDB Quick-tip #1 - Range of int

MariaDB Quick-tip #1 - Range of int

Reactions 8 Comments 2
1 min read
MySQL's Data Streaming : What is it & How it works ?

MySQL's Data Streaming : What is it & How it works ?

Reactions 21 Comments
10 min read
How To Update Or Insert A Record In Spring Data JPA

How To Update Or Insert A Record In Spring Data JPA

Reactions 8 Comments 4
2 min read
Spring Boot CRUD API, Amazon RDS for MySQL, AWS Secrets Manager - example

Spring Boot CRUD API, Amazon RDS for MySQL, AWS Secrets Manager - example

Reactions 8 Comments
5 min read
Mysqli_error () expects exactly 1

Mysqli_error () expects exactly 1

Reactions 7 Comments
2 min read
Deploy an Eleventy Blog on Cloudflare pages with Strapi, MySQL, and Dokku on a Digital Ocean Droplet, part 4

Deploy an Eleventy Blog on Cloudflare pages with Strapi, MySQL, and Dokku on a Digital Ocean Droplet, part 4

Reactions 8 Comments
8 min read
Deploy an Eleventy Blog on Cloudflare pages with Strapi, MySQL, and Dokku on a Digital Ocean Droplet, part 3

Deploy an Eleventy Blog on Cloudflare pages with Strapi, MySQL, and Dokku on a Digital Ocean Droplet, part 3

Reactions 7 Comments
6 min read
Deploy an Eleventy Blog on Cloudflare pages with Strapi, MySQL, and Dokku on a Digital Ocean Droplet, part 1

Deploy an Eleventy Blog on Cloudflare pages with Strapi, MySQL, and Dokku on a Digital Ocean Droplet, part 1

Reactions 7 Comments
9 min read
Making a local MicroK8s environment available externally (Part 2 - Installing MicroK8s and MySQL)

Making a local MicroK8s environment available externally (Part 2 - Installing MicroK8s and MySQL)

Reactions 8 Comments
5 min read
How to create 2 MySQL DBs in a single container?

How to create 2 MySQL DBs in a single container?

Reactions 8 Comments
1 min read
How to add Dropbox to XAMPP using an Alias

How to add Dropbox to XAMPP using an Alias

Reactions 6 Comments
2 min read
Generating reports and KPIs with throw-away databases on AWS

Generating reports and KPIs with throw-away databases on AWS

Reactions 12 Comments
5 min read
Top 11 MYSQL monitoring tools in 2022 [open-source included]

Top 11 MYSQL monitoring tools in 2022 [open-source included]

Reactions 32 Comments
7 min read
Databases Migrations

Databases Migrations

Reactions 9 Comments
5 min read
Laravel 9 - Create Column after Another Column

Laravel 9 - Create Column after Another Column

Reactions 8 Comments
1 min read
Long Live MySQL: Kudos to the Ecosystem Innovators

Long Live MySQL: Kudos to the Ecosystem Innovators

Reactions 5 Comments
9 min read
List the size of the database and tables: MySQL CLI

List the size of the database and tables: MySQL CLI

Reactions 9 Comments
1 min read
Failed to Install mariadb-server Fedora35?

Failed to Install mariadb-server Fedora35?

Reactions 7 Comments
1 min read
To Run Services After Deploying The MariaDB Service Using Docker Compose

To Run Services After Deploying The MariaDB Service Using Docker Compose

Reactions 6 Comments
3 min read
🔗PythonMysql_Connection

🔗PythonMysql_Connection

Reactions 10 Comments
2 min read
Deploy an Eleventy Blog on Cloudflare pages with Strapi, MySQL, and Dokku on a Digital Ocean Droplet, part 2

Deploy an Eleventy Blog on Cloudflare pages with Strapi, MySQL, and Dokku on a Digital Ocean Droplet, part 2

Reactions 7 Comments
9 min read
Recreating MYSQL's LPAD Function in SQL Server

Recreating MYSQL's LPAD Function in SQL Server

Reactions 7 Comments 2
4 min read
Introducing prosql.io!

Introducing prosql.io!

Reactions 7 Comments 2
2 min read
[error] [mysql] 1251

[error] [mysql] 1251

Reactions 7 Comments
1 min read
Node.js MySQL vs Node.js MySQL + Sculter.js (which one is better?)

Node.js MySQL vs Node.js MySQL + Sculter.js (which one is better?)

Reactions 9 Comments 2
3 min read
Howto handle index key specification without a key length and key was too long

Howto handle index key specification without a key length and key was too long

Reactions 7 Comments
4 min read
Migrate from PostgreSQL to MySQL using Slick (Scala)

Migrate from PostgreSQL to MySQL using Slick (Scala)

Reactions 5 Comments
2 min read
Amazon RDS - MySQL for .NET Developers

Amazon RDS - MySQL for .NET Developers

Reactions 9 Comments
5 min read
SQL Interview Questions CheatSheet

SQL Interview Questions CheatSheet

Reactions 7 Comments 2
7 min read
Laravel 8 Autocomplete Search from Database

Laravel 8 Autocomplete Search from Database

Reactions 7 Comments
2 min read
Laravel, MySQL - column_type is set to "int (11)" even though the size of int was specified.