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 (chris.cumming@saturdaymp.com) is most appreciated.
In a non-temporal database a record dose not change over time. For example say you have a Contacts table with a name field.
[Read More]