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.


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

Let's use MariaDB 10.3 stored aggregate functions to implement a geometric mean. ...
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. ...