← Back to context Comment by hardwaresofton 6 days ago You could also "just" have an internal-use only numeric ID, or use a UUIDv7. 6 comments hardwaresofton Reply redhale 5 days ago TIL about UUIDv7 -- thanks! hardwaresofton 5 days 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_ 6 days ago or ULIDs or any other partially sortable ids. sebazzz 5 days ago ULID are not necessarily sortable, just UUIDs consensed in a shorter string by using more characters than 0-9A-F sam_lowry_ 5 days ago ULID = Unique Lexicographically sortable IDentifier ;-) jszymborski 5 days 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 5 days ago TIL about UUIDv7 -- thanks! hardwaresofton 5 days 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 5 days 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_ 6 days ago or ULIDs or any other partially sortable ids. sebazzz 5 days ago ULID are not necessarily sortable, just UUIDs consensed in a shorter string by using more characters than 0-9A-F sam_lowry_ 5 days ago ULID = Unique Lexicographically sortable IDentifier ;-) jszymborski 5 days 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 5 days ago ULID are not necessarily sortable, just UUIDs consensed in a shorter string by using more characters than 0-9A-F sam_lowry_ 5 days ago ULID = Unique Lexicographically sortable IDentifier ;-)
jszymborski 5 days 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.