News for hackers. Stuff that matters.

A comment on Understanding How UUIDs Are Generated. Parent comment

Re:Understanding How UUIDs Are Generated by lazulicurio on Wednesday September 30, 2020 @10:24PM (#24646617)
I "independently invented" ULIDs for a past work project.

Not a criticism, but something to be aware of, is that SQL Server doesn't sort the uniqueidentifier data type as one would expect. Instead of being ordered by bytes 0-1-2-3-4-5-6-7-8-9-10-11-12-13-14-15, uniqueidentifier values are ordered by bytes 10-11-12-13-14-15-8-9-7-6-5-4-3-2-1. So you want the timestamp in the last 48 bits instead of the first 48 bits.

[ Parent | on HN ]
Re:Understanding How UUIDs Are Generated by Vanderson on Thursday October 01, 2020 @10:05AM (#24650892)
Well, this is beyond my ability to grok.

Does this apply to ULIDs?

[ Parent | on HN ]
Re:Understanding How UUIDs Are Generated by lazulicurio on Thursday October 01, 2020 @11:41AM (#24652185)
It will, but looking at the SQL Server implementation[1] it looks like they're already aware of that.

[1] https://github.com/rmalayter/ulid-mssql

[ Parent | on HN ]