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 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.
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. %...
Our review of MariaDB 10.9 version, released in August 2022.
New features and performance optimisations in MariaDB 10.8 short term support release.
The optimal way to store a MD5 hashes in MariaDB, and how to work with them.
MariaDB supports regular expressions, but regexps won’t use indexes. Here’s a workaround that can be used in some cases.
Semantics and use cases of the WITH TIES syntax.
Vettabase specialises in expert consulting and automation for your database infrastructure. We offer professional services and training for MySQL, MariaDB, PostgreSQL and Cassandra.
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...
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.
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.
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...
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.
In SQL, using the LIKE operator is a powerful way to find strings that match a certain pattern. It's suitable for most...
In...
Learn how to enable an audit log plugin on the Community version of MySQL 8 Server.
Shadowserver has announced that they found over 3.6 million MySQL servers exposed to the web, following their Accessible MySQL Server Report.
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.
Choose the best balance between speed and consistency by setting proper consistency levels.
Cassandra 4.0 GA was released on 26th July 2021. Older versions users need to upgrade quickly.
In SQL, using the LIKE operator is a powerful way to find strings that match a certain pattern. It's suitable for most...
What is faster: PostgreSQL or AlloyDB? Some benchmarks and a performance analysis.
Why autovacuum is important in PostgreSQL and how to configure it properly.