TEXT and BLOB are special types in MySQL/MariaDB. This article helps to understand them and use them properly.
Read moreMeetups and more, May 2019
The first London Open Source DB meetup was a success, and a second is coming! Plus my talk at London PHP, my article on ADMIN.
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 (→Vettabase)
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 moreWhat does NULL mean in SQL? (→Vettabase)
Does NULL mean “no value”? Or does it mean “an unknown value”? Its semantics and history are ambiguous and inconsistent.
Read more