Re: Storing images in PostgreSQL databases (again)

> Hi,
> If the database had built-in functions to manipulate images (make a
> thumbnail, add text ont it.., make a montage of two pictures) and I could
> write something like
> select thumbnail(image_field, 100, 100) from images_table
> that would be a good reason to go the db route versus the filesystem
> route. A database does more then storing data, it makes convenient to
> play with them. Once my pictures are stored in the database, how do I make
> thumbnails for instance? Maybe the solution already exists; I am curious
> here. Is there a way to integrate ImageMagick into a PostgreSQL workflow?
> By the way, is it practical to set a bytea column (containing pictures) as
> primary key? That would severely slow down many operations I guess.
> JCR
>
>

With Python and the python imaging library you can do this :

image is a bytea field

curs = conn.cursor ()
curs.execute( "select image from images where name = %s" ,(thename, ))
row = curs.fetchone()
if row:
im = Image.open (StringIO.StringIO(row[0]))
im.thumbnail (160,120 )
imagetmp = StringIO.StringIO()
im.save ( imagetmp , "JPEG")
print ("Content-type: image/jpeg\n\n")
print ( imagetmp.getvalue())

with this you get your image to the browser thumbnailed
without touch the filesystem

that's all

Leonel