Hacker News Reader

So where do you actually draw the line for a business and a customers table whether to use uuidv4 vs uuidv7, in terms of privacy and efficiency?

View on HN

I prefer to use int16/int32/int64 IDs for primary keys and UUIDv4 for "visible" keys. So database always uses integer fields to refer to other rows and web API uses UUID.

Do you care about users knowing when another business was put into the system (e.g. how long they've been with you"? If yes, v4. If no, v7.

v4 is less efficient but more private.

Reply on news.ycombinator.com