During our SQL optimisation training courses, I always stress the need of understanding how databases run SQL ...
MariaDB SEQUENCE is a storage engine that generates a sequence of positive integer numbers. However, in this ...
MariaDB supports stored procedures written in procedural SQL. Which essentially means "SQL with IF's and ...
Developers who are not familiar with SQL are often confused by MariaDB and MySQL's infamous GROUP BY error. From ...
MariaDB has many configurable timeouts. Some of them can only be configured by DBAs (database administrators). ...
It's January 2025, so it's a good time to look back, and write my thoughts on the most important events and trends ...
Writer switchover issues with ProxySQL and Galera can feel like an unsolved puzzle. Recently, I encountered two ...
MariaDB users normally connect using a password. Weak passwords are a common security problem, especially when ...