Re:Poor man's bitemporal data system in SQLite and Clojure
by sterlinm on Wednesday September 03, 2025 @11:40PM
(#45123286)
This is the book I like for an overview of the problem. https://www.amazon.com/Temporal-Relational-Kaufmann-Manageme...
In a bitemporal database, every regular looking join over the current state of the world is secretly an AsOf join (across two dimensions of time), without constantly having to think about it when writing queries or extending the schema.