[thesite] Community News Category

[Daniel J. Cody]

.jeff wrote:


> no, this is not me being hypocritical.  there's no sound reason for changing
> that id other than you "felt dirty" because it matched a pk id used in
> another table.  that's complete crap.  the reasons i cited in the passage
> you quoted are relevant to bug fixes and performance issues and not at all
> with how "clean" or "dirty" they make me feel.
 

the sound reason is since we've instituted one sequence - which you may 
or may not like - we've never used the same PK for anything.

 
>><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
>>and what do you mean 'right next to eachother'? they're
>>arranged in alphabetical order anyways.
>><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
>>
> 
> read the sentence again:
> 
>   "besides, don't you think it was nice to have the
>    categoryid for news and community news right next
>    to each other"
> 
> the keyword being "categoryid" not the name of the category.


ok, my fault. but does it *really* matter if the categoryid of two 
categories is sequential? and right now, community news is only 2 more 
than 'commentary & society' and 4063 away from 'IA/usability'! but that 
really doesn't matter..


>><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
>>we've never used a PK from one table to the next since
>>the sequence went in place.
>><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
>>
> 
> and?  i didn't agree with that implementation when it happened either.


noted

> your reasoning has no logic as there are already lots of multiple uses of
> the same pk throughout the site from when we were using access and creating
> pk's on a per table basis.


i'm providing reasoning other than news & community news are right next 
to eachother. we've never used the same PK for anything since using one 
sequence.

.djc.