It's about time – Approaching bitemporality
javahippie.net
It's about time – Approaching bitemporality
1–10 of 18 posts
Re: It's about time – Approaching bitemporality
#2No post body was provided.
Re: It's about time – Approaching bitemporality
#3Quoted post unavailable.
"Please don't pick the most provocative thing in an article or post to complain about in the thread. Find something interesting to respond to instead."
"Please don't complain about tangential annoyances—things like article or website formats, name collisions, or back-button breakage. They're too common to be interesting."
Re: It's about time – Approaching bitemporality
#4It looks like I might get flagged for this, please show me some love Dang, I’m only trying to be helpful to the author.
> What is bitemporality?
You have this as a header but I’m really bummed out that the article doesn’t have a sentence that begins with “bitemporality is..” I think some illustrations to accompany your ideas might go a long way as well, as I still have no idea what bitemporality is in this scenario, although it sounds cool.
> The “bi” in bitemporal database hints at the fact, that for the use case described above we have two different times we’d like to track: On one axis we have the validity of the data.
I genuinely don’t mean to be rude, only to provide constructive feedback. This section kind of broke my flow, because you’re implying that validity is a form of time: “ two different times we’d like to track: On one axis we have the validity.” Is that intended?
Re: It's about time – Approaching bitemporality
#5It looks like I might get flagged for this, please show me some love Dang, I’m only trying to be helpful to the author. > What is bitemporality? You have this as a header but I’m really bummed out that the article doesn’t have a sentence that begins with “bitemporality is..” I think some illustrations to accompany your ideas might go a long way as well, as I still have no idea what bitemporality is in this scenario,…
There's the valid time on the one hand when something is valid in the real world and the transaction time, the time at which it's known to the database system, when it's recorded/committed.
Re: It's about time – Approaching bitemporality
#6It looks like I might get flagged for this, please show me some love Dang, I’m only trying to be helpful to the author. > What is bitemporality? You have this as a header but I’m really bummed out that the article doesn’t have a sentence that begins with “bitemporality is..” I think some illustrations to accompany your ideas might go a long way as well, as I still have no idea what bitemporality is in this scenario,…
> I think some illustrations to accompany your ideas might go a long way as well
I'm not the OP, but I built this visual tool recently which might be of interest https://bitemporal-visualizer.github.io/
Re: It's about time – Approaching bitemporality
#7It looks like I might get flagged for this, please show me some love Dang, I’m only trying to be helpful to the author. > What is bitemporality? You have this as a header but I’m really bummed out that the article doesn’t have a sentence that begins with “bitemporality is..” I think some illustrations to accompany your ideas might go a long way as well, as I still have no idea what bitemporality is in this scenario,…
> I think some illustrations to accompany your ideas might go a long way as well I'm not the OP, but I built this visual tool recently which might be of interest https://bitemporal-visualizer.github.io/
A picture really is worth a thousand words. I totally get what bitemporality means now.
Re: It's about time – Approaching bitemporality
#8It looks like I might get flagged for this, please show me some love Dang, I’m only trying to be helpful to the author. > What is bitemporality? You have this as a header but I’m really bummed out that the article doesn’t have a sentence that begins with “bitemporality is..” I think some illustrations to accompany your ideas might go a long way as well, as I still have no idea what bitemporality is in this scenario,…
Author here. Thanks for pointing this out, I obviously did not manage to provide a good definition of the term and will update the section accordingly
Re: It's about time – Approaching bitemporality
#9Note that Postgres has built in range types which makes much of this cleaner. See https://www.postgresql.org/docs/15/rangetypes.html#RANGETYPE...
Re: It's about time – Approaching bitemporality
#10Isn't this the use case for event sourcing?