4 ms·
I really would like to use Temporal Tables (slides 137 and following) to say like 'give me the record of last week'. I can of course do that already manually,
by cygned 9y ago
I really would like to use Temporal Tables (slides 137 and following) to say like 'give me the record of last week'.
I can of course do that already manually, but it is tedious and I hope it will be faster if implemented directly.
- phonon 9y agohttps://github.com/arkhipov/temporal_tables https://github.com/arkhipov/temporal_tables seems like a good option?
- cryptonector 9y agoThanks for the link!
- phonon 9y agoHere's two more-- http://clarkdave.net/2015/02/historical-records-with-postgresql-and-temporal-tables-and-sql-2011/ http://clarkdave.net/2015/02/historical-records-with-postgre... https://pgxn.org/dist/temporal_tables/ https://pgxn.org/dist/temporal_tables/
- cryptonector 9y agoBesides 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/pseudo_mat_views.sql 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.
- rodgerd 9y agoTime 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.