I don't get it either. If UUIDv7 lacks security due to its revelation of a times... | Hacker News

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

timmytokyo on July 6, 2024 | parent | context | favorite | on: PostgreSQL and UUID as Primary Key

I don't get it either. If UUIDv7 lacks security due to its revelation of a timestamp, why don't bigserials also lack security? After all, given a bigserial ID, you can tell whether it was generated before or after some other bigserial ID and thereby infer something about the time it was generated.

j45 on July 6, 2024 [–]

BigSerials come from a relational database world for me.

The use of UUIDs for documents may come from a no-sql background.

I use bigserials for relational data in relational databases, and if there is a unique document value needed, a UUID is good.

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