GeezerVison

However, maybe this is just me, but to me the section did appear pretty heavy on examples, but without as much explicit focus on solving specific user problems, as would be appropriate for a how-to.

Yeah, maybe... but How To's are recipes. How can I create a foo row factory? How do I use a bar row factory? How do I use the sqlite3.Row row factory? I don't think it matters much that it is example heavy. IMO it is too thin for a tutorial, and definitely too thin for an explanation.

Ouch, it just occurred to me that the Cursor also has a row_factory attribute, with the following problems:

• it is not documented (easily fixed; we can do that in this PR done in this PR)
• it is copied from the connection in Cursor.__init__, so changing the connection row factory does not affect the row factories of the cursors belonging to that connection; vice versa

So, more prose coming up.

>>> import sqlite3
>>> cx = sqlite3.connect(":memory:")
>>> cx.row_factory = sqlite3.Row
>>> cu = cx.cursor()
>>> cx.row_factory = None
>>> cu.row_factory == cx.row_factory
False
>>> cu.connection.row_factory == cx.row_factory
True

@CAM-Gerlach: I've reworded the reference, hopefully to the better; IMO the current version reflects the difference between the two row factory attributes more clearly. I also removed the example from ab98877; IMO it is superfluous with the now (hopefully) improved reference. Looking forward to your comments.

Thanks again y'all for improving this part of the docs. I'm going to land this later today. A lot of back and forth, but IMO totally worth it.

Thanks @erlend-aasland for the PR 🌮🎉.. I'm working now to backport this PR to: 3.10, 3.11.
🐍🍒⛏🤖

GH-99778 is a backport of this pull request to the 3.11 branch.

GH-99779 is a backport of this pull request to the 3.10 branch.