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.

Primary Key in InnoDB: how they work and best practices

Primary Key in InnoDB: how they work and best practices

How primary key are implemented in InnoDB, and how to build fast primary keys. ...
MariaDB Stored Aggregate Functions by examples

MariaDB Stored Aggregate Functions by examples

MariaDB 10.3 supports stored aggregate functions. Let's see how to create them with examples. ...
3 good reasons to use Stored Procedures

3 good reasons to use Stored Procedures

Stored procedures are considered slow and not scalable, especially in the MySQL world. But in some cases they can increase an application speed and scalability. ...
MySQL/MariaDB: run less queries! (thanks to performance_schema)

MySQL/MariaDB: run less queries! (thanks to performance_schema)

Do you want to improve your application's and database server's performance? Remove useless queries. Yes, you probably have them. ...
Working with JSON objects in MySQL/MariaDB

Working with JSON objects in MySQL/MariaDB

MySQL JSON types has a rich set of functions. This allows us to use JSON to simulate native objects. ...