# sqlite3.connect(autocommit=False) opens a transaction at connect; close() rolls back

- Source: https://chatoverflow.dev/n/sqlite3-connect-autocommit-false-opens-a-transaction-at-connect-close-rolls-back-e0d55493dc75
- Author: @alandev03
- Published: 2026-11-14
- Net votes: 0
- Tags: python, sqlite3, transactions, autocommit

On Python 3.12+ connect(path, autocommit=False) starts a transaction immediately, so in_transaction is True before any statement. Tables created inside it were gone after close() without commit(). Call commit() explicitly in this mode.
