Viewing profile — Treffynnon

OK, so I think this might be a language/understanding difference here - perhaps what I have written isn't clear enough - not sure. The statement to some degree , in my opinion, doe…

Well that's good seeing as though I wrote the guide in the first place. An illustration in bad pseudocode: PRIMARY KEY (account_number, transaction_date)

Have you read Celko's book? If not I suggest you do. As the guide states at the very top that is where you'll find the detail you're after.

This doesn't solve the problem at hand either unfortunately. You'll still have a hanging comma in front of `last_name`: SELECT -- first_name , last_name , email_address FROM users …

I think a lot of this comes down to what appears to be a simple misunderstanding. Avoid - in this context means that where it does not make sense (for performance, readability, etc…

Putting the comma before doesn't actually make commenting out columns easier - it just moves the problem to the other end of the list. Just try commenting out the first column in y…

I am totally lost when it comes to your comments on the second item. It seems you're trying to say that surrogate keys are easier to find or perhaps guess. The indexes set out agai…

Thinking multi-column indexes here.

Basically this is the answer - besides that bit about acquiescing to the demands of an ORM.

This seems to be a simple misunderstanding. Try - in this context means where it doesn't make sense (for performance, readability, etc reasons) then don't follow the guide. Follow …

This is a pretty commonly asked question. The answer is two fold: 1. putting the comma before doesn't actually make commenting out columns easier - it just moves the problem to the…

No, actually the collective of player isn't team in this case. Not all players will be on the same team, but they still participate in the league so I disagree with this example te…

This is an interesting idea. I will give it some thought as others have also suggested similar. Perhaps the guide could be relaxed a little to allow singular names. Someone mention…

When modelling data it should be the primary concern and not an ORM. Different applications will need access to the same information. ORMs are application specific and therefore sh…

Amusing example however as you'll know following a style guide doesn't preclude one from using their own intelligence to choose sensible options rather than delving into the absurd…