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.

When to use NULLable columns in relational databases

When to use NULLable columns in relational databases

There are cases when using NULL in an SQL database is desirable. However, there are always alternatives. ...
Webinar: JSON in MySQL and MariaDB databases

Webinar: JSON in MySQL and MariaDB databases

Webinar on 6th March 2020: JSON in MySQL and MariaDB databases. ...
PostgreSQL Features Missing in Amazon Redshift

PostgreSQL Features Missing in Amazon Redshift

Many PostgreSQL features are not available in Redshift, particularly those which are not suitable for a database cluster or for analytics, and those that Amazon didn't consider important enough to spend the necessary resources to maintain them. ...
Testing database backups

Testing database backups

Backups need to be tested to avoid epic incidents like the one occurred to GitLab in 2017. But how should they be tested, and what should we monitor exactly? ...
Use cases for MariaDB Invisible Columns

Use cases for MariaDB Invisible Columns

Invisible columns are columns that are not returned by a SELECT *. Their use cases are not obvious. ...