MariaDB 10.3 supports stored aggregate functions. Let’s see how to create them with examples.
Read more3 good reasons to use Stored Procedures
Stored procedures are considered slow and not scalable, especially in the MySQL world. But in some cases they can increase an application speed and scalability.
Read moreMySQL/MariaDB: run less queries! (thanks to performance_schema)
Do you want to improve your application’s and database server’s performance? Remove useless queries. Yes, you probably have them.
Read moreWorking with JSON objects in MySQL/MariaDB
MySQL JSON types has a rich set of functions. This allows us to use JSON to simulate native objects.
Read moreTEXT and BLOB good practices
TEXT and BLOB are special types in MySQL/MariaDB. This article helps to understand them and use them properly.
Read moreSetting performance and availability objectives (SLO)
How to define realistic speed and availability goals. Understand what a SLO (service-level objective) is, and the cost of violating it.
Read moreDropping database objects in a safe way
Whenever I worked as a DBA, I was reasonably scared by 💧DROP commands. Don’t get me wrong: despite this, I badly wanted to drop obsolete tables. After that, I could more easily ask developers to fix bad practices, like tables …
Read moreCircular tables in MariaDB
Let’s create a table that always contains a fixed amount of rows, using MariaDB 10.3.
Read moreThe perils of ALTER TABLE in MySQL/MariaDB
ALTER TABLE is often necessary, but it can be risky in a production environment for many reasons. Let’s discuss the problems that one has to take into account.
Read moreSearching a phone book and copying names
Why developers need to learn the basics of query optimisation. How to make the learning process easy and pleasant.
Read more