[geeklog-devel] sid or auto increment in gl2?

Tony Bibbs tony at tonybibbs.com
Thu Feb 3 10:00:54 EST 2005


Perfect middle ground.  I will update the schema and 'make it so'.

--Tony

Vincent Furia wrote:

>Why not use the autoincrement as a primary key, and have an "id"
>similar to 1.3.x for accessing an item?  The key would be used
>internally for joining tables, etc, but the 'id' (which would default
>to some random value, but could be user assignable (and unique)) could
>be used for external (i.e. user) access to the item.
>
>Sorry Tony, I meant to add that suggestion to the email I originally
>sent to you, but looking back I realize I left that off.
>
>-Vinny
>
>
>On Wed, 02 Feb 2005 18:39:21 -0600, Tony Bibbs <tony at tonybibbs.com> wrote:
>  
>
>>Vinny brought up a really good point worth a good review before we just
>>run with it.  The current GL2 model has the item table with a
>>auto_increment PK.  It was suggested by Vinny that many may prefer the
>>1.3.x method of using timestamps as it more obscure (security by
>>security anyone?)
>>
>>There are two thoughts, one is that security by obscurity is a better
>>route.  The other is that the item-level security in GL2 should make it
>>so that if people guess the id because it was autoincremented, it
>>wouldn't let them have access unless they truly should.
>>
>>My only issue against the timestamp is that GL2 was hoping to support
>>multiple web servers and this could introduce some PK contention in that
>>case.  The auto_increment field would eliminate the risk of that.
>>
>>So that said, any additional arguments one way or another?  Any preferences?
>>
>>--Tony
>>_______________________________________________
>>geeklog-devel mailing list
>>geeklog-devel at lists.geeklog.net
>>http://lists.geeklog.net/listinfo/geeklog-devel
>>
>>    
>>
>_______________________________________________
>geeklog-devel mailing list
>geeklog-devel at lists.geeklog.net
>http://lists.geeklog.net/listinfo/geeklog-devel
>  
>




More information about the geeklog-devel mailing list