GeezerVison

My 2 cents:

The executemany examples are way more complex than the average user needs. We should focus on the sqlite3 module; not on writing fancy iterators.

The only thing that bothers me, is that we do not explicitly mention that the cursor can be used as an iterator. We could add a mention in the cursor class description.

The only thing that bothers me, is that we do not explicitly mention that the cursor can be used as an iterator. We could add a mention in the cursor class description.

I've already got this covered in the #95273 todo list. UPDATE: PR => #95379

I've got quite a lot on at the moment, so I'll leave this one in @CAM-Gerlach's very capable hands, if that's okay!

I wonder if it may make sense to keep a minimum example in the reference, though. The two previous examples ate more than a screenful. How about leaving something like this:

data = [
    ("row1",),
    ("row2",),
]
cur.executemany("insert into t values(?)", data)

How about leaving something like this:

SGTM; concise examples can certainly be helpful to aiding understanding and this one certainly helps me understand the purpose of executemany much better (at least as a relative novice)

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

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

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

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