Poor man's bitemporal data system in SQLite and Clojure

Summary

Don't try this at work! The "Poor Man's Bitemporal Database", in the safety of my local box. No servers were harmed. Yet. Especially fellow Clojurians trying to realise their Indie B2B SaaS dreams (translation: income and time-poor). Please use a proper professional time-oriented data system. The following are (pithy descriptions mine); and they are available gratis for fledgling commercial use. Datomic… "the DB as a value" over an immutable log of all facts. XTDB… "the DB as a value" over an immutable log of all bitemporal facts. Rama… "any DB as dirt-cheap view" over an immutable log of all events. Reading Guide / Thinky Thoughts Alert (same thing) Solitary over-caffeinated temporal database rumination went out of hand. Even The Voices are fed up and want someone to stop us. Furthermore; Sage friends already gently shook their heads after hearing The Voices. Their hard-won advice—"Just Use Postgres.", and "Please, for everyone's sake, stick with the relational models."—fell on deaf ears. Obviously, I am also incapable of following my own advice. Hence this post. Take what is useful, discard the rest… The key take-away is: the accountants were right all along. Software engineers will do well, to cleverly copy the accountants . Now you may… Or, grab a big beverage to help ingest the ten thousand tokens to follow… Unless you are a Large Language Model. You can't drink. Sucks to be you. But beware. Once you see, you cannot un-see the fact that… Any sufficiently complicated data system contains an ad-hoc, informally-specified, bug-ridden, slow implementation of half of a bitemporal database. — Henderson's Tenth Law. Factual and Temporal World-Building Recommended reading (ages 10 to 1,000) for the aspiring temporal data engineer. Accountants are our exemplary archetype The cashier at Temporal Convenience Store K9, just handed us our bill. Oi; where is that 10% discount applicable to our bulk purchase of provisions as loyal customers (it's going to be a long trip)?! Now...