TimeTravel Tables in PostgreSQL

A. Elein Mustain, Managing Director, Varlena, LLC

Track: Databases
Date: Thursday, July 27
Time: 11:35am - 12:20pm
Location: Portland 252

Timetravel tables enable you to see your current data as well as your data last Thursday at exactly 2:05pm. This ability to see data at a point in time without restores can be constructed using simple PostgreSQL tools. We will show you how to implement TimeTravel tables using timestamp fields, a rule, and a couple of triggers as well as show you how to query your timetravel data effectively.