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

October 3-5, 2016

Amsterdam, Netherlands

Modern SQL in Open Source Databases

Modern SQL in Open Source Databases

 4 October 2:10 PM - 3:00 PM @ Matterhorn 1
Experience level: 
Intermediate
Duration: 
50 minutes conference
Tracks:
OSDBMS
Development
Topics:
MySQL
Programming
Fundamentals

Description

SQL has evolved beyond the relational model over the past decades and can now solve many problems more easily as compared to good old SQL-92. However, due to the limited support in open source databases, this revolution has been largely unnoticed in the open source scene. Until now. At the moment, many open source databases are adding these new features to their portfolio. This session highlights some of the most important new SQL features and compares their availability in commercial and open source databases (MariaDB, MySQL, PostgreSQL, SQLite). This session provides a brief introduction to some of these features and thus helps you in both: using your current database more effectively and choosing the right database for your next project.

Speakers

Markus Winand's picture

Markus Winand

Tuning developers for SQL performance, winand.at

Biography:

As an author, trainer, and coach Markus Winand specializes in helping developers cope with SQL performance issues. He also published the book "SQL Performance Explained" and runs the popular blog "Use The Index, Luke!"

Share this talk


Slides