Foreign keys are a controversial topic. MySQL and MariaDB implementation has several bugs and limitations, that are discussed here.
Maybe you’re wondering why in MySQL/MariaDB ‘string’ seems to be the same as ‘STRING’. Or maybe that’s not the case for you, but you would like to make a case insensitive search. This article explains how to write a case …
MySQL transactions can be read only. Here’s how to use them, and why they are useful.
Reducing the number of queries is important. The article describes how to use the SQL language more expressively (in MySQL) to achieve the purpose.
Let’s use MariaDB 10.3 stored aggregate functions to implement a geometric mean.
Stored procedures are considered slow and not scalable, especially in the MySQL world. But in some cases they can increase an application speed and scalability.
MySQL JSON types has a rich set of functions. This allows us to use JSON to simulate native objects.
Let’s create a table that always contains a fixed amount of rows, using MariaDB 10.3.
Any comparison involving at least one NULL operand will return NULL. However, SQL supports operators to easily write NULL-safe comparisons.
MySQL and MariaDB provide different ways to concatenate strings. Including ways to deal with NULLs.