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>
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
