example python script for inserting values into a single-column sqlite db

sqlite_example_2.py

#!/usr/bin/env python

import sqlite3

def main():
    conn = sqlite3.connect('example.db')
    c = conn.cursor()

    # Create table
    c.execute('''CREATE TABLE example
                 (key text)''')

    # Larger example that inserts many records at a time
    data = ['first','then','finally']
    c.executemany('INSERT INTO example(key) VALUES (?)', zip(data))

    for row in c.execute('SELECT * FROM example ORDER BY key'):
        print(row)

if __name__ == '__main__':
    main()