Federico Razzoli
Federico Razzoli is a database professional, with a preference for open source databases, who has been working with DBMSs since year 2000. In the past 20+ years, he served in a number of companies as a DBA, Database Engineer, Database Consultant and Software Developer.
In 2016, Federico summarized his extensive experience with MariaDB in the “Mastering MariaDB” book published by Packt. Being an experienced database events speaker, Federico speaks at professional conferences and meetups and conducts database trainings. He is also a supporter and advocate of open source software.
As the Director of Vettabase, Federico does business worldwide but prefers to do it from Scotland where he lives.
MariaDB 10.11 LTS: New types and functions, more dynamic InnoDB configuration
MariaDB 10.11 is now Generally Available (GA), or stable if you prefer. It is a Long Term Support (LTS) version, so it is recommended for production use. As I do for every new stable version, here I'm writing my review of MariaDB 10.11. Maturity level As mentioned,...
A summary of MariaDB 10.10: INET4 type, RANDOM_BYTES() and more
In my first post in 2023, I want to give you a summary of MariaDB 10.10. Some may argue that I'm a bit late because it was released last November, and versions 10.11 and 11.0 have been announced since then... All that is correct, but 10.10 is the latest stable...
Cassandra: How to run a query with Maximum Consistency
Cassandra consistency levels are a tricky concept, until you familiarise with them. They're based on a simple consideration: not all data and not all queries require the same level of correctness. By default: data changes are written to only one node for better...
How to compose strings in MariaDB
MariaDB supports several ways to compose strings dynamically. Some of them might be well-known, others aren't familiar to you. This article covers all the ways to compose strings. CONCAT() CONCAT() is a simple function to concatenate strings: > SELECT CONCAT(user,...
Vettabase Partnered With Treedom
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...
Hints to optimise queries with a LIKE comparison
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...
A summary of MariaDB 10.9: Vault integration, innodb_log_file_size and more
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...
A summary of MariaDB 10.8: key performance improvements
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...
3.6 millions MySQL servers accessible from the web. Hints to keep yours secure
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...