June 30, 2008 at 8:17 am
out of interest where do fellow dba-ers stand on the issue of case sentiviity for column names ?
On our enviornments the default collation is case insensitive we have columns of PK
PRODID
pRodId
prodid
etc etc.
Would you say this is bad practice and they should be consitently the same etc ?
As its case insentive and the column case should convey no meaning as to the data should it matter ?
si
June 30, 2008 at 9:18 am
I generally operate in case-insensitive as far as the database is concerned, but I prefer CamelCase for naming. I find it easier to read.
I have places where I violate this, based on very specific rules, but, in general, I don't like ALLCAPS, alllower, or variations on that.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 30, 2008 at 2:46 pm
Why bother with standards? Because the improve predictability and allow one to focus on the important issues, like what does the code say? What is expected behavior, and not get lost on whether RECORDID is the same key as rECORDiD or other variations.
It's a time saver to be consistent. Life is complicated enough already. Those few developers who insist that NOT being consisted confuses the 'enemy' needs to revisit Pogo: We have met the enemy and he is us.
For the rest of us, systems have evolved in settings too complicated to be mastered by only one person, so teamwork and cooperation to at least a limited degree is a MUST.
July 1, 2008 at 4:44 am
steve smith (6/30/2008)
Why bother with standards?
A question I seem to get asked more and more ..
"agile standards " anybody ?!
July 1, 2008 at 7:15 am
Simon_L (7/1/2008)
steve smith (6/30/2008)
Why bother with standards?A question I seem to get asked more and more ..
"agile standards " anybody ?!
And, if standards aren't agile, how long do they last as standards?
But, seriously, there are differences between flexibility, agility, and simply stretching to the point of breaking.
There's nothing like a hung server to alert you to the last one.
July 1, 2008 at 7:19 am
Im all in favour of agile and being flexible but theres that thin dividing line between not being able to adapt and evolve .. and utter mayhem with all standards to the wind
ok Im done mini rant over
yours the ever agile
simon
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply