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.


PostgreSQL hstore: key/value in relational tables

PostgreSQL hstore: key/value in relational tables

hstore is a PostgreSQL extension that allows to store key/value pairs in relational tables and work with them. ...
Understanding tables usage with User Statistics (Percona Server, MariaDB) (→Vettabase)

Understanding tables usage with User Statistics (Percona Server, MariaDB) (→Vettabase)

Let's use Percona User Statistics to analyse our most used tables, and to look for problems where they mostly matter. ...
My community activities in 2019

My community activities in 2019

31th December post: reviewing an year of open source database community activities in London. ...
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. ...