Re: Filesystem vs. Postgres for images - Mailing list pgsql-general

From Jeremiah Jahn
Subject Re: Filesystem vs. Postgres for images
Date
Msg-id 1081949530.22054.6.camel@bluejay.goodinassociates.com
Whole thread Raw
In response to Re: Filesystem vs. Postgres for images  (Alex <alex@meerkatsoft.com>)
List pgsql-general
Your code is retrieving the file from the file system. It doesn't have
to be accessible from the web server at all. Our current design uses a
JDBC connection to the database for the metadata (digital
signature,path,name,file type, etc..) and a SOAP call to the same server
(but doesn't have to be) to retrieve/store the image data.
-jj-


On Wed, 2004-04-14 at 08:15, Alex wrote:
> Hi,
> is the file system approach really easier and faster? What if you need
> to protect the image data e.g. you dont want users just to just dowload
> the pictures directly from your website?
>
> -a
>
> Jeremiah Jahn wrote:
>
> >There has got to be some sort of standard way to do this. We have the
> >same problem where I work. Terabytes of images, but the question is
> >still sort of around "BLOBs or Files?" Our final decision was to use the
> >file system. We found that you didn't really gain anything by storing
> >the images in the DB, other than having one place to get the data from.
> >The file system approach is much easier to backup, because each image
> >can be archived separately as well as browsed by 3rd party tools.
> >
> >-jj-
> >
> >
> >On Tue, 2004-04-13 at 07:40, Cott Lang wrote:
> >
> >
> >>On Tue, 2004-04-13 at 01:44, Michal Hlavac wrote:
> >>
> >>
> >>>Hello,
> >>>
> >>>I am working on web portal. There are some ads. We have about 200 000
> >>>ads. Every ad have own directory called ID, where is 5 subdirectories
> >>>with various sizes of 5 images.
> >>>
> >>>Filesystem is too slow. But I don't know, if I store these images into
> >>>postgres, performace will grow.
> >>>
> >>>
> >>Consider breaking your directories up, i.e.:
> >>
> >>/ads/(ID % 1000)/ID
> >>
> >>I use that for a system with several million images, works great. I
> >>really don't think putting them in the database will do anything
> >>positive for you. :)
> >>
> >>
> >>
> >>
> >>
> >>
> >>---------------------------(end of broadcast)---------------------------
> >>TIP 3: if posting/reading through Usenet, please send an appropriate
> >>      subscribe-nomail command to majordomo@postgresql.org so that your
> >>      message can get through to the mailing list cleanly
> >>
> >>
--
Jeremiah Jahn <jeremiah@cs.earlham.edu>


pgsql-general by date:

Previous
From: "Barry L. Geipel"
Date:
Subject: random_page_cost
Next
From: Alexander Cohen
Date:
Subject: columns refered to in view