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: 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. ...
Paginating the results of an SQL query

Paginating the results of an SQL query

One of the trickiest problems in SQL is to query rows in tranches. This is typically needed in a website search, or in a dynamic catalogue where products appear as you scroll down. You want the DBMS to only return ... ...
London Open Source Databases meetups in July 2019

London Open Source Databases meetups in July 2019

In July, London Open Source Databases group will see a meetup with Peter Zaitsev and one with Monty Widenius. ...
MySQL stored procedures: all ways to produce an output

MySQL stored procedures: all ways to produce an output

There are many non-obvious ways to return values from MySQL stored procedures, and each of them solves particular problems. ...