Hacker News Reader

I recall seeing UUID generators that are specifically tuned for use as keys in databases that specifically support them as primary keys. E.g. this has been around for a while:

https://docs.microsoft.com/en-us/sql/t-sql/functions/newsequ...

I've used this to good effect before.

Note that the endianness may catch you by surprise, though. For example, what's good in postgres may not be good for SQL server.

I'm curious about this if you remember the reference. My gut reaction is UUID is better because the keys would be more uniformly distributed across the key-space. With sequential IDs, a binary tree would end up always being unbalanced -- though, this effect would be reduced as the database gets larger.

Thank you for mentioning ulid. Very interesting,and perhaps also useful.