4 ms·
> It may not be precisely what you want, and could continue to leak private information depending on the specific variant used. If you want privacy of sequence
by almog 2y ago
> It may not be precisely what you want, and could continue to leak private information depending on the specific variant used. If you want privacy of sequence statistics, then I would suggest something like a sha256 hash of the primary key concatenated with a cryptographic salt stored in a separate column. These make excellent identifiers in places like APIs and URLs.
Is there a reason not to use version 4 UUID and if time ordering is needed, save timestamp explicitly as another column?
- bob1029 2y agoType 4 guids are a reasonable choice. I personally prefer the extra 128 bits of entropy, but I have no evidence that says it's more secure in practice.