saturdaymp-examples/a-brief-history-of-the-creation-of-a-time-traveling-database

Brief example of creating a temporal database.

A Brief History of the Creation of a Time Traveling Database

A lighting talk I gave at the Edmonton PASS Speaker Idol Contest about creating a temporal database many years ago.

Quickstart

You'll need SQL Server installed to run the demos. If you have Docker installed there is a Docker Compose file to get you up and running quickly:

docker-compose up

You can then run the Schema.sql script to create the database. It has two temporal tables Customers and Addresses with triggers that enforce the temporal rules. The DemoQueries.sql has some example data and queries to play with.

Contributing

If you have any questions, notice a bug, or have a suggestion/enhancment please let me know by opening a issue or pull request.

Acknowledgements

Thanks to Edmonton PASS for inviting me to speak.