News for hackers. Stuff that matters.

A comment on SQL Reserved Words – The Empirical List. Parent comment

Re:SQL Reserved Words – The Empirical List by refset on Wednesday October 11, 2023 @03:43PM (#37849321)
Temporal tables, most likely. Although even SQL Server only supports system time versioning, not full bitemporal tables (as per the spec).
[ Parent | on HN ]
Re:SQL Reserved Words – The Empirical List by MarkusWinand on Wednesday October 11, 2023 @04:07PM (#37849614)
The existing implementations (Oracle DB, SQL Server, MariaDB, Big Query) come with their problems too. I was a big fan of the new features when it came out in 2011, but pratically there is an unsolved elephant in the room: It doesn't cover schema changes.
[ Parent | on HN ]
Re:SQL Reserved Words – The Empirical List by refset on Wednesday October 11, 2023 @04:47PM (#37850048)
> there is an unsolved elephant in the room: It doesn't cover schema changes.

100% agreed. It's remarkable how Datomic also arrived on the scene in the same era (2012) but actually managed to solve a lot of these hard issues of immutable versioning + schema evolution via a clean EAV-based information model and an emphasis on accrete-only schema changes.

I'm a big fan of your work by the way :)

[ Parent | on HN ]