News for hackers. Stuff that matters.
Re:Git as a NoSql Database (2016) by pcr910303 on Monday April 05, 2021 @09:40PM (#26707045)
> I store all my dates in sql as text in iso format so I can easily sort them

Strong SQLite vibes... (SQLite doesn't have a date format, it has builtin functions that accept ISO format text or unix timestamps)

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
Re:Git as a NoSql Database (2016) by yen223 on Tuesday April 06, 2021 @03:36AM (#26709122)
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.
Re:Git as a NoSql Database (2016) by adrianN on Tuesday April 06, 2021 @03:14AM (#26708985)
Time zone information makes this a bit tricky.
Re:Git as a NoSql Database (2016) by zikzak on Tuesday April 06, 2021 @02:36PM (#26715581)
That's a good point. We were talking MS SQL but yes, that would make way more sense.