Python SQLite

import sqlite3

con = sqlite3.connect('shop.db')      # file on disk
# or
con = sqlite3.connect(':memory:')     # in-memory, gone on close

con = sqlite3.connect(':memory:')
con.executescript('''
  CREATE TABLE customers (
    id   INTEGER PRIMARY KEY AUTOINCREMENT,
    name TEXT NOT NULL,
    email TEXT UNIQUE
  );
''')

con.execute('INSERT INTO customers (name, email) VALUES (?, ?)',
            ('Ada', 'ada@example.com'))
con.commit()

for row in con.execute('SELECT * FROM customers'):
    print(row)
con.close()

con.row_factory = sqlite3.Row
for row in con.execute('SELECT id, name FROM customers'):
    print(row['name'])    # access by column name

# ✗ Don't
con.execute(f"SELECT * FROM users WHERE email = '{email}'")

# ✓ Do
con.execute('SELECT * FROM users WHERE email = ?', (email,))

with con:           # con as context manager = transaction
    con.execute('UPDATE accounts SET bal = bal - 100 WHERE id = 1')
    con.execute('UPDATE accounts SET bal = bal + 100 WHERE id = 2')
# Auto-commit on clean exit; rollback if an exception propagated.

import sqlite3
con = sqlite3.connect(':memory:')
con.executescript('''
  CREATE TABLE customers (id INTEGER PRIMARY KEY, name TEXT);
  INSERT INTO customers (name) VALUES ('Ada'), ('Linus');
''')
for row in con.execute('SELECT * FROM customers'):
    print(row)