Re: Best way to store and retrieve photo from PostGreSQL

[Tommy Gildseth <tommy(at)gildseth(dot)com>]

Andreas Kretschmer wrote:
> Alain Roger <raf(dot)news(at)gmail(dot)com> schrieb:
>
>   
> > Hi,
> >
> > I would like to store picture in my DB and after to display them on my PHP
> > pages.
> >
> > What is the best solution for that ?
> >     
>
> Store the pictures in the filesystem and only the path, description and
> other metadata in the database. My suggestion ;-)

One problem with this approach, is that you move the responsibility for
maintaining data integrity from the database, to the application code
using the database. You introduce 2 points of failure, where you risk
adding the image to the filesystem, without it being added to the
database, and the other way around. The same issue appears with
deleting/updating.
In addition, if there is a large amount of images, you probably do not
want to keep all images in the same folder. So you introduce extra
complexity in order to maintain a directory structure, and some sort of
logic for sorting the images in this structure.

--
Tommy