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.

Practical advice for MySQL/MariaDB live migrations

Practical advice for MySQL/MariaDB live migrations

Modifying table structures is sometimes necessary, or desirable. Modifying them online can be a pain, especially with big tables. Migrations should be ran properly in production. ...
PostgreSQL hstore: key/value in relational tables

PostgreSQL hstore: key/value in relational tables

hstore is a PostgreSQL extension that allows to store key/value pairs in relational tables and work with them. ...
Understanding tables usage with User Statistics (Percona Server, MariaDB)

Understanding tables usage with User Statistics (Percona Server, MariaDB)

Let's use Percona User Statistics to analyse our most used tables, and to look for problems where they mostly matter. ...
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. ...