save multi images in sql table

The best way is to store images in a separate table with one row per image. Either save them as BLOB/VARBINARY (binary data) or, preferably, store just the file path/URL and keep the images in file storage (server, AWS S3, Azure, etc.) for better performance.

1. Convert images to binary format (BLOB).
2. Create a table with a column to store image data.
3. Insert each image into the table using SQL INSERT statements.

import sqlite3

conn = sqlite3.connect('images.db')

cursor = conn.cursor()

cursor.execute('''

    CREATE TABLE IF NOT EXISTS images (

        id INTEGER PRIMARY KEY AUTOINCREMENT,

        name TEXT,

        image BLOB

    )

''')

conn.commit()