Percona Live: Open Source Database Performance Conference - Amsterdam 2016 Logo

October 3-5, 2016

Amsterdam, Netherlands

Federico Razzoli


Federico Razzoli's picture

Federico Razzoli

Consultant, Percona


Biography:

Relational databases lover and open source supporter. I am a MariaDB Community Ambassador and I wrote "Mastering MariaDB" in 2014. Currently I work for Percona.


Sessions

5 October 4:25 PM - 5:15 PM at Zürich 1
MariaDB 5.2 and MySQL 5.7 introduced virtual columns, with different implementations. Their features and limitations are similar, but not identical. The main difference is that only MySQL allows you to build an index on a non-persistent column. In this talk we'll present some use cases for virtual columns, such as query simplification and UNIQUE constraints based on an SQL expression.... [read more]
4 October 7:30 PM - 8:30 PM
Writing a slow and buggy stored procedures for MySQL is easy and intuitive. In this lightning talk we will review the practice to better write a very low quality procedure. Once you know these rules, you can also choose to break them and try to write a good procedure.