←back to thread

Poor man's bitemporal data system in SQLite and Clojure

(www.evalapply.org)
169 points adityaathalye | 1 comments | 03 Sep 25 17:47 UTC | HN request time: 0.001s | source
Show context
moomin ◴[03 Sep 25 18:29 UTC] No.45118981[source]▶
It's a pity that Clojure is kind of a hermetic space these days, because the concept of bitemporality really deserves much more attention. It's amazing how often you want to know "What was the P&L for March using the data available on Apr 4?" and how uncommon it is to find a database design that supports that kind of query.
replies(4): >>45120261 #>>45120290 #>>45120880 #>>45120882 #
galkk ◴[03 Sep 25 20:49 UTC] No.45120261[source]▶
Spanner does that with ease (I worked there, so I’m clearly biased).

https://cloud.google.com/spanner/docs/timestamp-bounds#exact...

replies(1): >>45120472 #
1. refset ◴[03 Sep 25 21:14 UTC] No.45120472[source]▶
That only covers the 'transaction time' axis though? And the page says retention is limited to 1 week. No doubt useful for some things, but probably not end-user reporting requirements.