Foreign keys are a controversial topic. MySQL and MariaDB implementation has several bugs and limitations, that are discussed here.
Read moreCase sensitivity in MySQL and MariaDB queries
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 …
Read moreREAD ONLY transactions in MySQL (→Vettabase)
MySQL transactions can be read only. Here’s how to use them, and why they are useful.
Read moreMySQL/MariaDB: use SQL properly to run less queries (→Vettabase)
Reducing the number of queries is important. The article describes how to use the SQL language more expressively (in MySQL) to achieve the purpose.
Read moreMariaDB Stored Aggregate Functions by examples
Let’s use MariaDB 10.3 stored aggregate functions to implement a geometric mean.
Read more3 good reasons to use Stored Procedures
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.
Read moreWorking with JSON objects in MySQL/MariaDB
MySQL JSON types has a rich set of functions. This allows us to use JSON to simulate native objects.
Read moreCircular tables in MariaDB
Let’s create a table that always contains a fixed amount of rows, using MariaDB 10.3.
Read moreNULL comparisons in MySQL, PostgreSQL, and SQLite (→Vettabase)
Any comparison involving at least one NULL operand will return NULL. However, SQL supports operators to easily write NULL-safe comparisons.
Read moreHow to concatenate strings in MySQL and MariaDB
MySQL and MariaDB provide different ways to concatenate strings. Including ways to deal with NULLs.
Read more