4 ms·
Blog post OP here. I originally wrote that I wasn't aware of any other DB that had this. I should have specified any other SQL DB, since I was aware of Datomic
by mjibson 10y ago
Blog post OP here.
I originally wrote that I wasn't aware of any other DB that had this. I should have specified any other SQL DB, since I was aware of Datomic.
While working on this feature I searched on Google for the syntax specified ("AS OF SYSTEM TIME"), but didn't find it referenced except about a third-party Postgres extension. It is unfortunate that Oracle and MSSQL didn't come up in my searching, since they support this feature.
I've edited the blog post to be more accurate in listing some of the previous work.
- baq 10y agoi'm still surprised that not a single link to https://en.wikipedia.org/wiki/Temporal_database https://en.wikipedia.org/wiki/Temporal_database is present anywhere either here or in your post. on that page there's a link to a very in-depth treatment of the problem: http://www.cs.arizona.edu/people/rts/tdbbook.pdf http://www.cs.arizona.edu/people/rts/tdbbook.pdf.
- mjibson 10y agoThat's the first link under the link to the SQL:2011 section about this, so it's not too difficult to get to there.