[keycloak-dev] Use UUID for IDs

[Bill Burke]

On 2/12/2014 9:18 AM, Stian Thorgersen wrote:
> We've come full circle ;)
>
> My reasoning for not to use db generated ids are:
>
> * ID format would be different depending on the store (H2, MySQL, PostgreSQL, Oracle, Mongo, etc.) / for example apps will want to refer to users by id, and they need to know how to store it

Dbs will support long primary keys :)

> * What happens to a "sequences" (or whatever mechanism the db chooses to use) if you export to json, then import again. Especially if you change the underlying db (e.g. from H2 to PostgreSQL)
>

Export to json does not have to contain ids.  Our import format doesn't 
require ids.  I'm not even sure it honors ids :)

> Further (this is a stupid reason) if we want to support huge deployments shards will be involved, in which case it'd be simpler to use UUIDs.
>

That is beyond my experience so I don't have a counter argument to that.

-- 
Bill Burke
JBoss, a division of Red Hat
http://bill.burkecentral.com