They have the technological underpinnings, but it's not properly exposed via SQL. In practice you wind up having to do it all by hand.
What the F1 guys seem to have done is said "well that's just silly, let's take advantage of it".
Oracle is my day job, I've been saved by a flashback query once. A DBA misunderstood a request I was making and applied a dev change to production.
I don't know what the logistics of keeping an infinite history are.
I'd say they're not much different than asking a database developer to be able to generate reports for any given span of time. Or keeping a complete audit trail of changes. Or, more broadly, complete website logs, complete source revision history etc etc.
That is: in theory it creates an infinite downside. In practice it is more valuable than not, especially with the ever-plunging cost of storage.
Comments
They have the technological underpinnings, but it's not properly exposed via SQL. In practice you wind up having to do it all by hand.
What the F1 guys seem to have done is said "well that's just silly, let's take advantage of it".
Oracle is my day job, I've been saved by a flashback query once. A DBA misunderstood a request I was making and applied a dev change to production.
I'd say they're not much different than asking a database developer to be able to generate reports for any given span of time. Or keeping a complete audit trail of changes. Or, more broadly, complete website logs, complete source revision history etc etc.
That is: in theory it creates an infinite downside. In practice it is more valuable than not, especially with the ever-plunging cost of storage.