programming
Yes, foreign keys are necessary
Aug 22nd
Whatever the reason, by putting the data validation as close as possible to the data munging, you make it harder to circumvent.
I’m a stickler for clean data. A while ago I came across an interview with one of the senior EBay architects and he mentioned that they don’t use them. And it makes absolute sense for them.
In most of cases, there is no need to bypass foreign keys in the name of performance. Mr. Ted, said it best:
You’re going to get, at most, 1,000 people on your app, and maybe 1% of them will be 7-day active. Scalability is not your problem, getting people to give a shit is.
Unmentioned SCM benefit
Aug 14th
Posted by mikem in programming
No comments
Cleaner code = more maintainable code
I’m a notorious code deleter. If I see something that doesn’t seem to be used, I won’t hesitate a second to delete it because I know that code is easily retrieved from SVN. The name of the game is maintainability. I don’t care for code that might be useful. If it’s not useful now, it’s in the way of me understanding what you’re tying to tell the computer.
Speaking of which, here’s a quick tip for the young ones. Never comment a block of code and check it into your SCM. This is a sign of weakness and uncertainty. If you’re checking something into a production branch, you better be sure it works!
This code committed to SVN tells me that the committer wasn’t sure what he was doing.
Fail