[thelist] bbCode or HTML in DB?

VOLKAN ÖZÇELİK volkan.ozcelik at gmail.com
Thu Oct 13 09:41:34 CDT 2005

I store the BBCode on the db instead of the converted / formatted
code. Because it takes up less space and you can format the BB code as
you wish upon retrieval from the db. You can apply difference styles
to it.

I don't realize a very big performance degredation. But your situation
may be different.

Did not look for articles but I have read people saying storing raw
HTML on DB is not a good thing. I'd be interested as well if someone
provides a more consciense (what a difficult word to spell con--sci...
whatever :) ) argument.

Volkan Ozcelik
+>Yep! I'm blogging! : http://www.volkanozcelik.com/volkanozcelik/blog/
+> My projects/studies/trials/errors : http://www.sarmal.com/

2005/10/13, Brooking, John <John.Brooking at sappi.com>:
> Hello,
>   Here's a best practices question that I would love to hear some input
> on. I have started building some database-driven websites that allow
> basic formatting via "bbCode". I've just realized that I haven't really
> thought through the following design decision: Should I translate the
> bbCode to HTML *before* storing it in the DB, so that the HTML tags are
> stored in the DB, or should I store the bbCode in the DB and translate
> it to HTML after retrieval? Are there more security issues one way than
> the other? Any other considerations? (I suppose it's more efficient to
> do the translation once on the way in rather than every time on the way
> out.) Or doesn't it matter? Any articles I should read? (I don't seem to
> have found the right combination of keywords to Google this question
> efficiently.)
>   Thanks for any thoughts.
> - John
> --
> This message may contain information which is private, privileged or confidential and is intended solely for the use of the individual or entity named in the message. If you are not the intended recipient of this message, please notify the sender thereof and destroy / delete the message. Neither the sender nor Sappi Limited (including its subsidiaries and associated companies) shall incur any liability resulting directly or indirectly from accessing any of the attached files which may contain a virus or the like.
> --
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !

More information about the thelist mailing list