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)

I wish I had the time to read the foundational text: https://www2.cs.arizona.edu/~rts/tdbbook.pdf
@gosha Wow! I remember reading this in 2014, or so. If I remember correctly, the schema implementation is simple (just four timestamps), and the difficulty is working with the semantics in your application... I hope a library's been written since then! 🫡