Temporal Journey
Channel: PostgresConf South Africa
Date: 2019-11-21

Andrew Turpin

PostgresConf South Africa 2019

https://postgresconf.org/conferences/SouthAfrica2019/program/proposals/temporal-journey

This journey is an exploration of time range data using history tables in a scenario where micro-services utilising PostgreSQL databases rely on logical replication to publish to an eventually consistent canonical database.

The desired solution would allow for history tables to be automatically dealt with in the canonical database through temporal_tables & trigger magic and logical replication.