Re^2: 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

Replies are listed 'Best First'.
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.)	[reply]
Re^4: Generate a unique ID by BrowserUk (Patriarch) on Nov 15, 2010 at 23:09 UTC
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. RIP an inspiration; A true Folk's Guy	[reply]