title: Python - mysqlDB, sqlite result as dictionary
body: <p>When I do someting like</p>
  
  <pre><code>sqlite.cursor.execute("SELECT * FROM foo")
  result = sqlite.cursor.fetchone()
  </code></pre>
  
  <p>I think have to remember the order the columns appear to be able to fetch them out, eg</p>
  
  <pre><code>result[0] is id
  result[1] is first_name
  </code></pre>
  
  <p>is there a way to return a dictionary? so I can instead just use result['id'] or similar?</p>
  
  <p>The problem with the numbered columns is, if you write your code then insert a column you might have to change the code  eg result[1] for first_name might now be a date_joined so would have to update all the code...</p>