Re: what is the best way of storing text+image documents in postgresql - Mailing list pgsql-general

From John R Pierce
Subject Re: what is the best way of storing text+image documents in postgresql
Date
Msg-id 4DF1C73F.5000101@hogranch.com
Whole thread Raw
In response to Re: what is the best way of storing text+image documents in postgresql  (Arash pajoohande <apajoohande@gmail.com>)
Responses Re: what is the best way of storing text+image documents in postgresql  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Arash pajoohande
Date:
Subject: Re: what is the best way of storing text+image documents in postgresql
Next
From: wstrzalka
Date:
Subject: Re: Estimate for 9.1 release