René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Clarify sqlite3 documentation of PEP 249 compliance for commit modes","articleBody":"# Documentation\r\n\r\nThe `sqlite3` documentation for the new `Connection.autocommit` attribute introduced in PR #93823 states:\r\n\r\n```\r\n   .. attribute:: autocommit\r\n\r\n      This attribute controls :pep:`249`-compliant transaction behaviour.\r\n      :attr:`!autocommit` has three allowed values:\r\n\r\n      * ``False``: Select :pep:`249`-compliant transaction behaviour,\r\n        implying that :mod:`!sqlite3` ensures a transaction is always open.\r\n\r\n        This is the recommended value of :attr:`!autocommit`.\r\n\r\n      * ``True``: Use SQLite's `autocommit mode`_.\r\n        :meth:`commit` and :meth:`rollback` have no effect in this mode.\r\n\r\n      * :data:`LEGACY_TRANSACTION_CONTROL`:\r\n        Pre-Python 3.12 (non-:pep:`249`-compliant) transaction control.\r\n        See :attr:`isolation_level` for more details.\r\n```\r\n\r\nThe sentence ‘This attribute controls :pep:`249`-compliant transaction behaviour.’ is misleading as only the new manual commit mode (`autocommit=False`) is PEP-249-compliant, since PEP 249 specifies only the manual commit mode.\r\n\r\nLikewise, the sentence ‘Pre-Python 3.12 (non-:pep:`249`-compliant) transaction control.’ is misleading as only the legacy manual commit mode (`isolation_level='DEFERRED'`, `isolation_level='EXCLUSIVE'`, or `isolation_level='IMMEDIATE'`) is non-PEP-249-compliant, since PEP 249 specifies only the manual commit mode.\n\n\u003c!-- gh-linked-prs --\u003e\n### Linked PRs\n* gh-99829\n\u003c!-- /gh-linked-prs --\u003e\n","author":{"url":"https://github.com/geryogam","@type":"Person","name":"geryogam"},"datePublished":"2022-11-27T22:31:46.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/99828/cpython/issues/99828"}