http://code.activestate.com/recipes/users/112415/2003-01-28T15:29:03-08:00ActiveState Code Recipes2001-11-19T20:48:09-08:00Steve Holdenhttp://code.activestate.com/recipes/users/112415/http://code.activestate.com/recipes/81252-using-dtuple-for-flexible-query-result-access/

<p style="color: grey"> Python recipe 81252 by <a href="/recipes/users/112415/">Steve Holden</a> (<a href="/recipes/tags/database/">database</a>). Revision 3. </p> <p>Greg Stein's dtuple module deserves wider recognition. This recipe shows you how to use it with a simple list of database field names.</p>

2003-01-28T15:29:03-08:00Steve Holdenhttp://code.activestate.com/recipes/users/112415/http://code.activestate.com/recipes/81189-pretty-printing-of-database-cursor-contents/

<p style="color: grey"> Python recipe 81189 by <a href="/recipes/users/112415/">Steve Holden</a> (<a href="/recipes/tags/database/">database</a>). Revision 2. </p> <p>One of the problems of dealing with databases is presenting the result of a query when you may not know much about the data. This recipe uses the cursor's description attribute to try and provide appropriate headings, and optionally examines each output row to ensure column widths are adequate.</p>

2001-10-11T20:15:59-07:00Steve Holdenhttp://code.activestate.com/recipes/users/112415/http://code.activestate.com/recipes/81190-one-line-2-d-array-transposition/

<p style="color: grey"> Python recipe 81190 by <a href="/recipes/users/112415/">Steve Holden</a> (<a href="/recipes/tags/shortcuts/">shortcuts</a>). </p> <p>A short way to turn rows into columns. Not necessarily the fastest, mind you. The list comprehension is your friend.</p>