Gunnar R|nning <[EMAIL PROTECTED]> writes:
> Rafal Krzewski <[EMAIL PROTECTED]> writes:
>
> > In a directory service, there are no numerical id. Every record (for
> > example user) has unique Distinguished Name. The security code in Turbine
> > enforces uniqueness of login names. You should use this value as a
> > foreign key in your tables. This way your system will be compatible with
> > both DB and DS environments.
>
>
> IMHO using the login name as foreign key is bad database design. Two
> reasons:
>
> 1. The login name of an user might change on some systems.
>
> 2. It will also cause your database to be a lot larger(and therefore
> slower).
I agree with Gunnar's objections to the use of login name as primary
key--auto increments should always be preferred over text strings.
Daniel Rall
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
