4 ms·
[Re-posting my comment from yesterday https://news.ycombinator.com/item?id=37000572 https://news.ycombinator.com/item?id=37000572] > Part of the reason it hasn
by refset 3y ago
[Re-posting my comment from yesterday https://news.ycombinator.com/item?id=37000572 https://news.ycombinator.com/item?id=37000572]
> Part of the reason it hasn’t taken off is because of the additional complexity it imposes on programmers.
My take is that it's specifically the additional complexity it imposes on _database_ programmers - the impacts across storage design, foreign keys and schema evolution when all data is bitemporal are profound. SQL:2011 introduced "temporal tables" but the design was arguably incomplete and implementing it ubiquitously requires a real re-think of database internals, so we're now over a decade on and these capabilities are still far from commonplace.
> However, I think part of the reason it hasn’t become more popular, given the benefits it brings, is just the name.
No disagreement from me there!
Disclosure: I work on xtdb.com, building a new database engine where bitemporality is the default. I also spoke with Kent about this last week and am running a webinar about bitemporality more generally on Thursday: https://attendee.gotowebinar.com/register/2960607012900067930?source=hacker-news https://attendee.gotowebinar.com/register/296060701290006793...
- refset 3y agoPeople here may also be interested to see this analysis of the state of SQL:2011 "temporal table" feature adoption: https://illuminatedcomputing.com/posts/2019/08/sql2011-survey/ https://illuminatedcomputing.com/posts/2019/08/sql2011-surve... I don't think much has really changed since, and I'm not sure Postgres is any closer to addressing this natively (although there have been extensions, e.g. https://github.com/scalegenius/pg_bitemporal https://github.com/scalegenius/pg_bitemporal).