syncope-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Guido Wimmel <guido.wim...@gmx.net>
Subject Re: [DISCUSS] Switching to UUID primary keys for users, groups and any objects
Date Mon, 04 Apr 2016 20:22:12 GMT
I'd also prefer UUIDs over the current primary keys.

However, that would make migrations from 1.2.x to 2.0 even more 
difficult than they probably already will be
- especially if someone uses the Syncope user id outside of Syncope.

Cheers,
   Guido

Am 04.04.2016 um 15:51 schrieb Colm O hEigeartaigh:
> +1 if it is feasible for 2.0.0. Having a unique global Id maps nicely to
> the SCIM Id which "MUST be unique across the SCIM service provider's entire
> set of resources.".
>
> Colm.
>
> On Mon, Apr 4, 2016 at 11:11 AM, Massimiliano Perrone <
> massimiliano.perrone@tirasa.net> wrote:
>
>>
>> Il 04/04/2016 10:23, Francesco Chicchiriccò ha scritto:
>>
>>> Hi all,
>>> a recent e-mail on user@ [1] (about SCIM) made me reconsider one of the
>>> choices we've made in Syncope since the beginning, e.g. using table
>>> generators for long primary keys in several entities, and especially for
>>> users, groups and any objects (and maybe related as attributes, memberships
>>> and relationships).
>>>
>>> It seems that UUID offers several advantages, compared to natural keys
>>> (as "long" we use for the aforementioned entities) [2][3][4].
>>>
>>> There is some open source UUID generator around [5], which is reported to
>>> perform quite better than standard JDK's, and also features time-based
>>> generation, particularly useful in cluster scenarios.
>>>
>>> Naturally, all this would mean changing some logic and data
>>> representation, hence a relevant impact on the codebase, but with
>>> considerable improvements in portability and performance.
>>>
>>> It is my opinion, after a quick chat with Mark Struberg on #openjpa, that
>>> this change might worth the effort, and also that we can make it before
>>> finalizing 2.0.0.
>>>
>>> I am going anyway to ask for details on users@openjpa.
>>>
>>> WDYT?
>>>
>> It seems to be a good enhancement, my only doubt is only about the time.
>> Do you think it's a good idea (I'm supposing that you know how much time
>> you need to implement the feature) implementing it before the 2.0.0 release?
>>
>> Regards,
>> Massi
>>
>> Regards.
>>> [1]
>>> http://syncope-user.1051894.n5.nabble.com/Get-list-of-Users-from-a-Syncope-Group-td5708406.html
>>> [2] http://blog.codinghorror.com/primary-keys-ids-versus-guids/
>>> [3]
>>> http://web.archive.org/web/20150511162734/http://databases.aspfaq.com/database/what-should-i-choose-for-my-primary-key.html
>>> [4]
>>> http://blog.xebia.com/jpa-implementation-patterns-using-uuids-as-primary-keys/
>>> [5] https://github.com/cowtowncoder/java-uuid-generator
>>>
>>>
>> --
>> Massimiliano Perrone
>> Tel +39 393 9121310
>>
>> Tirasa S.r.l.
>> Viale D'Annunzio 267 - 65127 Pescara
>> Tel +39 0859116307 / FAX +39 0859111173
>> http://www.tirasa.net
>>
>> "L'apprendere molte cose non insegna l'intelligenza"
>> (Eraclito)
>>
>>
>


Mime
View raw message