Slightly Off Topic (Was: Re: [Rails] Active Record Question)

[Chris Brooks]

On Wed, 10 Nov 2004 11:40:59 -0500, John Wilger <johnwilger at gmail.com> wrote:
> Out of curiosity, what is the advantage of using UUIDs as opposed to
> an auto_increment'ing integer?

The rationale is usually to ensure uniqueness across multiple domains.
 This introduces complexity but has the potential to ease data
migration / conversion in the future.  It can also help prevent "bad"
joins where you join two tables using IDs that don't represent the
same entity.

All that said, I still generally just use auto_increment.

-- 
Chris Brooks
http://www.chrisbrooks.org