Federico Razzoli, Author at Percona Community Blog

London Open Source Database Community Meetup

Federico Razzoli | March 15, 2019 | Posted In: Events, MariaDB, MongoDB, MySQL, PostgreSQL

I strongly believe in the community. Communities are the real strength of open source. Not just the theoretical ability to study, modify and share code – but the fact that other people out there are doing these things. Creating a base of knowledge and a network of relations.These can become work relationships, valuable discussions, open […]

Some Notes on MariaDB system-versioned Tables

Federico Razzoli | December 14, 2018 | Posted In: MariaDB, MySQL

As mentioned in a previous post, I gave a talk at Percona Live Europe 2018 about system-versioned tables. This is a new MariaDB 10.3 feature, which consists of preserving old versions of a table rows. Each version has two timestamps that indicate the start (INSERT,UPDATE) of the validity of that version, and its end (DELETE, […]

Percona Live Europe Presents: MariaDB System-Versioned Tables

Federico Razzoli | October 17, 2018 | Posted In: Events, MariaDB, MySQL

System-versioned tables, or temporal tables, are a typical feature of proprietary database management systems like DB2, Oracle and SQL Server. They also appeared at some point in PostgreSQL, but only as an extension; and also in CockroachDB, but in a somewhat limited fashion. The MariaDB® implementation is the first appearance of temporal tables in the MySQL […]