Presented by:

C00a0533b2e692a4d8ae69f855094fd0
Vik Fearing
from PostgreSQL International Community

Vik Fearing is a full-time PostgreSQL consultant, auditor, and trainer based in Paris, France.

He is the co-organizer of the annual pgDay Paris, and an active member of the worldwide community (mostly on irc under the name xocolatl).

No video of the event yet, sorry!

SQL:2011 introduced the concept of a Period. These can be used for many things but the most well-known application is system versioned tables where all changes to a table are recorded and can be summoned via SQL.

PostgreSQL is one of the last databases to be missing this feature (even MariaDB has them). In this presentation we will see the many different ways periods can be used, and talk about the current status of their implementation.

We will also see a fully functional extension that simulates most of the features that the SQL standard provides for periods but obviously without the standard syntax. My goal with this talk is to promote awareness and advocacy for why we need these features in core PostgreSQL and to attempt to recruit people to help implement them.

Date:
2019 June 21 - 12:30
Duration:
50 min
Room:
C2
Conference:
PostgreSQL Ibiza
Language:
English
Track:
Difficulty:
Easy

Happening at the same time:

  1. Pooling Performance
  2. Start Time:
    2019 June 21 12:30

    Room:
    C1