Thanks for a very interesting interview, was curious if I can find a working production ready (battle tested etc) bitemporal db? or an extension / engine for PostgressDB / MySQL that enables this? Sounds really interesting.
The only one I'm aware of is XTDB. There's an interview about that here: th-cam.com/video/3sRKQg9-In8/w-d-xo.html (As Ben suggests, you _can_ build bitemporality into a regular database just by adding two timestamp columns and constructing the queries correctly. But XTDB is the only one I know of that actually tackles the parts of the SQL spec that make it easy.)
Ooh, this news just in. Vik Fearing has done some work adding support into Postgres. Anything from Vik is worth checking out: twitter.com/pg_xocolatl/status/1680932577115361280
Wonderful conversation...🎉
Thanks for a very interesting interview, was curious if I can find a working production ready (battle tested etc) bitemporal db? or an extension / engine for PostgressDB / MySQL that enables this? Sounds really interesting.
The only one I'm aware of is XTDB. There's an interview about that here: th-cam.com/video/3sRKQg9-In8/w-d-xo.html
(As Ben suggests, you _can_ build bitemporality into a regular database just by adding two timestamp columns and constructing the queries correctly. But XTDB is the only one I know of that actually tackles the parts of the SQL spec that make it easy.)
Ooh, this news just in. Vik Fearing has done some work adding support into Postgres. Anything from Vik is worth checking out: twitter.com/pg_xocolatl/status/1680932577115361280