- 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
Ah, I get it! The WTF is that he didn't reimplement HtmlEncode() in a user-defined function. Right? ... Right?
Admin
I bet he uses his database to send emails too.
Admin
Hmmm... that's a cool technique. I may want to redesign my content management system. Maybe I can put the stylesheets into the stored procedures, too!
Admin
It hurtsssssss usssssss....it hurtssssss ussssssss....
filthy dbasesssssssss....
Admin
Why stop there?? You can have javascript stored in the database, and you can also store all of your images as blobs in the database.
Btw, to the OP, this has been posted before. You might want to use the search function before posting.
Admin
Ytram, I hate you.
Admin
It was funny when you said it. But if you are going to actually do it, well that'd be downright annoying.
Admin
Heh, I still thought it was kinda funny.
Admin
<FONT face="Courier New" size=2>certain substrings in variable names are classic indicators of Great Programming Skill (tm). "blob" certainly falls into this category.</FONT>
Admin
WTF?? Wasn't this post before?!
dZ. :)
Admin
We paid thousands of dollars for SQL Server, we are going to get our money's worth!
Thanks for yet another hillarious post.
Admin
I'm actually kind of impressed :-) I would have never thought of that...
Admin
You know, the sad thing is this is just the kind of thing that might look impressive to the right (wrong) kind of employer. First, look at the complexity of that query! Second, sqlHtml might look killer on my resume. Take that, XHTML!
Admin
It lets you "optimize" the app server to just use GetRows and GetString to format all the markup.
Today is "W"...
Admin
Why they didn't include any JavaScript in there is beyond me.
dZ.
Admin
<FONT face=Arial>Dude...</FONT>
<FONT face=Arial>This was already posted. WTF???</FONT>
Admin
There seems to be a disconcerting number of people on this forum that lack basic reading comprehension skills.
Admin
Yes. Yes there does.
Admin
That's scaring me too!
By the way, that WTF is a repost. Use the search fucntion. ;)
Admin
It totally is a repost!!!! (when does this get annoying?)
Admin
Yesterday
Admin
Yes people should learn to read, as well as use the search function. BTW this is a repost. =D
Admin
This is common. IIS is running 286 and DB-server is running beowulf-cluster.
Admin
There seems to be a disconcerting number of people on this forum that lack a basic sense of humour.
dZ.
Admin
"What is this repost you talk about?"
dZ.
Admin
NOOOOOOOOOOO!!!!
Admin
My last job, they almost went that far: they used cursors in stored procedures to generate HTML and I think they actually did email it from there. Genius!
Admin
Admin
This one is funnier every time though.
Admin
Steve McConnell's rate just went up $100 an hour. Coding Horror!
Admin
Employer: Can you code HTML?
Employee: No, but I know some SQL!
Employer: That's what I asked, you retard! get out! NEXT!
Admin
Do I mention that MS SQL Server 2005 is designed to run up to "middle tier" web sites with no IIS intervention? You can used their XML storage type and do selections on nodes in the XML through SQL, as well as embed .Net code in the database and "not have to run a web server."
scratches his head thinking isn't a program that serves web pages a web server?
Admin
This guy was probably a PL/SQL Oracle developer who came over to SQL Server or whatever. Oracle has some packages, HTP and HTF if I recall, for doing exactly this. They were probably annoyed that their new database didn't have the 'normal' packages, and so decided to do it manually.
Admin
I guess besides being report from hell week, it's also spam week. =D
The only thing this is missing is a busy-wait loop to test for incoming HTTP connections. I hope the guy gets on it, I'd hate to see the opportunity to have all three layers in a database passed up.
Admin
All the people complaining about the repost is a wtf in itself, lol
PS: why read when you can use text-to-speech to mispell for you ? [:D]
Admin
Or said another way: "brilliant !" [:D]
Admin
This guy was probably a PL/SQL Oracle developer who came over to SQL Server or whatever. Oracle has some packages, HTP and HTF if I recall, for doing exactly this.
Not only that, Oracle even invented "HTMLDB" which uses Apache, mod_plsql and the packages you mentioned to generate webpages with database content. As "IDE", you get a web interface where you can put page elements together and back them up with some SQL statements (or click them together, of course). My boss thinks this is a really cool idea because finally you get rid of all those confusing tiers...
Admin
Should that have not been (in keeping with the reposted content theme)
Admin
Reminds me of a large IT consulting company that implements their 'resuable software framework' in client projects.
It uses all the latest technologies. It's kind of a write once and no more code changes approach.
Every attribute of each component in the entire Web UI is stored in a database.(font, x, y, size, page, etc.). Plus workflow, navigation, page layouts, security, etc. also in the same database.
Want to change that label text in a page -- easy!! Change the value in column x in table y to 'z'.
Want to add a new button -- add a new row to couple tables!
See - Nothing is hardcoded. No recompilation. No deployment.
As Staples says 'That was easy!'
Don't need any more programmers after the first implementation.
May also know as the Crazy Extreme programming.
Yep! the learning curve is a lot of fun.
Admin
[6] Massssster isssss corrupt. We cannots log in.
[:'(] No! Massster is good! Massster takes care of us!
[6] Masssster issss falssssse and tricksssssey. We will take precioussss HTML for ourssssselvessss.
[:'(] Nooo! It is too risky! Master wants us to log in a different way.
[6] We could let HER do it...
[:O] Brillant! Paulab-Ean will take care of Master, and SHE does not want precious, and then WE will have precious HTML.
Admin
Don't you mean "brillant"?
Admin
Stop it! I am crying, and my co-workers are looking at me funny (well, funnier than usual)[:'(]
Admin
It just keeps getting worse. Ah, what the hell, I'll join the fun.
postcount++
Admin
You meant "Brillant!", right?
dZ.
Admin
Oh, dammit!
Must... reload... before posting!
dZ.
Admin
My first programming job had something like this.
It was used as a 'Content Manager' allowing Panacore's clients to go in and edit their site 'Without' knowing html... They literally had whole website stored in the webpage, when you connected to this site it would use php to query the database and grab the page you want base on a page name.
The beauty really came into play when they tutored the clients on how to use it... "Go into word and design the page, click 'Save as html' then view source and copy and paste".
The interface had all the normal buttons but when you clicked bold you saw <b>text</b>. You had to know html to even read what you put in.
Admin
"They literally had whole website stored in the webpage" stored in the database... ofcourse it would be the webpage... stupid edit...
Admin
Bah, you both got it wrong anyway. No need to thank me for fixing it..
Dev1: I just had a marvelous idea!
Dev2: Oh? What's that?
Dev1: Put the HTML in the SQL!!!
Dev2: Put the HTML in the SQL? BRILLIANT!!
Admin
"blob" is actually a datatype in some DBMSes. So is "CLOB" and "GLOB". These are large objects. FileBlob actually makes a fair amount of sense.
I love how people mock that which they do not understand. There is a very simple reason for doing this. Performance. Yes, its harder to maintain, yes it abuses the database, but it can be significantly faster. In old data-driven ASP pages, I used this technique a fair amount. Not nearly to this degree, but I used it. To save iterating in an interepretted language on my slow ASP host (I'm talking a dual 200 Mhz Pentium Pro), I used my mainframe DBMS host to generate some of my html.
Response time to client before: 30s. Response time after the change: <1s.
Admin