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 dajtxx on Friday July 05, 2024 @07:12PM (#40886884)
The comment above warns against it due to the embedded timestamp info as a info leak risk. Perhaps that was a problem for them in some circumstance.
[ Parent | on HN ]
Re:PostgreSQL and UUID as Primary Key by inopinatus on Saturday July 06, 2024 @12:57AM (#40888252)
It wasn’t a problem for me directly but was observed and related by a colleague: an identifier for an acquired entity embedded the record’s creation timestamp and effectively leaked the date of acquisition despite it being commercial-in-confidence information. Cue post-M&A ruckus at board level.

Just goes to show you can’t inadvertently disclose anything these days.

[ Parent | on HN ]