Welcome to Federico-Razzoli.com



I am a freelancer database consultant, specialised in MySQL and other open source databases.

Feel free to browse my free contents. My articles will help you in your job and will satisfy some of your curiosities.

Learn about me and my professional services. Please contact me for any question.


Important notice:
Because of the global health situation,
currently all Database Consulting services take place remotely.


Knowledge Base

Federico-Razzoli.com articles aim to form a shared knowledge base on open source database systems. Feel free to read, contribute with comments, and share links to these contents.

MySQL: IS NULL conditions and indexes

MySQL: IS NULL conditions and indexes

It is quite common to use an equality condition and an IS NULL condition on the same columns. Unfortunately, this could make queries very slow. ...
NULL comparisons in MySQL, PostgreSQL, and SQLite

NULL comparisons in MySQL, PostgreSQL, and SQLite

Any comparison involving at least one NULL operand will return NULL. However, SQL supports operators to easily write NULL-safe comparisons. ...
How to concatenate strings in MySQL and MariaDB

How to concatenate strings in MySQL and MariaDB

MySQL and MariaDB provide different ways to concatenate strings. Including ways to deal with NULLs. ...
Monitoring ProxySQL with PMM in Docker

Monitoring ProxySQL with PMM in Docker

How to add ProxySQL to our MySQL/MariaDB environment, and have it monitored by PMM. Docker allows to do this in minutes, for testing purposes. ...
Testing PMM with Docker

Testing PMM with Docker

Testing PMM as a monitoring solution for MySQL and MariaDB involves installing a lot of stuff. Let's see how to so this in minutes with Docker. ...