Comment On SqlHtml

Ah, I get it! The WTF is that he didn't reimplement HtmlEncode() in a user-defined function.  Right?  ... Right?

I bet he uses his database to send emails too.

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!

It hurtsssssss usssssss....it hurtssssss ussssssss....

filthy dbasesssssssss....

 

 

Kippesoep:

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!

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.

Ytram, I hate you.

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.

It was funny when you said it.  But if you are going to actually do it, well that'd be downright annoying.

Anonymous:

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.

It was funny when you said it.  But if you are going to actually do it, well that'd be downright annoying.

Heh, I still thought it was kinda funny.

certain substrings in variable names are classic indicators of Great Programming Skill (tm).  "blob" certainly falls into this category.

Jakeypoo:

And on a personal note, I want to thank
everyone for all of the reminders that the WTFs this week are all
reposts.  Thanks for keeping me up to date during Classic WTF week.

WTF?? Wasn't this post before?!



    dZ. :)

We paid thousands of dollars for SQL Server, we are going to get our money's worth!



Thanks for yet another hillarious post.

I'm actually kind of impressed :-)  I would have *never* thought of that...

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!

It lets you "optimize" the app server to just use GetRows and GetString to format all the markup.

Today is "W"...

 

Why they didn't include any JavaScript in there is beyond me.



    dZ.

Dude...

This was already posted.  WTF???

Anonymous:

Dude...

This was already posted.  WTF???

There seems to be a disconcerting number of people on this forum that lack basic reading comprehension skills.

mizhi:

Anonymous:

Dude...

This was already posted.  WTF???

There seems to be a disconcerting number of people on this forum that lack basic reading comprehension skills.

Yes.  Yes there does.

mizhi:

There seems to be a disconcerting number of people on this forum that lack basic reading comprehension skills.

That's scaring me too!



By the way, that WTF is a repost. Use the search fucntion. ;)

It totally is a repost!!!! (when does this get annoying?)

Anonymous:

It totally is a repost!!!! (when does this get annoying?)

Yesterday

Yes people should learn to read, as well as use the search function.  BTW this is a repost.  =D

This is common. IIS is running 286 and DB-server is running beowulf-cluster.

mizhi:

Anonymous:

Dude...

This was already posted.  WTF???

There seems to be a disconcerting number of people on this forum that lack basic reading comprehension skills.

There seems to be a disconcerting number of people on this forum that lack a basic sense of humour.



    dZ.

Kazrael:

Yes people should learn to read, as well as use the search function.  BTW this is a repost.  =D

"What is this repost you talk about?"



    dZ.

DZ-Jay:

"What is this repost you talk about?"



    dZ.

NOOOOOOOOOOO!!!!

Ytram:

Kippesoep:

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!

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.

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!

- I for one welcome our new sqlHtml-coding overlords!

DZ-Jay:

Kazrael:

Yes people should learn to
read, as well as use the search function.  BTW this is a
repost.  =D

"What is this repost you talk about?"



    dZ.

This one is funnier every time though.

Steve McConnell's rate just went up $100 an hour.  Coding Horror!

Employer: Can you code HTML?

Employee: No, but I know some SQL!

Employer: That's what I asked, you retard! get out! NEXT!

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?*

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.

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.

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]

Or said another way: "brilliant !" [:D]

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...

WIldpeaks:

Or said another way: "brilliant !" [:D]

Should that have not been (in keeping with the reposted content theme)

package test;

public class paulaBean {

  private String paula = "Brillant";

  public String getPaula() {
    return paula;
  }
}

 

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.

scheky:

It hurtsssssss usssssss....it hurtssssss ussssssss....

filthy dbasesssssssss....

[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.

Don't you mean "brillant"?

OneFactor:

scheky:

It hurtsssssss usssssss....it hurtssssss ussssssss....

filthy dbasesssssssss....

[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.

Stop it! I am crying, and my co-workers are looking at me funny (well, funnier than usual)[:'(]

DZ-Jay:

Kazrael:

Yes people should learn to read, as well as use the search function.  BTW this is a repost.  =D

"What is this repost you talk about?"

    dZ.

It just keeps getting worse.  Ah, what the hell, I'll join the fun.

postcount++

WIldpeaks:

Or said another way: "brilliant !" [:D]

You meant "Brillant!", right?



    dZ.

DZ-Jay:

WIldpeaks:

Or said another way: "brilliant !" [:D]

You meant "Brillant!", right?



    dZ.

Oh, dammit!



Must... reload... before posting!



    dZ.

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.

"They literally had whole website
stored in the webpage" stored in the database... ofcourse it would be
the webpage... stupid edit...

DZ-Jay:

DZ-Jay:

WIldpeaks:

Or said another way: "brilliant !" [:D]

You meant "Brillant!", right?



    dZ.

Oh, dammit!



Must... reload... before posting!



    dZ.

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!!

emptyset:

certain substrings in variable names are classic indicators of Great Programming Skill (tm).  "blob" certainly falls into this category.

"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.

DZ-Jay:

There seems to be a disconcerting number of people on this forum that lack basic reading comprehension skills.

what