import sqlite3 as db

data_base = db.connect("name_photo.db")
cursor = data_base.cursor()
with open('new_pic.png', 'rb') as pic:
    picture = pic.read()

cursor.execute("CREATE TABLE IF NOT EXISTS n_p(name text, photo BLOB)")

cursor.execute("INSERT INTO n_p VALUES(:name, :photo)",
               {
                   'name': "amine",
                   'photo':picture
               }

               )

cursor.execute("SELECT *, oid FROM n_p")
items = cursor.fetchall()
photo = items[0][1]
with open('amine.jpg', 'wb') as pic:
    new_picture = pic.write(photo)

data_base.commit()
data_base.close()