gosha2d ago

Has anyone done #bitemporal stuff with postgres 16? I understand SQL:2011 support has landed in postgres 18 but I'm hesitant about upgrading (being very conservative). I'm aware of https://github.com/scalegenius/pg_bitemporal and https://github.com/xocolatl/periods but I'm no database expert and I feel like a baby engineer dipping my toes in. What do y'all recommend?

(I don't want to use #xtdb or #datomic because I know even less about these and I want to be able to maintain what I build)

Show threadgosha2d ago
I wish I had the time to read the foundational text: https://www2.cs.arizona.edu/~rts/tdbbook.pdf
Show threadgosha
the author of scalegenius/pg_bitemporal sounds awesome: https://hdombrovskaya.wordpress.com/about-the-author/
About the author

My name is Henrietta (Hettie) Dombrovskaya, and information management is my real passion. I was born in Saint Petersburg, Russia (actually, back then – Leningrad, USSR), and graduated from t…

The World of Data
May 11 at 2:29pmWeb
Show threadgosha2d ago
Actually even pg18 doesn't have full bitemporal support. So I guess I can stick to 16 for now!
Show threadgosha1d ago
This shit is breaking my brain. Why can't jdbc understand tstzrange natively? Why make me parse a pgobject for it? 🤪
Show threadgosha1d ago
Ohh I get it, the problem was that I wasn't listening to enough Phish
Show threadgosha21h ago
Reticulating some serious splines and decomplecting in real hammock-time today
Show threadgosha18h ago
I gotta say I feel pretty smug to be able to reference "the Dombrovskaya implementation" in casual banter
Show threadgosha17h ago
clojure clojure clojure clojure clojure clojure
Show threadgosha17h ago
approved and merged my own PR 👈😎👈
Show threadAlex M2d ago
@gosha Ok. Without whole thread context I've jumped to write something like "There is no PG18 in US rating system only NC-17". But now I think it is more like Futurama moment "Oh, now I'll need a fake ID to buy ultra-porn."
Show threadgosha2d ago
@fido_node ahaha