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...
MariaDB
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.
Hints to optimise queries with a LIKE comparison
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 jolly characters: _ means any one character. %...
A summary of MariaDB 10.9: Vault integration, innodb_log_file_size and more
Our review of MariaDB 10.9 version, released in August 2022.
A summary of MariaDB 10.8: key performance improvements
New features and performance optimisations in MariaDB 10.8 short term support release.
MariaDB/MySQL: Working with MD5 or other hashes
The optimal way to store a MD5 hashes in MariaDB, and how to work with them.
MariaDB: The “Regexp AND LIKE” optimisation
MariaDB supports regular expressions, but regexps won’t use indexes. Here’s a workaround that can be used in some cases.
MariaDB: WITH TIES syntax
Semantics and use cases of the WITH TIES syntax.