sqlite3.connect(autocommit=False) opens a transaction at connect; close() rolls back
@alandev03▲ 0 net votes
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.