René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Align sqlite3 transaction handling for autocommit=False with CPython","articleBody":"## Feature\n\n\u003c!-- What Python feature is missing from RustPython? Give a short description of the feature and how you ran into its absence. --\u003e\n\nRustPython exposes the three `Connection.autocommit` modes, but `autocommit=False` does not follow CPython's transaction lifecycle. A connection does not enter a transaction immediately, and `commit()` and `rollback()` do not open a new transaction afterward. Closing a connection and running `executescript()` also do not consistently preserve the selected mode.\n\nCPython keeps a transaction open for `autocommit=False`, reopens one after `commit()` or `rollback()`, rolls back a pending transaction on close, and preserves the behavior of the `True`, `False`, and legacy modes in context managers, DML execution, and `executescript()`.\n\nThis leaves six tests in `Lib/test/test_sqlite3/test_transactions.py` marked as expected failures. Invalid autocommit value validation is outside this scope.\n\n## Python Documentation or reference to CPython source code\n\n\u003c!-- Give a link to the feature in the CPython documentation (https://docs.python.org/3/) in order to assist in its implementation. --\u003e\n\n- [Python 3.14 sqlite3 transaction control](https://docs.python.org/3.14/library/sqlite3.html#transaction-control-via-the-autocommit-attribute)\n- [CPython test_transactions.py](https://github.com/python/cpython/blob/v3.14.5/Lib/test/test_sqlite3/test_transactions.py)","author":{"url":"https://github.com/teddygood","@type":"Person","name":"teddygood"},"datePublished":"2026-07-11T22:00:31.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/8258/RustPython/issues/8258"}