News for hackers. Stuff that matters.

A comment on PostgreSQL and UUID as Primary Key. Parent comment

Re:PostgreSQL and UUID as Primary Key by timmytokyo on Saturday July 06, 2024 @12:55PM (#40891613)
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.
[ Parent | on HN ]
Re:PostgreSQL and UUID as Primary Key by j45 on Saturday July 06, 2024 @03:10PM (#40892491)
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.

[ Parent | on HN ]