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)...)
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)...)