3 ms·
Some databases directly support uuid, so they can save it as the binary data itself.
by stop50 2y ago
Some databases directly support uuid, so they can save it as the binary data itself.
- dagss 2y agoDo 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)...)