|
|
Posted by Matthew Weier O'Phinney on 07/18/05 16:34
* Jasper Bryant-Greene <jasper@bryant-greene.name> :
> George B wrote:
> > is it possible to put in a jpg file into a database? I am trying to make
> > like a catalong and have all the files (including pics) and everyone can
> > see.
> > is this possible?
>
> Sure -- if you're using a MySQL database, just use a BLOB field and put
> the data in as you would a string of text.
Be aware of your storage requirements, however. There are several BLOB
types -- TINYBLOB, BLOB, MEDIUMBLOB, and LONGBLOB -- so make certain you
choose the one that exceeds the maximum file size you expect to place in
the DB.
Additionally, there are performance hits to storing images in a
database. Another approach that is widely used is to store the images on
the filesystem, and then image *details* -- location, size, caption,
photographer, etc. -- in the database. This is typically faster, and
will reduce the number of DB calls.
--
Matthew Weier O'Phinney
Zend Certified Engineer
http://weierophinney.net/matthew/
Navigation:
[Reply to this message]
|