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.

Working with JSON arrays in MySQL/MariaDB

Working with JSON arrays in MySQL/MariaDB

When you write stored procedures in MySQL or MariaDB, one of the missing features is an ARRAY type. But actually, it is possible to create arrays by using the JSON type. This article explains how to work with JSON arrays. ...
Variable number of parameters and optional parameters in MySQL/MariaDB procedures

Variable number of parameters and optional parameters in MySQL/MariaDB procedures

MySQL and MariaDB don't allow optional parameters for stored procedures, nor procedures accepting any number of parameters. However, these features can be emulated by passing JSON documents. Let's see how. ...
Updating triggers online with MySQL and MariaDB

Updating triggers online with MySQL and MariaDB

Changing triggers in production is problematic, because for a short time triggers will be missing, or inconsistent with each other. This article proposes a solution to resolve the problem. ...