Python Database Objects (PDO) 1.2.0 Released
Geoff Howland
ghowland at lupineNO.SPAMgames.com
Tue Nov 18 19:06:12 EST 2003
On Tue, 18 Nov 2003 14:15:10 -0500, "Jon Franz" <jfranz at neurokode.com>
wrote:
>> I havent looked at the other DBAPI implementations lately, but with
>> MySQLdb you can set the cursor type to DictCursor, and then you get
>> back a sequence of dictionaries with the field names as the dict keys.
>
>This is true, but unfortunately it isn't standard behavior according to the
>DBAPI 2.0 spec (pep 249).
>Since it isn't standard, it seems everyone that does provide it
>in the module provides it a different way.- if they provide it at all.
>
>With PDO you get this functionality everytime, with no need to change
>your code when you switch databases and DBAPI modules to get it.
>Plus, PDO's implementation of acccess-by-name uses less memory
>than a sequence of mapping objects - excluding the case of very small
>(1-3 record) results, that is. I can exapnd upon how/why if people
>are curious.
Sounds good, if you can update/insert back into the DB by the same
dictionary then I'm sold. I'll go check it out. :)
-Geoff Howland
http://ludumdare.com/
More information about the Python-list
mailing list