Return to Snippet

Revision: 9896
at November 28, 2008 06:54 by deepdown


Updated Code
from pysqlite2 import dbapi2 as sqlite

try:
    from sqlite import encode, decode
except ImportError:
    import base64
    sqlite.encode = base64.encodestring
    sqlite.decode = base64.decodestring
else:
    sqlite.encode = encode
    sqlite.decode = decode

imagedata = open('myfile.jpg', "rb").read()
con = sqlite.connect("mydbfile")
cur = con.cursor()
cur.execute('INSERT INTO image(binarydata) VALUES (?)', (sqlite.encode(sqlite.Binary(imagedata)),))
con.commit()
con.close()

Revision: 9895
at November 28, 2008 06:19 by deepdown


Initial Code
from pysqlite2 import dbapi2 as sqlite

imagedata = open('myfile.jpg', "rb").read()
con = sqlite.connect("mydbfile")
cur = con.cursor()
cur.execute('INSERT INTO image(binarydata) VALUES (?)', (sqlite.Binary(imagedata),))
con.commit()
con.close()

Initial URL


Initial Description


Initial Title
SQLite 3 insert binary image data with Python

Initial Tags
image, python

Initial Language
Python