Schedule Meeting

a
MariaDB: WITH TIES syntax

MariaDB: WITH TIES syntax

MariaDB implemented the WITH TIES syntax in version 10.6. This feature may not be a ground breaker, but it is useful in some cases and it increases compatibility with some other DBMSs. Let’s see what it does, and what use cases it has. Some history MariaDB (just...
A summary of MariaDB 10.6

A summary of MariaDB 10.6

MariaDB 10.6 went Generally Available (production ready)! The first GA version is 10.6.3, released on 6th July 2021. I encourage you to take a look at the 10.6 official summary, but I’ve made a quick test and I want to put my own thoughts and comments here....
MariaDB Ignored Indexes

MariaDB Ignored Indexes

MariaDB introduced ignored Indexes in version 10.6. The feature is substantially very similar to MySQL Invisible Indexes (docs), introduced in version 8.0. Here we’ll see how to use Ignored Indexes drop indexes in production with a reasonable risk. See our...
DROP TABLE improvements in MariaDB

DROP TABLE improvements in MariaDB

MariaDB implemented several improvements to the DROP TABLE statement. We summarise them here. This article will be kept up to date when MariaDB implements further improvements, in the future. Loch Lomond, Scotland Contributions Before listing the improvements,...

How to compose strings in 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.

read more

How to compose strings in 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.

read more