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
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?
Does NULL mean “no value”? Or does it mean “an unknown value”? Its semantics and history are ambiguous and inconsistent.
Read more