Comment On tblCalendar

Jake again, still covering for Alex.  Today's classic WTF comes from none other than a egocentric programmer named ME, originally posted a little over a year ago. [expand full text]
« PrevPage 1 | Page 2 | Page 3Next »

Re: tblCalendar

2005-08-09 13:08 • by Carsten Otto
This has already been posted (November 2004). Use the search function :)

Re: tblCalendar

2005-08-09 13:13 • by Franky
40318 in reply to 40317
Anonymous:
This has already been posted (November 2004). Use the search function :)




WTF? Did you read the first line where it says it's a Classic WTF?

Re: tblCalendar

2005-08-09 13:15 • by NinjaBob
40319 in reply to 40317

Anonymous:
This has already been posted (November 2004). Use the search function :)


 


", originally posted a little over a year ago."


 


Ya think?

Re: tblCalendar

2005-08-09 13:16 • by Omnifarious
Not trying to start the flamewar again, but I use Linux almost
exclusively (except for my Powerbook) and I haven't owned a TV in over
10 years, so I wouldn't use it for scheduling TV shows either.  :-)



As for the code...  :-)  That is a pretty awful design. 
Apparently the original programmer never heard of 3rd normal form, or
even 2nd or 1sr normal form.



Re: tblCalendar

2005-08-09 13:17 • by Bob Smith
40321 in reply to 40318
Anonymous:


WTF? Did you read the first line where it says it's a Classic WTF?




LOL

Re: tblCalendar

2005-08-09 13:21 • by Manni
40323 in reply to 40317

Anonymous:
This has already been posted (November 2004). Use the search function :)


Do you really spend your time searching through the WTF archive to see if it's been reposted? Wow, I thought I was wasting my time by counting sand, but clearly you have a better use for those long hours.

Re: tblCalendar

2005-08-09 13:33 • by Beek
40324 in reply to 40317
Anonymous:
This has already been posted (November 2004). Use the search function :)




Jake is actually CmdrTaco????????

Re: tblCalendar

2005-08-09 13:34 • by xxx
In hindsight, this guy was a head of  his time.  To paraphrase the country song, he liked AJAX before AJAX was cool!

Re: tblCalendar

2005-08-09 13:35 • by twinchang
40326 in reply to 40320
Omnifarious:
Not trying to start the flamewar again, but I use Linux almost
exclusively (except for my Powerbook) and I haven't owned a TV in over
10 years, so I wouldn't use it for scheduling TV shows either.  :-)



As for the code...  :-)  That is a pretty awful design. 
Apparently the original programmer never heard of 3rd normal form, or
even 2nd or 1sr normal form.






I am sure this programmer must heard of what a Excel table is. They
thought a database's table is, just a table, no more, no less.

Re: tblCalendar

2005-08-09 13:45 • by Sean M
As was mentioned already, this post largely demonstrates a distinct lack of understanding of table normalization. One wonders whether this individual missed those classes, or if indeed {s}he had ever taken a database class. In my database class we had normalization problems to solve every week!

Re: tblCalendar

2005-08-09 13:47 • by Ytram
I am now going to make sure and comment on each WTF you post this week to let you know that you are re-posting an old WTF.

Re: tblCalendar

2005-08-09 13:58 • by WTF-Normal Form
40333 in reply to 40326

twinchang:
Omnifarious:
Not trying to start the flamewar again, but I use Linux almost exclusively (except for my Powerbook) and I haven't owned a TV in over 10 years, so I wouldn't use it for scheduling TV shows either.  :-)

As for the code...  :-)  That is a pretty awful design.  Apparently the original programmer never heard of 3rd normal form, or even 2nd or 1sr normal form.



I am sure this programmer must heard of what a Excel table is. They thought a database's table is, just a table, no more, no less.


Actually this table is more of a chair or maybe a TV-tray if we want to be really generous

Re: tblCalendar

2005-08-09 14:14 • by DZ-Jay
40336 in reply to 40320
Omnifarious:
Not trying to start the flamewar again, but I use Linux almost
exclusively (except for my Powerbook) and I haven't owned a TV in over
10 years, so I wouldn't use it for scheduling TV shows either.  :-)





Gaming sessions then? :)



    -dZ.

Re: tblCalendar

2005-08-09 14:17 • by DZ-Jay
40338 in reply to 40320
Omnifarious:
Not trying to start the flamewar again, but I use Linux almost
exclusively (except for my Powerbook) and I haven't owned a TV in over
10 years, so I wouldn't use it for scheduling TV shows either.  :-)



As for the code...  :-)  That is a pretty awful design. 
Apparently the original programmer never heard of 3rd normal form, or
even 2nd or 1sr normal form.






"What is this Normal Form you speak of?"



    He, he, he.

    dZ.

Re: tblCalendar

2005-08-09 14:24 • by Ross Day
40339 in reply to 40338
DZ-Jay:


"What is this Normal Form you speak of?"





Normal Form is what the rest of the world is...and we computer geeks are not.



If you don't believe me, ask any female.**









** Obligatory anti-"I have a GF" and anti-"I am married"
disclaimer...the above is what is known as a "joke"...it is intended to
be humorous, and it utilizes what is called "sarcasm".

Re: tblCalendar

2005-08-09 14:37 • by DZ-Jay
40341 in reply to 40339
Ross Day:
DZ-Jay:


"What is this Normal Form you speak of?"





Normal Form is what the rest of the world is...and we computer geeks are not.



If you don't believe me, ask any female.**









** Obligatory anti-"I have a GF" and anti-"I am married"
disclaimer...the above is what is known as a "joke"...it is intended to
be humorous, and it utilizes what is called "sarcasm".




"What is this Sarcasm you speak of?"



    -dZ.



Re: tblCalendar

2005-08-09 14:40 • by Bustaz Kool
40342 in reply to 40320

Omnifarious:
Apparently the original programmer never heard of 3rd normal form, or even 2nd or 1sr normal form.


Perhaps they have heard of Third Abnormal Form?

Re: tblCalendar

2005-08-09 14:42 • by phred
40343 in reply to 40320

I tried to use linux once and the damn cd FORMATTED MY HARD DISK!


Probably had a hacker shell embedded in a regular expression.


 

JOINs

2005-08-09 14:47 • by generalpf
Jesus, what I wouldn't give to see some of the JOIN statements
involving this table.  My guess is they involve the LIKE
operator.  *shudder*

Re: tblCalendar

2005-08-09 14:54 • by OneFactor
40346 in reply to 40339

Ross Day:
DZ-Jay:

"What is this Normal Form you speak of?"


Normal Form is what the rest of the world is...and we computer geeks are not.

If you don't believe me, ask any female.**


Reminds me of the time someone remarked that what with so many males in IT/programmer positions, the odds are good for the females. To which, one of the females added: "yes, but the goods are odd".


BTW, my wife would be the first to admit I'm not in any kind of normal form.

Re: tblCalendar

2005-08-09 14:59 • by Davey
40347 in reply to 40324

Beek:
Anonymous:
This has already been posted (November 2004). Use the search function :)


Jake is actually CmdrTaco????????


And Carsten Otton is Zonk?


...wait for it....wait for it.... hahahaha

Re: tblCalendar

2005-08-09 14:59 • by phred
40348 in reply to 40330

I once had a project that I decided not to normalize, it was an attendance system, it had a table for students, a table for courses, a table for meetings and a table for student attendance. Without using repeating groups, the actual student attendance table would have been at least 100 times the actual size required (one bit, present or not), simply because of the foreign keys required. By making a repeating group I saved immensely on programmer time and computer efficiency.


 

Re: tblCalendar

2005-08-09 15:04 • by Xepol
some C programmers just can't break old habits inspired by poor tools, but let's not start a language war either, after all, we all know the pinacle of perfection was achieved with object cobal +o(

As for this being an old post, well YA, DUH. All wtfs are old posts. We've all seen them before - idiots are rarely creative, but they are DEFINITELY repetitive. I suppose that makes them reliable at least. Nothing worse than an idiot that occasionally doesn't screw up just to totally ruin your day.

I mean, if you can't depend on the IT-impaired to download and install as much of the internet as possibly onto the company's mission critical server, who can you rely on??

Re: tblCalendar

2005-08-09 15:10 • by WTF-Normal Form
40350 in reply to 40349

Xepol:
some C programmers just can't break old habits inspired by poor tools, but let's not start a language war either, after all, we all know the pinacle of perfection was achieved with object cobal +o( As for this being an old post, well YA, DUH. All wtfs are old posts. We've all seen them before - idiots are rarely creative, but they are DEFINITELY repetitive. I suppose that makes them reliable at least. Nothing worse than an idiot that occasionally doesn't screw up just to totally ruin your day. I mean, if you can't depend on the IT-impaired to download and install as much of the internet as possibly onto the company's mission critical server, who can you rely on??


Its called a porn cache and like all caches the closer it is the cpu(s) it is the better

Re: tblCalendar

2005-08-09 15:36 • by DZ-Jay
40353 in reply to 40343
phred:

I tried to use linux once and the damn cd FORMATTED MY HARD DISK!



Probably had a hacker shell embedded in a regular expression.

 





Are you sure it wasn't a virus? Maybe your CD downloaded a virus or something?



    He, he, he.

    dZ.

Re: JOINs

2005-08-09 15:38 • by DZ-Jay
40354 in reply to 40345
Anonymous:
Jesus, what I wouldn't give to see some of the JOIN statements
involving this table.  My guess is they involve the LIKE
operator.  *shudder*




"Join? What is this Join you spea---" Ok, ok, I'll stop :)



    dZ.

Re: tblCalendar

2005-08-09 15:45 • by Hank Miller
40355 in reply to 40317
Anonymous:
This has already been posted (November 2004). Use the search function :)




This foumn software sucks too.

Re: tblCalendar

2005-08-09 15:46 • by Mung Kee
40356 in reply to 40353
DZ-Jay:
phred:

I tried to use linux once and the damn cd FORMATTED MY HARD DISK!



Probably had a hacker shell embedded in a regular expression.

 





Are you sure it wasn't a virus? Maybe your CD downloaded a virus or something?



    He, he, he.

    dZ.


Or did he try to use a drive with an NTFS partition?



Before anyone blows up, NTFS DOES NOT SUCK

Re: tblCalendar

2005-08-09 16:10 • by Chris F
40359 in reply to 40356
Mung Kee:
DZ-Jay:
phred:

I tried to use linux once and the damn cd FORMATTED MY HARD DISK!



Probably had a hacker shell embedded in a regular expression.

 





Are you sure it wasn't a virus? Maybe your CD downloaded a virus or something?



    He, he, he.

    dZ.


Or did he try to use a drive with an NTFS partition?



Before anyone blows up, NTFS DOES NOT SUCK


Yeah!  Who needs symbolic links anyway!

Re: tblCalendar

2005-08-09 16:23 • by Schol-R-LEA
40360 in reply to 40343
phred:
I tried to use linux once and the damn cd FORMATTED MY HARD DISK!


If you don't mind me asking, were you using a LiveCD (one designed
to boot a working Linux session from a CD without installing onto the
system), or a standard installation CD, and if the latter, did you
specify for it to use a UMBDOS pseudo-partition on your existing file
system; or did the system have another free disk partition which you
meant to install Linux onto?


Because if you just ran a standard install CD, then... well, it was
doing exactly what it was supposed to do - install a new OS, with it's
own file system. If it hadn't reformatted the drive, then
you would have had cause to complain that it wasn't working. As it is,
it sounds like pilot error to me.


Re: tblCalendar

2005-08-09 16:48 • by jzlondon
40362 in reply to 40339

Ross Day:
DZ-Jay:

"What is this Normal Form you speak of?"


Normal Form is what the rest of the world is...and we computer geeks are not.

If you don't believe me, ask any female.**




** Obligatory anti-"I have a GF" and anti-"I am married" disclaimer...the above is what is known as a "joke"...it is intended to be humorous, and it utilizes what is called "sarcasm".


Actually, it's irony.


This is sarcasm.

Re: tblCalendar

2005-08-09 16:50 • by sYn pHrEAk
40363 in reply to 40360
Schol-R-LEA:
If you don't mind me asking, were you using a LiveCD (one designed
to boot a working Linux session from a CD without installing onto the
system), or a standard installation CD, and if the latter, did you
specify for it to use a UMBDOS pseudo-partition on your existing file
system; or did the system have another free disk partition which you
meant to install Linux onto?



Because if you just ran a standard install CD, then... well, it was
doing exactly what it was supposed to do - install a new OS, with it's
own file system. If it hadn't reformatted the drive, then
you would have had cause to complain that it wasn't working. As it is,
it sounds like pilot error to me.




*cough*


http://en.wikipedia.org/wiki/Humor


Re: tblCalendar

2005-08-09 16:57 • by Daruku
40364 in reply to 40323
I thought I was wasting time reading this site!

Re: tblCalendar

2005-08-09 17:11 • by evnafets
40366 in reply to 40363

>*cough*
>http://en.wikipedia.org/wiki/Humor


What is this Humour you speak of?  [8-)]

Re: tblCalendar

2005-08-09 17:23 • by El Duderino
40368 in reply to 40366
evnafets:

What is this Humour you speak of?  [8-)]



It's the british version of humor.

Re: tblCalendar

2005-08-09 17:24 • by Mung Kee
40369 in reply to 40368
El Duderino:
evnafets:

What is this Humour you speak of?  [8-)]



It's the british version of humor.



You mean like Benny Hill?

Re: tblCalendar

2005-08-09 17:25 • by tufty
I like this one.

I'm vaguely amused by how we have hungarian on all but the id column. it really should be bigintID...

I like how dat(Start|End)Time is a smalldatetime, not a date.

I really quite enjoy strWhat and strWhere. It's missing strThe, strFuck and strDidYouLearnToProgram, but I can live with that.

But what I love most is how a field they are encoding values, including names, into is limited to 127 chars. That is - touching - in its naivety.

I think I'm in love.

Simon

Re: tblCalendar

2005-08-09 17:50 • by Fabian
40372 in reply to 40360
Schol-R-LEA:
phred:
I tried to use linux once and the damn cd FORMATTED MY HARD DISK!


As it is,
it sounds like pilot error to me.





As it is, it sounds like you're missing the joke to me...

Re: tblCalendar

2005-08-09 17:54 • by Jehos
40373 in reply to 40339

Ross Day:
DZ-Jay:

"What is this Normal Form you speak of?"


Normal Form is what the rest of the world is...and we computer geeks are not.

If you don't believe me, ask any female.**




** Obligatory anti-"I have a GF" and anti-"I am married" disclaimer...the above is what is known as a "joke"...it is intended to be humorous, and it utilizes what is called "sarcasm".


Heh, I have a wife *and* a girlfriend.  Probably because I don't use Linux.

Re: tblCalendar

2005-08-09 18:06 • by Schol-R-LEA
40374 in reply to 40372
Anonymous:
Schol-R-LEA:
phred:
I
tried to use linux once and the damn cd FORMATTED MY HARD DISK!


As it is,
it sounds like pilot error to me.





As it is, it sounds like you're missing the joke to me...




Probably. I often field questions on beginner's fora, and as a result
tend to take a lot of stuff like this at face value, simply because it
all too often is meant seriously. I thought it might be a joke, but I
wasn't sure... and habit got the best of me.

Re: tblCalendar

2005-08-09 18:40 • by triso
40376 in reply to 40323
Manni:

...Wow, I thought I was wasting my time by counting sand, but clearly you have a better use for those long hours.

I
hope you're counting grain by grain and not counting spoonfuls * number
of grains in a spoonful.  That would be cheating.


Re: tblCalendar

2005-08-09 19:34 • by Paulie
40377 in reply to 40359
Chris F:


Yeah!  Who needs symbolic links anyway!


Look up NTFS Hardlinks Mr. Smarty Pants.

Re: tblCalendar

2005-08-09 19:35 • by James Schend
40378 in reply to 40359
Chris F:
Mung Kee:


Or did he try to use a drive with an NTFS partition?



Before anyone blows up, NTFS DOES NOT SUCK


Yeah!  Who needs symbolic links anyway!




... well, if you do need them, you'll be happy to know that NTFS has
them.  (Well, they're called "junctions," but it's the same idea;
NTFS also supports hard links.



http://answers.google.com/answers/threadview?id=341355



For the record, NTFS also supports mount points, and HFS+ (used on
Apple computers) also supports symbolic links and mount points and aliases, which are like 'smart' shortcuts.



But go ahead and be ignorant.  ;)

Re: tblCalendar

2005-08-09 19:47 • by Chris F
40379 in reply to 40378
Paulie:
Chris F:


Yeah!  Who needs symbolic links anyway!



Look up NTFS Hardlinks Mr. Smarty Pants.



Hardlink, symbolic link, what's the difference?  I'll give you a hint: It's not trivial.



James Schend:
.. well, if you do need them, you'll be
happy to know that NTFS has them.  (Well, they're called
"junctions," but it's the same idea; NTFS also supports hard
links.


Junctions only work on directories.  Maybe they'll get it right
next time.  In the meanwhile, I'll use an FS that doesn't suck.



James Schend:
But go ahead and be ignorant.  ;)


Oh, sweet irony.

Re: tblCalendar

2005-08-09 20:16 • by rsynnott
40380 in reply to 40359
Chris F:
Mung Kee:




Before anyone blows up, NTFS DOES NOT SUCK


Yeah!  Who needs symbolic links anyway!




If I remember rightly, it can do them after a fashion, along with lots
of other things that Windows doesn't make use of, or make directly
available.



Any modern Linux install can resize NTFS partitions, and will certainly
ASK before overwriting them. In any case I think the OP was a troll;
see his other post.

Re: tblCalendar

2005-08-09 20:18 • by ysabet
40381 in reply to 40373
Jehos:

Ross Day:
DZ-Jay:

"What is this Normal Form you speak of?"


Normal Form is what the rest of the world is...and we computer geeks are not.

If you don't believe me, ask any female


Heh, I have a wife *and* a girlfriend.  Probably because I don't use Linux.



I am the linux-using wife of a linux user. Normal people are boring.

Re: tblCalendar

2005-08-09 22:00 • by Brooks Moses
40384 in reply to 40377
Funny, "ln -s" seems to work just fine under cygwin on my NTFS partitions. Wonder why it doesn't work for Chris F?

Re: tblCalendar

2005-08-09 23:09 • by Chris F
40385 in reply to 40384
Brooks Moses:
Funny, "ln -s" seems to work just fine under
cygwin on my NTFS partitions. Wonder why it doesn't work for Chris
F?


You've got to be kidding me.  Did you even look at what happens
when you use ln -s with Cygwin?  It creates .lnk files. 
Needless to say, these files are crude hacks which require application
awareness.  Try again.

Re: tblCalendar

2005-08-10 00:37 • by Gary
40388 in reply to 40338
DZ-Jay:


"What is this Normal Form you speak of?"




Normal form is fixing the database schema to be how you should have designed it in the first place.

Re: tblCalendar

2005-08-10 01:24 • by Drak
40390 in reply to 40388

Anonymous:
DZ-Jay:

"What is this Normal Form you speak of?"


Normal form is fixing the database schema to be how you should have designed it in the first place.


I must honestly say that I forgot totally everything about designing a database the moment I left school to go to work. I did like the classes though, but can't remember one single bit about what I learnt.


Drak

« PrevPage 1 | Page 2 | Page 3Next »

Add Comment