2 ms·
Very cool. For a long time I've wanted databases to support this so I could run query This has been in Oracle for a few years now https://docs.oracle.com/cd/B2
by gaius 10y ago
Very cool. For a long time I've wanted databases to support this so I could run query
This has been in Oracle for a few years now https://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns_flashback.htm#i1008579 https://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns...
- toyg 10y agoYup, but it's one of those things where you need the most expensive license, IIRC.
- gaius 10y agoI'm a little bemused by I’m not aware of any database that has implemented it You would need to be hiding under a rock, like a cockroach I suppose, not to know that Oracle and SQL Server 2016 have this :-)
- toyg 10y agoI think we've reached a point where a lot of OSS folks never actually touched a commercial database in their life. OSS alternatives are so good that less and less people feel the need to go out and pay for something better. In a way it's similar to some folks going crazy because you can do this or that in the browser when desktop OSes have been able to do it for ages... generational shifts.
- gaius 10y agoCertainly modern open source DBs are very capable... It is just a little frustrating to see the wheel being reinvented rather than genuine progress being made. And the big commercial DBs aren't standing still either.
- deleted 10y ago[deleted]
- mjibson 10y agoI think CockroachDB is making genuine progress in the distributed, consistent space. We now have to add many of the existing features on top of that.
- mjibson 10y agoI searched for the syntax listed in the standard and didn't find it in production use anywhere else. I've used MSSQL in production before (last time in 2015) but never Oracle. I'm happy to now know that other SQL DBs have this feature.