Modern Python Standard Library Cookbook

How to do it...

For this recipes, the steps are as follows:

1. Using the sqlite3 module, it's possible to create a new database file, create a table, and insert entries into it:

import sqlite3


with sqlite3.connect('/tmp/test.db') as db:
    try:
        db.execute('''CREATE TABLE people (
            id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, 
            name TEXT, 
            surname TEXT, 
            language TEXT
        )''')
    except sqlite3.OperationalError:
        # Table already exists
        pass

    sql = 'INSERT INTO people (name, surname, language) VALUES (?, ?, ?)'
    db.execute(sql, ("Alessandro", "Molina", "Italian"))
    db.execute(sql, ("Mika", "Häkkinen", "Suomi"))
    db.execute(sql, ("Sebastian", "Vettel", "Deutsch"))

2. The sqlite3 module also provides support for cursors, which allow us to stream the results of a ...