Archives: Projects

php[tek] – Making the most out of MySQL

Conference: php[tek] 2018

Location: Atlanta, USA

Language: English

Abstract

MySQL 5.7 is two years old, and adoption is growing. The new JSON data type shines as the most talked feature in this version. But, they are by no means the only awesome thing it has to offer.

Learn how to manipulate JSON fields and how generated columns can help you index data and more. This talk will teach you how to properly do a GROUP BY without being stuck in the new default mode of MySQL 5.7. Changing the default won’t solve your problem. It’s a temporary fix to hide something much more significant: the code that needs to be fixed.

Generated columns are a concept available in databases such as Oracle and MS SQL Sever. MySQL, however, is one of the biggest open source databases to implement it and this is very helpful when using JSON data types.

Knowledge of JSON data type is required for this talk.

Diving into MySQL 5.7: advanced features

Conference: Midwest PHP 2018

Location: Minneapolis, USA

Language: English

Abstract

Since launch, this current version of MySQL have new features such as: JSON Data Type and Generated/Virtual Columns,. If your application is breaking when you upgrade to 5.7, the new GROUP BY default may be the reason, learn here how to properly address that issue and keep your data consistent, how to index JSON data type and when to use generated columns.