News for hackers. Stuff that matters.

A comment on Now that UUIDv7 is lexicographic, does that mean there is no use for ULID?. Parent comment

Re:Now that UUIDv7 is lexicographic, does that mean there is... by stop50 on Tuesday June 18, 2024 @01:38AM (#40714373)
Some databases directly support uuid, so they can save it as the binary data itself.
[ Parent | on HN ]
Re:Now that UUIDv7 is lexicographic, does that mean there is... by dagss on Tuesday June 18, 2024 @02:27AM (#40714638)
Do NOT do that with MS-SQL. The uniqueidentifier type shuffles byes around and does not give you the ordering you want.

So whether you use ULID or UUIDv7, save it as binary(16) in MSSQL.

(There is a special custom UUID implementation someone made for MSSQL that will sort time-ordered on MSQL but nowhere else; IMO that is too niche...just use binary(16)...)

[ Parent | on HN ]