Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
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 2014-08-23 10:18 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (173 votes), past polls