4 ms·
I was expecting that presentation to be stuff you were missing, but the presentation is saying that essentially every feature they describe is implemented in Po
by saurik 10y ago
I was expecting that presentation to be stuff you were missing, but the presentation is saying that essentially every feature they describe is implemented in PostgreSQL. Of the SQL:2011 ones, only one wasn't (temporal tables), and even the SQL:2016 features had partial support (with the summary slide at the end of other features they didn't do in detail having stuff that looks familiar in a PostgreSQL context). Do you have a reference of features not in PostgreSQL you are hoping to use?
- cygned 10y agoI 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 10y agohttps://github.com/arkhipov/temporal_tables https://github.com/arkhipov/temporal_tables seems like a good option?
- cryptonector 10y agoThanks for the link!
- phonon 10y 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 10y 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 10y 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.