Doc :

• SQLite https://www.sqlite.org/docs.html
• Librairie Python : https://docs.python.org/2/library/sqlite3.html

Si le fichier n'existe pas, il est créé au moment de la connexion.

import sqlite3
conn = sqlite3.connect('example.db')
 
...
 
conn.commit()
conn.close()

cur = conn.cursor()
 
cur.execute('''CREATE TABLE people (
    name text,
    age integer,
    size real,
    weight real)
    ''')

cur = conn.cursor()
 
cur.execute("""INSERT INTO people
    (name, age, size, weight)
    values 
    (:name, :age, :size, :weight);""", {
        "name"  : "Marc Lebrun",
        "age"   : 49,
        "size"  : 1.85,
        "weight": 92.5
    })

cur = conn.cursor()
 
cur.execute("""select * from prople
    where name=:who and age=:age;""", {
        "who": "Arnold",
        "age": 73
    })