Re: IMAGES IN DB

From: Date: Sun, 08 Feb 2004 14:20:58 +0000
Subject: Re: IMAGES IN DB
References: 1  Groups: php.windows 
Request: Send a blank email to php-windows+get-22767@lists.php.net to get a copy of this message
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

« previous php.windows (#22767) next »