How can I get dict from sqlite query?
You could use row_factory, as in the example in the docs: import sqlite3 def dict_factory(cursor, row): d = {} for idx, col in enumerate(cursor.description): d[col[0]] = row[idx] return d con = sqlite3.connect(“:memory:”) con.row_factory = dict_factory cur = con.cursor() cur.execute(“select 1 as a”) print cur.fetchone()[“a”] or follow the advice that’s given right after this example in … Read more