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...
Federico Razzoli at MariaDB Server Fest 2022
MariaDB 10.11 is now Generally Available (GA), or stable if you prefer. It is a Long Term Support (LTS) version, so it is recommended for production use. As I do for every new stable version, here I'm writing my review of MariaDB 10.11. Maturity level As mentioned,...
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 stable...
Cassandra consistency levels are a tricky concept, until you familiarise with them. They're based on a simple consideration: not all data and not all queries require the same level of correctness. By default: data changes are written to only one node for better...
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 CONCAT(user,...
Treedom is the first platform in the world that allows you to plant a tree from a distance and follow the story of the project online. We share our knowledge of open source databases with the Treedom team, and have been their friends and suppliers from...
In SQL, using the LIKE operator is a powerful way to find strings that match a certain pattern. It's suitable for most use cases, thanks to its two wildcard characters: _ means any one character. % means any sequence of zero or more characters. However, many queries...
MariaDB 10.9 GA was released on the 22nd of August 2022. It is a short-term release, and we are not recommended to use it in production because it will only be supported for one year. The latest long-term release, at the time of this writing, is MariaDB 10.6. General...
