Why you shouldn't hire crappy programmers

Annals of the Homestarmy

Wednesday, July 15. 2009

Posted by Radar in Ooops

Comments (3)
Trackbacks (0)

Why you shouldn't hire crappy programmers

I came across the notes for a support item that I thought you all might enjoy:

It will never crash again. It will never output broken images again. Old <crappy programmers name removed> code cleaned up. It will run faster with less calls. But functionality wise the schema of these tables has left me confused.

ProjectGallery is the top level.
ProjectGalleryDate has a FK to ProjectGallery and ProjectImage
ProjectImage has a FK to ProjectGallery and ProjectGalleryDate
There is also a join between ProjectImage and ProjectGallery

This nested mess makes no sense at all. It is like a father with two daughters that are also both the mother of each other while grandchildren exist as well with nothing but the grandfather as a parent? Huh? Total and complete schema fail.

I have replaced the mess with pulling the top 1 image that is a child of a gallery directly for the moment. Thats the cleanest and most direct relationship. But how this is supposed to work? I have no idea.

Trackbacks

Trackback specific URI for this entry

No Trackbacks

Comments

Display comments as (Linear | Threaded)

Ancient of Days on :

Tell the truth - it was MG's code that was removed, wasn't it?

The Mad Giggler on :

I would never make it that easy to untangle. When I write code, I'm making job security for myself. I'm offended that you think an i4 programmer could reverse engineer one of my works of art.

Ancient of Days on :

> how this is supposed to work? I have no idea

Sounds like he wasn't actually able to decipher it. Well done - I tip my hat to you, sir.

Add Comment

Name

Homepage

Comment

In reply to

E-Mail addresses will not be displayed and will only be used for E-Mail notifications.

To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly.
CAPTCHA