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
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
MariaDB 10.3 supports stored aggregate functions. Let’s see how to create them with examples.
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
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 moreWorking with JSON arrays in MySQL/MariaDB
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.
Read more