Re: what is the best way of storing text+image documents in postgresql

On 06/10/11 12:04 AM, Arash pajoohande wrote:
> Actually, my word files consists of many exam questions. for each
> user, a random subset of questions must selected and displayed.
> it seem's that it would be nice if I have each question as an easy to
> handle document section (e.g. html div) and display them without need
> of any other application.
> for now, i think the best solution for me is to convert each question
> as an RTF type format, and run that through a preprocessor that
> reencodes them as a clean HTML (as john r pierce suggested).


actually, for THAT requirement, I think I'd store the questions in the
database as plain text and wrap them in HTML formatting in your View or
Presentation layer as its being sent to the user....


--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast