- Feature Articles
- CodeSOD
- Error'd
- Forums
-
Other Articles
- Random Article
- Other Series
- Alex's Soapbox
- Announcements
- Best of…
- Best of Email
- Best of the Sidebar
- Bring Your Own Code
- Coded Smorgasbord
- Mandatory Fun Day
- Off Topic
- Representative Line
- News Roundup
- Editor's Soapbox
- Software on the Rocks
- Souvenir Potpourri
- Sponsor Post
- Tales from the Interview
- The Daily WTF: Live
- Virtudyne
Admin
The moral of this story: Never overestimate the CEO's nephew.
Admin
Admin
Just wait till the developer discovers LIMIT offset,count
Admin
FTFY
Admin
Keep in mind that what made today's article such a WTF was that it combined everything into one disgusting SQL query.
Admin
We don't handle just software. All software fixes for any of several hundred products, as well as hardware installs, are handled through the same request system.
But even showing a list of those on one page makes me shudder. What would that be? A 240 MB page maybe?
Admin
Tsss... It's a shame he actually used ASP... Using blogql (1) and psqlsh (2), he could have served the pages straight from the database...
(1) https://github.com/f0rk/blogql (2) https://github.com/umitanuki/psqlsh/blob/master/test/sample.sql
Admin
Sadly, I think I've encountered more instances like this in which the author thought (and sometimes said), "OMG! This is such a clever solution!"
Admin
This hints at the fact that he can NOT be underestimated. There really is no level or standard which he can fail to achieve.
Admin
(if you haven't used it, it's widely used in many large companies, and if you haven't seen it's back-end....they implemented a full flat file database system to dynamically generate tables for it's forms, then stored that in an oracle database....)
Admin
It's cold comfort that I'm not the only one who has dealt with that problem.
Admin
I'm not really familiar with ASP or even SQL stored procedures, but it looks like there's an attempt to provide a bunch of filters on the issues. Don't these filters work?
Admin
We'll see Java gods soon, I swear.
Admin
On a side note - I remember back in the day going to a new company where they wrote their code like this - with the SQL producing the HTML. It actually turned out that this was significantly quicker (factor of 100 or so) than getting the ASP code to recurse round recordsets to build the HTML
Not sure there is much excuse for it nowadays though
Admin
Este codigo es una mierda.
Dieser Code ist scheiße.
Admin
Admin
Admin
Ah, the good old Jurassic Park model - letting "can" get in the way of "should".
Admin
Admin
WOW, I will say it backwards WOW.
Admin
The creepy bit is that I saw straight away that those aren't quite assembly bits yet- just the header of an exe file. Encoding an .exe file in source rather than just calling the .exe in the first place is definitely wtf-worthy though!
Admin
Tragically schmagically. It's probably only down to that fact, that you can even appreciate how WTF this code is.
Admin
Or they could have just written it in Java. Prob sol.
Inb4r "the real WTF is Java"
Admin
première! ¡primera! erste!
Admin
The "PHP god" story was obviously fake based on the following simple logical analysis:
The code as given was stupid and irrational.
There is no such thing as stupid or irrational people in the world.
Therefore, there is no one in the world who would have written such code.
Well, I guess that's the reasoning anyway.
I will next prove that news stories about wars are obviously lies, because only mean, nasty people would start wars, and I refuse to believe that there are mean, nasty people in the world.
Admin
I've had plenty of conversations with other developers that went something like this:
"You know, Bob, this code is very complex and difficult to understand. It looks like you used the absolute hardest way to solve the problem that you could find."
"Yes, isn't it great! This just proves how smart I must be to be able to write such a complicated program!"
Admin
Admin
Nope, this is at least quadralingual.
Stored procedures aren't written in SQL as SQL has no commands for setting variables. They're written in a procedural language, P/SQL, that performs non-SQL commands, but can also pass SQL commands and queries to the interpreter. P/SQL has a completely different model than SQL proper, and is usually run in a separate engine within the DBMS.
(You could even argue that the LIKE expression is using a domain-specific globbing language that's basically a stripped down regular expression.)
Admin
Especially if it's applied rectally.
Admin
I meant to say "to the back of Bob's head", a crucial detail apparently.
Really, why does your mind immediately go to such a dark place (literally)?
Still, thanks for pointing it out. I almost LOL'd myself out of employment.
Admin
To be truly Enterprisey requires .Net - and every single page is really just 1 *.aspx page which requires XML/XHTML to be generated by stored procs in SQL Server. The resulting XML/XHTML markup must be churned through XLST to produce anything that can be delivered to the browser.
Encapsulation? Classes? Separation of Concerns? Bah! We've been doing it this way since Clinton was in office!
Why change now?
Admin
Admin
We have our own tracking system because we wanted to be able to tie into our own help desk, facilities, and internal applications development infrastructure without having to put hooks into the "free" apps available. Just because you write crappy, unpolished code, doesn't mean that the rest of us can't have a solution that fits our needs. Besides, it's not that hard to write a tracking system, if you are any good at what you do. As far as that goes, your "ignorance and perceived [need]" statement makes me wonder if you are one of these developers and/or managers that this entire web site revolves around. You dickhead. You are the reason why there is "on the shelf ware". Buy COTS because it is already written. Saves you developer costs. But it is a square peg going into a round hole for your end users. Oh, and by the way, I architect for the firm that invented CMMI, and pushes COTS, but they also understand that COTS is not the answer to everything.
Admin
Cool, Write some compiler in TSQL.
Admin
We believe you, honest.