Postgres Pro
Downloads
Home   >   mailing lists

Re: Best way to store and retrieve photo from PostGreSQL - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: Best way to store and retrieve photo from PostGreSQL
Date
Msg-id 20070225160912.GA21166@KanotixBox
Whole thread Raw
In response to Best way to store and retrieve photo from PostGreSQL  ("Alain Roger" <raf.news@gmail.com>)
Responses Re: Best way to store and retrieve photo from PostGreSQL  (Tommy Gildseth <tommy@gildseth.com>)
Re: Best way to store and retrieve photo from PostGreSQL  (Tomas Vondra <tv@fuzzy.cz>)
List pgsql-general
Tree view 
Alain Roger <raf.news@gmail.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 ;-)


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."    (unknow)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

pgsql-general by date:

Previous
From: "Alain Roger"
Date:
Subject: Best way to store and retrieve photo from PostGreSQL
Next
From: "Joris Dobbelsteen"
Date:
Subject: Re: Best way to store and retrieve photo from PostGreSQL