Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

You could also "just" have an internal-use only numeric ID, or use a UUIDv7.


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.




Consider applying for YC's Summer 2026 batch! Applications are open till May 4

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: