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.

My community activities in 2019

My community activities in 2019

31th December post: reviewing an year of open source database community activities in London. ...
MySQL/MariaDB: Using views to grant or deny row-level privileges

MySQL/MariaDB: Using views to grant or deny row-level privileges

Relational DBMSs allow to grant users permissions on certain tables or columns. Here we'll discuss how to restrict access to a certain set of rows. ...
The dangers of replication filters in MySQL

The dangers of replication filters in MySQL

MySQL supports replication filters and binlog filters. These features are powerful, but dangerous. Here you'll find out the risks, and how to mitigate them. ...
Foreign Key bugs in MySQL and MariaDB

Foreign Key bugs in MySQL and MariaDB

Foreign keys are a controversial topic. MySQL and MariaDB implementation has several bugs and limitations, that are discussed here. ...
Case sensitivity in MySQL and MariaDB queries

Case sensitivity in MySQL and MariaDB queries

Maybe you’re wondering why in MySQL/MariaDB 'string' seems to be the same as 'STRING'. Or maybe that’s not the case for you, but you would like to make a case insensitive search. This article explains how to write a case ... ...