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

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: what is the best way of storing text+image documents in postgresql
Date: 2011-06-10 07:26:55
Message-ID: 4DF1C73F.5000101@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Boettcher 2011-06-10 07:50:20 Problem setting up a user and a Db...
Previous Message wstrzalka 2011-06-10 07:22:10 Re: Estimate for 9.1 release