Gianni works at 2ndQuadrant as Global Head of Professional Services, and as a
PostgreSQL and PostGIS consultant.
Before that, he worked at the University of Florence as a researcher in Mathematics, using
Free Software since 1997.
He has been a board member of the Italian PostgreSQL User Group (ITPUG) and helped
organising the first European PGDay in Prato, Italy (2008) and many editions of the the
He is an author of the last two editions of the PostgreSQL Administration Cookbook.
Workshop : PostgreSQL Security
Identifying database security breach points is the first step towards improving your
infrastructure so that you don’t become a victim of malicious attack due to preventable
This training course will highlight the importance of database security in the following areas:
● Operating System Security
● Network Security Strategy
● User Authentication Levels
● Schema Level Security
● Data Encryption
● Backup Security
● Row Level Security
● SCRAM authentication
Presentation : Advanced SQL For Application Developers
In this talk we will review advanced SQL capabilities provided by PostgreSQL, with particular focus on features such as INSERT … ON CONFLICT, Grouping Sets, Transaction Isolation and Window Functions. We will consider both language clarity and performance gains. In fact, these two topics are not entirely separate. As a declarative language, SQL allows developers to solve a given problem simply by describing it, rather than implementing an algorithm which would be expected to provide a solution. By using new, clearer syntax we offer more options to the query optimiser, at the same time reducing the potential for bugs due to user misunderstandings.