import sqlite3 def dict_factory(cursor, row): d = {} for idx, col in enumerate(cursor.description): d[col[0]] = row[idx] return d def main(): conn = sqlite3.connect(":memory:") cur = conn.cursor() # conn.row_factory = sqlite3.Row # is ok conn.row_factory = dict_factory # is fail cur.executescript("""   create table if not exists test(  id integer primary key AUTOINCREMENT  );  """) cur.close() for line in conn.iterdump(): print(line) main()