pysqlite - how to save images

python image sqlite blob pysqlite
Mustafa Zengin picture Mustafa Zengin · Jul 22, 2010 · Viewed 15.1k times · Source

I need to save an image file into sqlite database in python. I could not find a solution. How can I do it?

Thanks in advance.

Answer

nazca picture nazca · Jul 22, 2010

write - cursor.execute('insert into File (id, name, bin) values (?,?,?)', (id, name, sqlite3.Binary(file.read())))

read - file = cursor.execute('select bin from File where id=?', (id,)).fetchone()

if you need to return bin data in web app - return cStringIO.StringIO(file['bin'])

Related questions

How do I resize an image using PIL and maintain its aspect ratio?

Is there an obvious way to do this that I'm missing? I'm just trying to make thumbnails.

Read More
Saving a Numpy array as an image

I have a matrix in the type of a Numpy array. How would I write it to disk it as an image? Any format works (png, jpeg, bmp...). One important constraint is that PIL is not present.

Read More
How to resize an image with OpenCV2.0 and Python2.6

I want to use OpenCV2.0 and Python2.6 to show resized images. I used and adopted this example but unfortunately, this code is for OpenCV2.1 and does not seem to be working on 2.0. Here my code: import os, glob import cv …

Read More