lkeeton wrote:

{snip!}

I am trying to acomplish much the same thing and just asked the list how to do this from a perl script using the DBI and DBD::mysql interface. So far no answers, but I will be trying experiments on my own over the next couple of days.

My thought so far:

take the image and read it into a buffer in one munch use the pack call to uuencode the info store the blob as if it were a regular string.

Your table should have a column to "remember" the original format type (.gif, .jpeg, .png, whatever) so it can be properly constituted later.

Another thought:

A web page (or generated HTML) could reference a perl script that pulls the BLOB from the database, reconstitutes it, and returns it as a stream.

<img src="http://my.site.com/cgi-bin/getimage.pl?imageid=xyzabc"> where xyzabc is some sort of key that identifies the image in the database for retrieval. The perl script would then return the stream starting with

Content-Type: image/jpeg (or whatever)

(three blank lines)

and the browser *should* display the image. Worth a try.... Not 100% sure about the last bit.