Besides temporal tables, I want temporal materialized views. I needed such a thing so much so that I implemented such a thing in PlPgSQL: https://github.com/twosigma/postgresql-contrib/blob/master/p...

This lets me materialize a view and then inspect deltas between refreshes, with history, and even update the materialized view from triggers and have those changes recorded in a history table automatically.

https://github.com/arkhipov/temporal_tables seems like a good option?

Thanks for the link!

Here's two more--

http://clarkdave.net/2015/02/historical-records-with-postgre...

https://pgxn.org/dist/temporal_tables/

Time travel existed for a long time, but eventually got culled in v8 (IIRC) because not enough people were using it to justify the code complexity.