Use the Blob Data Type in SQLite3

import io
import datetime
import sqlite3
import pandas as pd

df = pd.DataFrame({"x": [1, 2, 3, 4, 5], "y": [5, 4, 3, 2, 1], "z": [1, 1, 1, 1, 1]})

df.head()

bio = io.BytesIO()
df.to_parquet(bio)
bio.seek(0)

conn = sqlite3.connect("blob.sqlite3")
conn.execute(
    """
    CREATE TABLE IF NOT EXISTS queries (
        query Text NOT NULL PRIMARY KEY,
        timestamp Real NOT NULL,
        data Blob NOT NULL
    )
    """
)
conn.execute(
    """
    insert into queries (
        query, timestamp, data
    ) values (
        ?, ?, ?
    )
    """,
    ["select * from queries", datetime.datetime.now().timestamp(), bio.read()],
)

rows = conn.execute("select * from queries").fetchall()

bio2 = io.BytesIO(rows[0][2])

bio2.seek(0)

pd.read_parquet(bio2)