use BLOBS or use pointers to files on the filesystem? - Mailing list pgsql-general

From Travis Bear
Subject use BLOBS or use pointers to files on the filesystem?
Date
Msg-id dMSQ7.21755$wL4.48308@rwcrnsc51
Whole thread Raw
Responses Re: use BLOBS or use pointers to files on the filesystem?
Re: use BLOBS or use pointers to files on the filesystem?
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi

I'm kind of a database newbie in general,  so be nice to me if this
is a bonehead question.  I am building a java servlet based web
application to manage photos and images.  My first thougth has been
to store the images as BLOBs in the database, but I read one user say
that you're better off not using BLOBs.  Instead, he says, store your
large data objects as files on the filesystem, and just use the
database to store the path to the file and any file-related meta
data.

I wasn't sure what to think of this, so I was hoping to get some
other ideas and opinions.  I expect to accumulate 1-2 gigs of new
data per year, max, with average image size being 700k.

Also, if I've missed any obvious documentation on this issue please
feel free to send it my way.

Thanks!


Travis

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.8 for non-commercial use <http://www.pgp.com>

iQA/AwUBPBP9vKBIzo/FCjIeEQLffgCePrTcI3ugWC9NhdRT12Pt1XFnW0gAoLl3
t8HQbiGAOJt6jDhZNZlk+2GL
=N3bL
-----END PGP SIGNATURE-----




pgsql-general by date:

Previous
From: "Mourad EL HADJ MIMOUNE"
Date:
Subject: Limit of sequence
Next
From: James Thornton
Date:
Subject: Re: update returns 1, but no changes have been made