5 ms·
I wished they would implement more from SQL:2011. I have a lot of applications that would benefit from system versioned tables. This is a good sum up of useful
by cygned 9y ago
I wished they would implement more from SQL:2011. I have a lot of applications that would benefit from system versioned tables.
This is a good sum up of useful modern SQL features: https://www.slideshare.net/MarkusWinand/modern-sql https://www.slideshare.net/MarkusWinand/modern-sql
- Tostino 9y agoGet involved in the mailing list and start discussion on these features and how they would help you.
- cygned 9y agoI fear I cannot contribute a lot in my extremely limited time. Is there a 'getting started' guide somewhere?
- Tostino 9y agoHonestly you don't even have to submit a single patch to contribute. Here is the developer's FAQ: https://wiki.postgresql.org/wiki/Developer_FAQ https://wiki.postgresql.org/wiki/Developer_FAQ I know the feeling of having extremely limited time, i'm in the same boat. But I use Postgres every day with my startup, and we lean very heavy on the database (not by volume of data, just by complexity of the problems). I've reviewed a few patches that I wanted to see get into Postgres, and contributed to discussions on the mailing list. That's about the extent I am able to do at the moment, but it's better than nothing. More reviewers are never a bad thing.
- saurik 9y agoI 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 9y 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 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.
- baq 9y agothis slide deck is pure gold, just what i needed. thanks!
- cygned 9y agoGlad I could help! Here's the recording for that very presentation, by the way. https://www.youtube.com/watch?v=8wMybGTlf8I https://www.youtube.com/watch?v=8wMybGTlf8I