4 ms·
You could also "just" have an internal-use only numeric ID, or use a UUIDv7.
by hardwaresofton 1y ago
You could also "just" have an internal-use only numeric ID, or use a UUIDv7.
- sam_lowry_ 1y agoor ULIDs or any other partially sortable ids.
- sebazzz 1y agoULID are not necessarily sortable, just UUIDs consensed in a shorter string by using more characters than 0-9A-F
- sam_lowry_ 1y agoULID = Unique Lexicographically sortable IDentifier ;-)
- jszymborski 1y agoULIDs are sorta the opposite of the HMAC method, where you can't query for the nth ID, but you can sort the IDs.
- redhale 1y agoTIL about UUIDv7 -- thanks!
- hardwaresofton 1y agoNo worries! It's just now finally starting to get everywhere -- Postgres is going to get it in 18 by the looks of things :) https://www.postgresql.org/docs/18/functions-uuid.html https://www.postgresql.org/docs/18/functions-uuid.html