tech/bitemporal-dbms
Richard Snodgrass “Developing time-orientede databases application in SQL” is the bible about bitemporal DB.
PG has very good extensions for bitemporal queries. In particular the “illuminated-computing” patch.
MAYBE use PG + bitemporal for Doknil temporal contexts