Postgres Pro
Downloads
Home   >   mailing lists

Thread: How do I manage PDF file

How do I manage PDF file

From
Terence Ng
Date:
Hi,

For a catalogue, one or more products are described by
a PDF file regarding to the specification of the
products. And there are many files.

How should I manage these PDF files?  Could I store
these files to PostgreSQL or I can only store the
links to these files?

Best regards,
Terence

_______________________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com.hk address at http://mail.english.yahoo.com.hk

Re: How do I manage PDF file

From
"Shridhar Daithankar"
Date:
On 23 Jul 2003 at 21:03, Terence Ng wrote:
> How should I manage these PDF files?  Could I store
> these files to PostgreSQL or I can only store the
> links to these files?

Store them in database if you can afford the space. It offers transaction safe
data handling which name linking approach does not offer..

Bye
 Shridhar

--
QOTD:    Ludwig Boltzmann, who spend much of his life studying statistical
mechanics died in 1906 by his own hand.  Paul Ehrenfest, carrying    on the work,
died similarly in 1933.  Now it is our turn.        -- Goodstein, States of Matter

Re: How do I manage PDF file

From
Jonathan Bartlett
Date:
You can store them in the filesystem or in PostgreSQL.  In PostgreSQL, you
can either store them as BLOBs or bytea columns.  I prefer bytea columns
for numerous reasons.  The only reason I can think of to use a BLOB is if
you only want to return _part_ of the file.

Jon

On Wed, 23 Jul 2003, [iso-8859-1] Terence Ng wrote:

> Hi,
>
> For a catalogue, one or more products are described by
> a PDF file regarding to the specification of the
> products. And there are many files.
>
> How should I manage these PDF files?  Could I store
> these files to PostgreSQL or I can only store the
> links to these files?
>
> Best regards,
> Terence
>
> _______________________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com.hk address at http://mail.english.yahoo.com.hk
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>

Re: How do I manage PDF file

From
Karsten Hilbert
Date:
> You can store them in the filesystem or in PostgreSQL.  In PostgreSQL, you
> can either store them as BLOBs or bytea columns.  I prefer bytea columns
> for numerous reasons.  The only reason I can think of to use a BLOB is if
> you only want to return _part_ of the file.
And even that can be done with substr() which I have used to
allow for chunked fetching of BLOBs over socket
implementations that die when overloaded (due to faulty flow
control).

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346