Message-ID: <4DD43867.2040709@ulb.ac.be>
Date: Wed, 18 May 2011 23:21:43 +0200
From: Julien Cigar <jcigar@ulb.ac.be>
User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US;
	rv:1.9.2.17) Gecko/20110430 Thunderbird/3.1.10
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Re: column type for pdf file
References: <4DD42A1C.30202@encs.concordia.ca> <4DD4301F.4010403@ulb.ac.be>
	<20110518210041.GF2498@hermes.hilbert.loc>
In-Reply-To: <20110518210041.GF2498@hermes.hilbert.loc>
Content-Type: multipart/mixed; boundary="------------060609000701070108090704"

This is a multi-part message in MIME format.
--------------060609000701070108090704
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 05/18/2011 23:00, Karsten Hilbert wrote:
> On Wed, May 18, 2011 at 10:46:23PM +0200, Julien Cigar wrote:
>
>> Unless you've good reasons to do so it's best to store the file on
>> the file system
> Why ?
>
> If you suggest reasons are needed for storing the PDF in the
> database I'd like to know the reasons for *not* doing so.
>

It increases the load, consume connections, but the biggest drawback is 
probably the memory consumption ..

IMHO storing binary data in a database is almost always a bad idea .. it 
could be OK to store things like avatars, small icons, etc, but 
certainly not to store files of several MB ... file systems are done for 
that !

> Karsten


--------------060609000701070108090704
Content-Type: text/x-vcard; charset=utf-8;
 name="jcigar.vcf"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
 filename="jcigar.vcf"

begin:vcard
fn:Julien Cigar
n:Cigar;Julien
org;quoted-printable:Universit=C3=A9 Libre de Bruxelles
adr:;;;;;;Belgium
email;internet:jcigar@ulb.ac.be
tel;cell:+32 (0) 473 30 71 92
x-mozilla-html:FALSE
url:http://www.biodiversity.be
version:2.1
end:vcard


--------------060609000701070108090704--