Originally posted by @mwichmann in #93890 (comment):

So (real question, no criticism): does that mean there ought to be more detail in the commit/rollback descriptions, rather than the context manager bit?

The wording of the docs and docstrings for the commit, rollback, and close connection methods can be improved, in order to provide more clarity around transaction handling.

Fixed with:

• gh-93925: Improve doc clarity of sqlite3 commit/rollback, and close #93926
• [3.11] gh-93925: Improve clarity of sqlite3 commit/rollback, and close docs (GH-93926) #94010
• [3.10] gh-93925: Improve clarity of sqlite3 commit/rollback, and close docs (GH-93926) #94011