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

From Vincent Veyron
Subject Re: what is the best way of storing text+image documents in postgresql
Date
Msg-id 1307718959.2434.18.camel@asus-1001PX.home
Whole thread Raw
In response to Re: what is the best way of storing text+image documents in postgresql  (Arash pajoohande <apajoohande@gmail.com>)
List pgsql-general
Le vendredi 10 juin 2011 à 11:34 +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.
>

Provide a link to LibreOffice?


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

That depends on how clean your documents are : it could be hard to
convert them. But I agree on the principle.


--
Vincent Veyron
http://marica.fr/
Logiciel de gestion des sinistres et des contentieux pour le service juridique


pgsql-general by date:

Previous
From: Sanjay Rao
Date:
Subject: Re: postgres server on windows with high availability and failover safe
Next
From: John R Pierce
Date:
Subject: duplicate postings