by Federico Razzoli | May 8, 2025 | MariaDB, MySQL
Most tables have a concept of “duplicate rows”, where duplicates should never be allowed. Typical examples are: We have a product table, the name column is UNIQUE. If I’ll try to insert a row with a name that already exists, the product I’m...
by Federico Razzoli | Mar 24, 2025 | MariaDB, MariaDB Features
MariaDB SEQUENCE is a storage engine that generates a sequence of positive integer numbers. However, in this article I will show you that it’s easy to use SEQUENCE to generate more complex sequences, that are not necessarily numeric. This is a very convenient...
by Federico Razzoli | Mar 22, 2025 | MariaDB, MySQL
MariaDB supports stored procedures written in procedural SQL. Which essentially means “SQL with IF’s and loops”. Most DBMSs do the same, but every project supports different, incompatible syntaxes. MariaDB implemented Oracle’s dialect, called...
by Federico Razzoli | Mar 14, 2025 | MySQL
For a very long time, the EXPLAIN command remained the same in the MariaDB and MySQL world. It was good enough in most cases, but the community welcomed the implementation of extensions and variants. However, MariaDB and MySQL improved it in different ways. So, if...
by Federico Razzoli | Feb 14, 2025 | MariaDB
MariaDB has many configurable timeouts. Some of them can only be configured by DBAs (database administrators). Others can be adjusted by developers in the application code, though DBAs can configure defaults. MariaDB timeouts can be grouped in these categories:...