Treedom is the first platform in the world that allows you to plant a tree from a distance and follow the story of the project online. We share our knowledge of open source databases with the Treedom team, and have been their friends and suppliers from...
In SQL, using the LIKE operator is a powerful way to find strings that match a certain pattern. It's suitable for most use cases, thanks to its two wildcard characters: _ means any one character. % means any sequence of zero or more characters. However, many queries...
MariaDB 10.9 GA was released on the 22nd of August 2022. It is a short-term release, and we are not recommended to use it in production because it will only be supported for one year. The latest long-term release, at the time of this writing, is MariaDB 10.6. General...
MariaDB 10.8 was released in May 2022 and I'm writing a review, as I did with MariaDB 10.6. I plan to keep doing this with every major release. Bear in mind that my reviews reflect my personal opinions. 10.8 is a short-term release, which means that the support...
Shadowserver has announced that they found over 3.6 million MySQL servers exposed to the web, following their Accessible MySQL Server Report. At Vettabase we have no way to verify their data (it would be quite surprising if we had!), but we have no reasons to think...
Versioning your code, your database structure, or your infrastructure as code, is essential. But versioning comes with a potential problem: fixing mistakes can be tricky. Here I propose solutions for the most common problems. Uncommitted changes Changes were made to...
Federico Razzoli at PHP Cambridge 2022
Federico Razzoli at FOSDEM 2022
Hashes are normally represented in a human-readable format. The easiest way to work with them is to just insert this human-readable form into a table, as a string. But that is not an efficient way to work with hashes. This article explains how to read and write hashes...
Do you remember the infamous GitLab database incident in 2017? Three backup strategies in place... but no test. When they needed to quickly restore a backup there was none. You don't want to be in that situation. Here's a high level discussion about how to test...
