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.

Monitoring that AUTO_INCREMENT values don’t reach the limit

Monitoring that AUTO_INCREMENT values don’t reach the limit

On 5 May 2020, GitHub had a 2 hours and 24 minutes downtime caused by AUTO_INCREMENT values. Let's see how to avoid these incidents. ...
DROP TABLE improvements in MariaDB

DROP TABLE improvements in MariaDB

MariaDB made several improvements to the DROP TABLE statement. ...
MariaDB RETURNING Statements

MariaDB RETURNING Statements

MariaDB supports INSERT RETURNING and DELETE RETURNING, which help avoid an additional SELECT. ...
Do languages need NULL? – Rust example

Do languages need NULL? – Rust example

Rust shows the correct way to implement NULL in a programming language. ...
Webinar: Database Design most common pitfalls

Webinar: Database Design most common pitfalls

It's easy to see antipatterns in production databases. Our schemas should be simple but extensible, and allow fast SQL queries. In this webinar I discuss what most common antipatterns are, and how to correct them. ...