It's worth mentioning that UUIDv1 and CombGuids have a time component... MS SQL Server, for example serializes with the time component first, which optimizes indexing/sorting. SQL Server itself has a sequential guid type that can be used as a primary key that includes features of the ULID as well.
I often wish that other database servers would support this serialization/deserialization structure for UUID types. As it would be beneficial to performance.
tracker1 1119 days ago. link 1 point ▲ ▼