python

Python DB-API is terrible, or how to return dictionaries from a database query

Do you, like me, pull out your hair and get the almost irresistible urge to murder small cute things when forced to use Python's DB-API? Despite being under development for many years it seems to be half-baked at best.

One such idiocy would be the utter lack of dictionary support, the ability that pretty much every other database abstraction layer since, well...forever, has had to allow you to address the columns by name. E.g., print row['firstName'].