[DB-SIG] Result Set Inconsistencies

Kevin Jacobs jacobs at penguin.theopalgroup.com
Wed Jul 16 19:52:14 EDT 2003

On Wed, 16 Jul 2003, Orr, Steve wrote:
> Because results sets can either be lists or tuples (or strings?) the API
> fails its stated purpose. 

You don't see the major users of DB-API drivers resonating with this
argument, so this should be your hint that your use-case is not as
compelling as you think.  DB-API is there to enable database access -- not
hold your hand or write your applications for you.  If you want lists, and
demand lists, then add the six extra characters and write:

  rows = list(cursor.fetchall())

If this is too much effort, then I can think of a several other ways to make
this easier -- and none of them make life more difficult for DB-API driver
authors.  In this case -- less is more.


Kevin Jacobs
The OPAL Group - Enterprise Systems Architect
Voice: (216) 986-0710 x 19         E-mail: jacobs at theopalgroup.com
Fax:   (216) 986-0714              WWW:    http://www.theopalgroup.com

More information about the DB-SIG mailing list