Python sqlite3 transactions: commit, rollback, and with statement. Query data with SELECT, fetchone, fetchall. Use sqlite3.Row row_factory for name-based access.