undefined | Better HN

0 pointsMattPalmer10862y ago0 comments

This seems overly complex, and you need some kind of key too.

Why not just hash it with pretty much any hash function?

0 comments

4 comments · 2 top-level

oconnore2y ago· 1 in thread

A hash is not reversible, so you’d need a database index to recover the original efficient-to-index identifier, which misses the whole point ;)

If you didn’t care about index clustering then just use UUIDv4

Although you could use a hash index to avoid the more deleterious effects of insertion, as long as you don’t need a unique constraint anyway…

bajsejohannes2y ago· 1 in thread

Because a hash is (by definition) a one-way function. You need to be able to go the other way for incoming ids.

Ah, good point. Hadn't thought about the opposite direction.

j / k navigate · click thread line to collapse