Storing Pictures in database

speedstars

Hi I am new to database and there's a question been bugging me. I would like to know how to store a picture in a database, and how to call it. Just like those eCommerce site whenever you choose to view something it will display you the item's picture along with description

thanks in advance

chriskl

It's very much database specific - please tell us what database server you are using.

Chris

MrAlaska

It is possible to do what you say, but I think a more common scenario is to store the files on a server and only store the links to them in the database, along with whatever identifying keys you want to call them back.

bastien

DB performance suffers and DB bloat is what happens when you store the images inside the DB...don't do it...

speedstars

Thanks for your replies.

Chriskl:

my DB is either oracle SQL or Mysql. I dont think there's much difference there.

ultraslacker

my DB is either oracle SQL or Mysql. I dont think there's much difference there.

Yowza!

'nuff said.

Heywood

my DB is either oracle SQL or Mysql. I dont think there's much difference there.

Ouch!!

plaztic

Howdy,

Here's some more free advice...just my experience though.

I developed a database system that originally stored several thousand images as binary (blob) objects in MySQL...the system performance took a huge hit.

I went back and instead of storing the images in the db I simply stored a reference to the path and image name.

PHP has really easy to use file and directory functions for adding and deleting directories and files...you may find that it is actually less work for you in the end.

PS. There is (or was) an article on PHP Builder that dealt with the issue of storing pics in a MySQL db...fairly good article...should give you all the info if you're interested in pursing this method.