[hardwaresofton]

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

[redhale]

TIL about UUIDv7 -- thanks!

[hardwaresofton]

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_]

or ULIDs or any other partially sortable ids.

[sebazzz]

ULID are not necessarily sortable, just UUIDs consensed in a shorter string by using more characters than 0-9A-F

[sam_lowry_]

ULID = Unique Lexicographically sortable IDentifier ;-)

[jszymborski]

ULIDs are sorta the opposite of the HMAC method, where you can't query for the nth ID, but you can sort the IDs.