如何从sqlite存储和检索blob

CREATE TABLE images (
    id INTEGER PRIMARY KEY,
    name TEXT,
    image BLOB
);

INSERT INTO images (name, image) VALUES (
    'example_image',
    readfile('path/to/image.jpg')
);

SELECT * FROM images WHERE name = 'example_image';

import sqlite3

# 连接到SQLite数据库
conn = sqlite3.connect('example.db')

# 查询BLOB数据
cursor = conn.execute("SELECT * FROM images WHERE name = 'example_image'")
row = cursor.fetchone()

# 将BLOB数据保存为图像文件
with open('output_image.jpg', 'wb') as f:
    f.write(row[2])

# 关闭数据库连接
conn.close()