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.


MySQL/MariaDB: Using views to grant or deny row-level privileges (→Vettabase)

MySQL/MariaDB: Using views to grant or deny row-level privileges (→Vettabase)

Relational DBMSs allow to grant users permissions on certain tables or columns. Here we'll discuss how to restrict access to a certain set of rows. ...
The dangers of replication filters in MySQL

The dangers of replication filters in MySQL

MySQL supports replication filters and binlog filters. These features are powerful, but dangerous. Here you'll find out the risks, and how to mitigate them. ...
Foreign Key bugs in MySQL and MariaDB

Foreign Key bugs in MySQL and MariaDB

Foreign keys are a controversial topic. MySQL and MariaDB implementation has several bugs and limitations, that are discussed here. ...
Case sensitivity in MySQL and MariaDB queries

Case sensitivity in MySQL and MariaDB queries

Maybe you’re wondering why in MySQL/MariaDB 'string' seems to be the same as 'STRING'. Or maybe that’s not the case for you, but you would like to make a case insensitive search. This article explains how to write a case ... ...
Optimising or fixing SQL queries: how to ask for help

Optimising or fixing SQL queries: how to ask for help

If you need free help or paid support, you should phrase your questions correctly and provide the necessary information. ...