use BLOBS or use pointers to files on the filesystem?

From: "Travis Bear" <ec9098(at)no(dot)spam(dot)go(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: use BLOBS or use pointers to files on the filesystem?
Date: 2001-12-09 23:49:29
Message-ID: dMSQ7.21755$wL4.48308@rwcrnsc51
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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-----

Responses

Browse pgsql-general by date

  From Date Subject
Next Message john 2001-12-10 00:36:25 v6.5.3 and JDBC6.5-1.2 driver FastPath protocol Error: Z
Previous Message Francisco Reyes 2001-12-09 21:45:37 Re: Questions about the upcoming 7.2?