Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re^2: Generate a unique ID

by BrowserUk (Pope)
on Nov 15, 2010 at 19:30 UTC ( #871558=note: print w/ replies, xml ) Need Help??


in reply to Re: Generate a unique ID
in thread Generate a unique ID

I have databases with over 750k entries using UUID for each row and have never ran into a collision -- over a 2 year period.

How do you know you've never had a collision? Are you checking, if so how?

And are you using Data::UUID? On Windows?

If you're using this to give every new record a unique id, why aren't you using an autoincrmenting primary key?


Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
"Science is about questioning the status quo. Questioning authority".
In the absence of evidence, opinion is indistinguishable from prejudice.


Comment on Re^2: Generate a unique ID
Re^3: Generate a unique ID
by TheRatKing (Initiate) on Nov 15, 2010 at 23:06 UTC

    Yes, I do check for collisions because I was also curious.

    I'm not using an autoincrementing primary key because an autoincrementing primary key depends on the state of the table within a given database. My data sits in Google App Engine for production and sits in a postgresql database as the primary source for when I need to curate it. (Processing directly on G.A.E. costs more than transferring the difference periodically.)

      Yes, I do check for collisions

      Could you describe how please?


      Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
      "Science is about questioning the status quo. Questioning authority".
      In the absence of evidence, opinion is indistinguishable from prejudice.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (8)
As of 2015-07-04 02:16 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (57 votes), past polls