This post is part of a larger discussion about temporal databases. Hopefully it stands on it’s own but for more context see the Temporal Database Design page. You can read the official Wikipedia definition but for our purposes a Temporal Database is a database where you can query for historical data using SQL. This is work in progress and constructive feedback via e-mail, at chris.cumming@saturdaymp.com, is most appreciated.
In the last Temporal Database post I introduced timelines. In this post we will talk about the one rule you cannot break:
[Read More]