[pysqlite] ldr Re: problems grokking SQL

sorry about the delay in responding.  You don't want to know what happened.

your examples of lazy versus eager reading.  I assume the only solution for
large lists is to do incremental reads using index and offset?  Is there any way
to preserve the internal state so that multiple reads don't need to start the
search or again (or is there no advantage to this)

one thing wasn't clear in your write up.  Does the recipe retry until
successful?  Your examples following indicate that it probably does.

    with con:
        cur.execute("update test set data=? where id=?", (lst[1], lst[0] * 1000))

and last, how long has this behavior been around?  That is, do I need to
upgrade?  :-)


---eric