Periods and System-Versioned Tables
You Don't Know What You're Missing
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.
- 2019 June 21 - 12:30
- 50 min
- PostgreSQL Ibiza
- Pooling Performance
- Start Time:
- 2019 June 21 12:30