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

From Arash pajoohande
Subject Re: what is the best way of storing text+image documents in postgresql
Date
Msg-id BANLkTinPETVwVszPM52GtB_cWtjL14L2nQ@mail.gmail.com
Whole thread Raw
In response to Re: what is the best way of storing text+image documents in postgresql  (Vincent Veyron <vv.lists@wanadoo.fr>)
Responses Re: what is the best way of storing text+image documents in postgresql
Re: what is the best way of storing text+image documents in postgresql
Re: what is the best way of storing text+image documents in postgresql
List pgsql-general
hello all and thank you for your advices
On Thu, Jun 9, 2011 at 7:05 PM, Vincent Veyron <vv.lists@wanadoo.fr> wrote:
Le mercredi 08 juin 2011 à 14:43 +0430, Arash pajoohande a écrit :

> and documents must display on web page when corresponding user
> requests occurs.

I wonder why that is? is there any reason you can't just store and serve
the binary content as is, simply letting the proper application (Word in
that case) open it?
that is because MS Word may hasn't been installed in user machine to handle the page.

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

thanks in advance
Arash

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: WAL shipping replication server re-sync
Next
From: John R Pierce
Date:
Subject: Re: what is the best way of storing text+image documents in postgresql