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

From: Vincent Veyron <vv(dot)lists(at)wanadoo(dot)fr>
To: Arash pajoohande <apajoohande(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: what is the best way of storing text+image documents in postgresql
Date: 2011-06-10 15:15:59
Message-ID: 1307718959.2434.18.camel@asus-1001PX.home
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2011-06-10 17:28:22 duplicate postings
Previous Message Sanjay Rao 2011-06-10 15:13:22 Re: postgres server on windows with high availability and failover safe