The UUID data type in MariaDB
MariaDB introduced the UUID data type in version 10.7. The first long-term support (LTS) version to include it is 10.11, which was declared stable in February 2023. In this article we will discuss how to use the UUID type, and why it is often wise to use it as a...
Overview of detailed slow query logging in MySQL 8: log_slow_extra
Every MySQL 8 minor release comes with a good number of bug fixes as well as exciting new features. MySQL 8.0.14 introduced the new log_slow_extra parameter. It is used to enable additional fields in the MySQL slow query log. They will help you get more information...
A summary of MariaDB 10.10: INET4 type, RANDOM_BYTES() and more
In my first post in 2023, I want to give you a summary of MariaDB 10.10. Some may argue that I’m a bit late because it was released last November, and versions 10.11 and 11.0 have been announced since then… All that is correct, but 10.10 is the latest...
How to compose strings in MariaDB
MariaDB supports several ways to compose strings dynamically. Some of them might be well-known, others aren’t familiar to you. This article covers all the ways to compose strings. CONCAT() CONCAT() is a simple function to concatenate strings: > SELECT...
Vettabase specialises in expert consulting and automation for your database infrastructure. We offer professional services and training for MySQL, MariaDB, PostgreSQL and Cassandra.