TEXT and BLOB are special types in MySQL/MariaDB. This article helps to understand them and use them properly.
How to define realistic speed and availability goals. Understand what a SLO (service-level objective) is, and the cost of violating it.
Whenever I worked as a DBA, I was reasonably scared by 💧DROP commands. Don’t get me wrong: despite this, I badly wanted to drop obsolete tables. After that, I could more easily ask developers to fix bad practices, like tables …
Let’s create a table that always contains a fixed amount of rows, using MariaDB 10.3.
ALTER TABLE is often necessary, but it can be risky in a production environment for many reasons. Let’s discuss the problems that one has to take into account.
Why developers need to learn the basics of query optimisation. How to make the learning process easy and pleasant.
It is quite common to use an equality condition and an IS NULL condition on the same columns. Unfortunately, this could make queries very slow.
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.
When you write stored procedures in MySQL or MariaDB, one of the missing features is an ARRAY type. But actually, it is possible to create arrays by using the JSON type. This article explains how to work with JSON arrays.