PGCon2009 - Final Release
PGCon 2009
The PostgreSQL Conference
Speakers | |
---|---|
Chris Browne |
Schedule | |
---|---|
Day | Talks - second day - 2009-05-22 |
Room | DMS 1110 |
Start time | 13:30 |
Duration | 01:00 |
Info | |
ID | 151 |
Event type | Lecture |
Track | Advanced Features |
Language used for presentation | English |
PostgreSQL and Temporal Data
PostgreSQL has had support for storage of temporal data, including a "time travel" capability, since even before it was called PostgreSQL, and PostgreSQL offers a fairly good set of operators to work on temporal data, at least when comparing with SQL standards.
This talk describes several of the ways that PostgreSQL may be used to record temporal data, along with advantages and disadvantages.
This talk will discuss:
What sorts of functionality "base" PostgreSQL offers;
What temporal functionality is added by the PGTemporal project (e.g. - the "period" type, comprising (from/to))
Additional functionality that would be desirable (e.g. - temporally-aware foreign keys)
Other useful representations of temporality, and their usage:
- Pointers to transactions
- Serial Number temporality