News for hackers. Stuff that matters.

A comment on Unexpected downsides of UUID keys in PostgreSQL. Parent comment

Re:Unexpected downsides of UUID keys in PostgreSQL by remram on Thursday June 22, 2023 @10:47AM (#36432960)
Encrypt it. Block ciphers are bijective so they will turn sequential IDs into unique random IDs in a way you can easily reverse.

You can also do that to get opaque identifiers from an auto-increment primary key.

[ Parent | on HN ]
Re:Unexpected downsides of UUID keys in PostgreSQL by fauigerzigerk on Thursday June 22, 2023 @12:04PM (#36434283)
Seems awfully complicated to me.
[ Parent | on HN ]