Re:Git as a NoSql Database (2016)
by calvinmorrison on Tuesday April 06, 2021 @12:10AM
(#26707870)
As a Unix person, aren't dates just number? Why is sort complex? Just parse input and render timestamps
It's pretty miserable when you're trying to look up a date, and all you get are numbers that requires a conversion step to be readable.
Re:Git as a NoSql Database (2016)
by drchickensalad on Tuesday April 06, 2021 @06:59AM
(#26710392)
Assuming by number you mean epoch seconds/milliseconds, a number can store the instant in time, but not a TIMEZONE. Obviously you could do bit magic if you shift it over (so you don't mess up sorting), but that's true for any data and a sufficiently large number type.
Time zone information makes this a bit tricky.
Strong SQLite vibes... (SQLite doesn't have a date format, it has builtin functions that accept ISO format text or unix timestamps)