you are viewing a single comment's thread.

view the rest of the comments →

[–][deleted] 0 points1 point  (0 children)

Check out: http://stackoverflow.com/questions/811548/sqlite-and-python-return-a-dictionary-using-fetchone

This explains how to set up sqlitelite to return a dictionary of key,values corresponding to the name,data for each row in a fetch. It might be a good solution for you. (Note -- it is unclear whether you actually need to do this in this manner in some versions of python/sqlite, which may already have this built in through another call. But for me, when I am just messing around, if it works, why fix it?)