example python script inserting into a sqlite db

sqlite_example.py

#!/usr/bin/env python

import sqlite3

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

    # Create table
    c.execute('''CREATE TABLE example
                 (id integer, key text, value text)''')

    # Larger example that inserts many records at a time
    data = [(1, 'first', 'this'),
            (2, 'then', 'that'),
            (3, 'finally', 'the other')
            ]
    c.executemany('INSERT INTO example VALUES (?,?,?)', data)

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

if __name__ == '__main__':
    main()