Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things

Re: An improved technique for database primary keys

by fullermd (Priest)
on Nov 05, 2010 at 05:32 UTC ( #869625=note: print w/ replies, xml ) Need Help??

in reply to An alternate technique for database primary keys

The choice of “8 characters’ is arbitrary, but it should simply be long enough that a “collision” is impossible.
I woke up screaming when I read that. And I wasn't even asleep.

Comment on Re: An improved technique for database primary keys
Replies are listed 'Best First'.
Re^2: An improved technique for database primary keys
by sundialsvc4 (Abbot) on Nov 05, 2010 at 13:24 UTC

    Sleep well.   It is a calculated-risk, and of course the index in question must be UNIQUE so that colliding values, if they were somehow generated, would not be stored.   You could, of course, go so far as to use Microsoft’s UUIDs (GUIDs).

    The notion is simply that, if the string is random and sufficiently long, key collisions in-practice “ain’t never actually gonna happen.”   Your mileage may vary.   Choose appropriately.   If, in whatever context you may be dealing with, this admonition isn’t sound, then don’t follow it.   Peace.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://869625]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (6)
As of 2016-02-09 23:47 GMT
Find Nodes?
    Voting Booth?

    How many photographs, souvenirs, artworks, trophies or other decorative objects are displayed in your home?

    Results (329 votes), past polls