Re:ULIDs and Primary Keys
by nwah1 on Thursday December 29, 2022 @03:46PM
(#34177693)
Great article. I ended up using ULIDs recently, since I had an ORM layer that shared two different database providers (SQLite and SQL Server), and for whatever reason ULID worked when the other options didn't. Something about the differences in the blob representation of the Microsoft GUID format, which is a variant of UUID.
You can add some secret sauce on top of the ULID spec to force monotonic behavior if needed.
You can add some secret sauce on top of the ULID spec to force monotonic behavior if needed.