TEXT and BLOB are special types in MySQL/MariaDB. This article helps to understand them and use them properly.
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.
How to define realistic speed and availability goals. Understand what a SLO (service-level objective) is, and the cost of violating it.
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 …
Let’s create a table that always contains a fixed amount of rows, using MariaDB 10.3.
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.
Does NULL mean “no value”? Or does it mean “an unknown value”? Its semantics and history are ambiguous and inconsistent.