[storm] Confused about connections, cursors, transactions (SQLite)

[Michael Elsdörfer]

http://pastebin.com/f6d456520

Have a look at the snippet above. Using SQLite, I get a transaction
error (MySQL works fine).

Note that the error occurs only if there are more than 10 rows in the
database (the fetchmany arraysize apparently used). If you add less
than then 11 feed objects, it works.

Now I've been looking through the source code, but I'm not sure what
to make of this issue. Each Store is a connection, and each query
seems to use it's own cursor. The SQLite backend apparently sends
BEGIN and COMMIT statements to the connection itself.

Is this a bug in Storm? In pysqlite? A general SQlite limitation? I
seem unable to recreate the problem using the pysqlite2 interface
directly, but I'm probably not getting the transactions right.

Am I supposed to use a separate Store object for the find()?

Storm 0.12
SQLite 2.4.0
Windows

Thanks for any help.

Michael