在 SQLite 数据库中处理二进制数据，例如图片、视频、音频等等

import sqlite3

def create_table():
    conn = sqlite3.connect("pidancode.db")
    cursor = conn.cursor()
    cursor.execute("""
        CREATE TABLE IF NOT EXISTS media (
            id INTEGER PRIMARY KEY,
            name TEXT NOT NULL,
            description TEXT,
            data BLOB NOT NULL
        )
    """)
    conn.commit()
    conn.close()

create_table()

def insert_blob(file_path, name, description):
    conn = sqlite3.connect("pidancode.db")
    cursor = conn.cursor()

    with open(file_path, "rb") as file:
        blob_data = file.read()

    cursor.execute("""
        INSERT INTO media (name, description, data)
        VALUES (?, ?, ?)
    """, (name, description, blob_data))

    conn.commit()
    conn.close()

file_path = "pidancode.jpg"
name = "pidancode.com"
description = "皮蛋编程"
insert_blob(file_path, name, description)

def read_blob(media_id, output_file):
    conn = sqlite3.connect("pidancode.db")
    cursor = conn.cursor()
    cursor.execute("SELECT data FROM media WHERE id = ?", (media_id,))

    blob_data = cursor.fetchone()[0]

    with open(output_file, "wb") as file:
        file.write(blob_data)

    conn.close()

media_id = 1
output_file = "pidancode_output.jpg"
read_blob(media_id, output_file)