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.