st6.py

import sqlite3

conn = sqlite3.connect('my_database.db')
cur = conn.cursor()
cur.execute('USE my_database')

for page in pages:

    '''
    Here's your scraper
    '''
    
    cur.execute('INSERT INTO my_table (col_1,col_2,col_3)', (value_1, value_2, value_3))
    conn.commit()

cur.close()
conn.close()