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.


READ ONLY transactions in MySQL (→Vettabase)

READ ONLY transactions in MySQL (→Vettabase)

MySQL transactions can be read only. Here's how to use them, and why they are useful. ...
Cassandra error on login: Cannot achieve consistency level LOCAL_ONE

Cassandra error on login: Cannot achieve consistency level LOCAL_ONE

Cassandra login fails with: "Cannot achieve consistency level LOCAL_ONE"? Let's see why it happens, and how to solve the problem ...
Why MySQL tables need a primary key (→Vettabase)

Why MySQL tables need a primary key (→Vettabase)

In MySQL and MariaDB, all tables should have a primary key - especially InnoDB tables - this is almost common wisdom. But why? Let's discuss the reasons. ...
MySQL/MariaDB: use SQL properly to run less queries (→Vettabase)

MySQL/MariaDB: use SQL properly to run less queries (→Vettabase)

Reducing the number of queries is important. The article describes how to use the SQL language more expressively (in MySQL) to achieve the purpose. ...
How to return random rows from a table

How to return random rows from a table

Returning random rows in a random order from a relational database is a very hard problem. In this article we will see an antipattern, we will discuss why this problem is so hard, and we'll examine some imperfect solutions. ...