Past Events

July 2018

PGConf UK – London, United Kingdom – 2018-07-03

Standard SQL features where PostgreSQL beats its competitor

The SQL standard has more than 4300 pages and hundreds of optional features. The number of features offered by different products varies vastly. PostgreSQL implements a relatively large number of them.

In this session I present some standard SQL features that work in PostgreSQL, but not in other popular open-source databases. But when it comes to standard conformance, PostgreSQL doesn’t even need to fear the comparison to its commercial competitors: PostgreSQL also supports a few useful standard SQL features that don’t work in any of the three most popular commercial SQL databases.

Reactions:

June 2018

Austrian Oracle User Conference – Vienna, Austria – 2018-06-12

Row Pattern Matching — Datenanalyse auf neuem Level

Das Erkennen von Mustern in Zeitreihen wurde durch die MATCH_RECOGNIZE-Klausel in Oracle 12c erheblich vereinfacht. Leider ist diese Klausel unter Entwicklern noch wenig bekannt und wird daher kaum genutzt. Dieser Vortrag führt in das Thema ein und zeigt einige typische (und weniger typische) Anwendungen, die sich mit MATCH_RECOGNIZE wesentlich einfacher lösen lassen als mit anderen SQL-Funktionen.

May 2018

PgCon.org – Ottawa, Canada – 2018-05-31 - 2018-06-01

Standard SQL Gap Analysis: Standard SQL features where PostgreSQL lags behind its competitors

PostgreSQL supports an impressive number of standard SQL features in an outstanding quality. Yet there remain some cases where other databases exceed PostgreSQL’s capabilities in regard to standard SQL conformance.

This session presents the gaps found during an in-depth comparison of selected standard SQL features among six popular SQL databases. The selected features include, among others, window functions and common tables expressions—both of them were recently introduced to MySQL and MariaDB.

The comparison uses a set of conformance tests I use for my website modern-sql.com. These tests are based on the SQL:2016 standard and attempt to do a rather complete test of the requirements set out in the standard. This includes the correct declared type of expressions as well as the correct SQLSTATE in case of errors (teaser: nobody seems to care about SQLSTATE).

This presentation covers two aspects: (1) features not supported by PostgreSQL but by other databases; (2) features available in PostgreSQL that are less complete or conforming as in other databases.

Slides: https://modern-sql.com/slides/pgcon-2018-gap-analysis.pdf

GeeCON – Kraków, Poland – 2018-05-10

Modern SQL: Evolution of a dinosaur

With these topics: WITH, WITH RECURSIVE, OVER, XMLTABLE, FETCH FIRST, OFFSET, System Versioning, LISTAGG.

Video recording: Coming soon.

Reactions:

Axel Fontaine on Twitter

Excellent talk on SQL by @MarkusWinand

Voted #1 talk of the conference by the audience.

April 2018

German: Grazer Linux Tage – Graz, Austria – 2018-04-28

Modernes SQL in Open-Source Datenbanken

With these topics: WITH, WITH RECURSIVE, GROUPING SETS, FILTER, BOOLEAN tests, OVER, System Versioning.

Video recording: YouTube, ccc.de.

March 2018

Voxxed Days Vienna – Vienna, Austria – 2018-03-12 – 2018-03-13

Modern SQL: A lot has changed since SQL-92

With these features: WITH, WITH RECURSIVE, GROUPING SETS, FILTER, OVER, FETCH FIRST, OFFSET, System Versioning, MATCH_RECOGNIZE

Video recording: YouTube.

Reactions:

@blalasaadri auf Twitter

After watching the talk by @MarkusWinand at #VoxxedVienna I am aware that I don't know #SQL.

@michaeltecourt auf Twitter

Great talk about modern SQL, so much knowledge packed in a 1h session

@GottfriedSzing auf Twitter

Maybe that's the reason I haven't seen FILTER in the wild #voxxedvienna

Connect with Markus Winand

Markus Winand on LinkedInMarkus Winand on XINGMarkus Winand on Twitter