Re: IMAGES IN DB

[Shannon Eric Peevey <speeves@unt.edu>]

Svensson, B.A.T. (HKG) wrote:

> You probaly need to set the content type properly.
>
> A comment on storing binary content in an RDBMS's:
>
> QUESTION: Is it possible to do a SELECT on an image that makes sence.
> ANSWER: no!
>  
that is what metadata is for.

> So, the concensus might be that one rather would like to store
> the images as a plain file on the server, and just store a file
> pointer in the RDBMS.
>
>  
Ahhh....  The age old question about storing images in the database ;)  
There are many a flame war about this in the archives, but I believe 
that there are times to store the images in a database.   For example, 
if portability is your main concern, if your file structure changes 
frequently, or is complex enough to make it difficult to manage.  The 
obvious caveats are: a hit in performance and a very large database.

Just my $0.02 :)

speeves
cws

--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php