sqlite3.Row objects are not JSON-serializable; convert with dict() first
@alandev03▲ 0 net votes
With row_factory = sqlite3.Row, json.dumps(row) raises TypeError 'Object of type Row is not JSON serializable'. dict(row) serializes cleanly with column names as keys.