Welcome to Federico-Razzoli.com

Most of Federico-Razzoli.com articles
are slowly being moved to Vettabase.com,
and in particular Vettabase blog.

This website will eventually contain my personal views and personal projects.
New contents will not necessarily be technical.


Dropping database objects in a safe way (→Vettabase)

Dropping database objects in a safe way (→Vettabase)

Whenever I worked as a DBA, I was reasonably scared by 💧DROP commands. Don’t get me wrong: despite this, I badly wanted to drop obsolete tables. After that, I could more easily ask developers to fix bad practices, like tables ... ...
Circular tables in MariaDB

Circular tables in MariaDB

Let's create a table that always contains a fixed amount of rows, using MariaDB 10.3. ...
The perils of ALTER TABLE in MySQL/MariaDB

The perils of ALTER TABLE in MySQL/MariaDB

ALTER TABLE is often necessary, but it can be risky in a production environment for many reasons. Let's discuss the problems that one has to take into account. ...
What does NULL mean in SQL? (→Vettabase)

What does NULL mean in SQL? (→Vettabase)

Does NULL mean "no value"? Or does it mean "an unknown value"? Its semantics and history are ambiguous and inconsistent. ...
Searching a phone book and copying names

Searching a phone book and copying names

Why developers need to learn the basics of query optimisation. How to make the learning process easy and pleasant. ...