This site is about a previous instance of this event. For the current event, please see the updated site.

Conference Schedule - PGConf.EU 2016

Modern SQL in Open-Source and Commercial Databases

Date: 2016-11-03
Time: 12:50 - 13:40
Room: Alfa 1
Level: Intermediate

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. Unfortunately, this revolution has been unnoticed by many developers because “the most popular open-source database” (MySQL) still doesn’t support them. Until now. The upcoming MariaDB 10.2 release gets window functions and at least non-recursive WITH clauses and might thus spark interested in modern SQL features in many developers.

In this session, I’ll go through some of those SQL features and compare their current and near-future availability in open-source and commercial SQL databases. It becomes obvious that PostgreSQL’s feature set is actually closer to those of commercial databases.


Markus Winand