Storing pictures in MySQL

[fortytwo]

I might need to store about 1500 catalougue records, each with it's own image of about 20 to 30Kb. Would it be possible to store these images in the database or would just storing a URL to them be a better idea. If storing them in the database is the right thing to to, how do you get them into the database?

Will.

fortytwo
will@hellacool.co.uk

http://www.hellacool.co.uk

 

[realhorrorshow]

just use the url

 

[LocalHero]

If you have to insert it you can insert it as a blob. Be sure to encode them in text first so that you dont damage any data when inserting them. But you should have a point column insted that specify where they are placed.

 

[fortytwo]

I think I might go with the URL option as it will be faster that the encode/decode (the images will be displayed on a rickety old webserver...).

Storing the files in the DB is tempting because it would make organisation much easier though.

Thanks.

fortytwo
will@hellacool.co.uk

http://www.hellacool.co.uk

 

[Roland]

Well, iff you still ogle with the database-storing,

http://www.phpbuilder.com/columns/florian19991014.php3

may be helpful. (But like my colleagues, I would prefer the url-solution.)