Skip to Content.
Sympa Menu

grouper-dev - Re: [grouper-dev] gid/fid/aid

Subject: Grouper Developers Forum

List archive

Re: [grouper-dev] gid/fid/aid

Chronological Thread 
  • From: David Langenberg <>
  • To: Chris Hyzer <>
  • Cc: Peter Schober <>, "" <>
  • Subject: Re: [grouper-dev] gid/fid/aid
  • Date: Wed, 25 Apr 2012 14:40:06 -0400

Sounds good


On Wed, Apr 25, 2012 at 10:43 AM, Chris Hyzer <> wrote:
When I say "int", I dont mean Java int, I mean it is a whole number.  It would be a whole numeric type in the DB that could be much larger than 2^32...  however like I said, if you are using this for something like GID and you have an external constraint max number of 2^32 then you would have that "constraint" but not in the DB.  e.g. in mysql if you look at whole number columns they are bigint(20), this would be similar.  ok?

From: [] on behalf of Peter Schober []
Sent: Wednesday, April 25, 2012 5:49 AM
Subject: Re: [grouper-dev] gid/fid/aid

* David Langenberg <> [2012-04-25 06:17]:
> If you want such a constraint (uniqueness at the database layer) why not
> skip the INT datatype and use varchar?  Yes, storing essentially an integer
> as a string does rub wrong, but it seems future-proof at least from the
> outset.  I just worry that starting with INT will lead us to the same issue
> that we're having with IPv4 where sure in 1980 4 billion IP addresses
> seemed enough for anybody, but that sure doesn't cut it in 2012.

Somehow I doubt Grouper will play a role comparable to global IP
addressing 32 years in the future.

David Langenberg
Identity Management
The University of Chicago

Archive powered by MHonArc 2.6.16.

Top of Page