[DB-SIG] Use of record sets

Jon Ribbens jon+python-db-sig@unequivocal.co.uk
Wed, 4 Apr 2001 18:10:18 +0100


John Shafaee <pshafaee@hostway.com> wrote:
> I noticed that the DB API interface is still using sequences for working
> with query results. Although this is sufficient, sequences are indexed
> by integers and are therefore difficult to program with. For example, as
> shown in the following code, using sequence indexes make the code less
> readable and more error prone.

MySQLdb allows you to specify the DictCursor class as the cursor type
and then it provides results in mappings instead of sequences. Maybe
the DB API should standardise on this.