Comment by hardwaresofton 7 months ago You could also "just" have an internal-use only numeric ID, or use a UUIDv7. 6 comments hardwaresofton Reply redhale 7 months ago TIL about UUIDv7 -- thanks! hardwaresofton 7 months ago No 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 sam_lowry_ 7 months ago or ULIDs or any other partially sortable ids. sebazzz 7 months ago ULID are not necessarily sortable, just UUIDs consensed in a shorter string by using more characters than 0-9A-F sam_lowry_ 7 months ago ULID = Unique Lexicographically sortable IDentifier ;-) jszymborski 7 months ago ULIDs are sorta the opposite of the HMAC method, where you can't query for the nth ID, but you can sort the IDs.
redhale 7 months ago TIL about UUIDv7 -- thanks! hardwaresofton 7 months ago No 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
hardwaresofton 7 months ago No 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
sam_lowry_ 7 months ago or ULIDs or any other partially sortable ids. sebazzz 7 months ago ULID are not necessarily sortable, just UUIDs consensed in a shorter string by using more characters than 0-9A-F sam_lowry_ 7 months ago ULID = Unique Lexicographically sortable IDentifier ;-) jszymborski 7 months ago ULIDs are sorta the opposite of the HMAC method, where you can't query for the nth ID, but you can sort the IDs.
sebazzz 7 months ago ULID are not necessarily sortable, just UUIDs consensed in a shorter string by using more characters than 0-9A-F sam_lowry_ 7 months ago ULID = Unique Lexicographically sortable IDentifier ;-)
jszymborski 7 months ago ULIDs are sorta the opposite of the HMAC method, where you can't query for the nth ID, but you can sort the IDs.
TIL about UUIDv7 -- thanks!
No 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
or ULIDs or any other partially sortable ids.
ULID are not necessarily sortable, just UUIDs consensed in a shorter string by using more characters than 0-9A-F
ULID = Unique Lexicographically sortable IDentifier ;-)
ULIDs are sorta the opposite of the HMAC method, where you can't query for the nth ID, but you can sort the IDs.