René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Improve clarity of sqlite3 transaction handling docs","articleBody":"**Documentation**\r\n\r\nThe sqlite3 module docs has a section called [Controlling Transactions](https://docs.python.org/3/library/sqlite3.html#controlling-transactions).\r\n\r\nThere are some improvement possibilities:\r\n\r\n- The current docs start out by describing the _SQLite_ autocommit mode. This _can_ be confusing to new users, especially since the DB API (PEP-249) describes its own autocommit behaviour. Suggesting to tone down the SQLite autocommit mode and instead focus on what the sqlite3 module does.\r\n- The docs say that implicit BEGIN statements are issues before DML statements. This is partly true. Implicit BEGIN statements are issued before INSERT, UPDATE, DELETE, and REPLACE statements _when_ executed by `execute` or `executemany`, but not by `executescript`. Other DML statements do not receive such treatment.\r\n- We should update the docs of the `execute`, `executemany`, and `executescript` cursor methods to briefly mention their transaction control peculiarities.\r\n- Since _SQLite autocommit mode_ is mentioned, we should note that it is in fact possible to query this (low-level) mode using the `in_transaction` connection attribute. Such information can help developers debug transaction control problems.\r\n- Possibly augment the docs of the `isolation_level` attribute. Currently, the `isolation_level` _property_ of `connection` refer to the docs of the `isolation_level` _attribute_, which again refer to the _Controlling Transactions_ section. The `isolation_level` property should have a concise description (reference), and link to the `isolation_level` attribute. The `isolation_level` attribute should provide a _reference_ for what it does, and briefly mention expected behaviour. The _Controlling Transactions_ section should provide more background (explanation) to what is happening, and it should briefly mention PEP 249, and the SQLite autocommit mode.\r\n- Revisit any transaction control examples and possibly turn them into clearer how-to's, or guides.","author":{"url":"https://github.com/erlend-aasland","@type":"Person","name":"erlend-aasland"},"datePublished":"2022-06-20T08:30:30.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":3},"url":"https://github.com/94017/cpython/issues/94017"}