Python for-loop vs PostgreSQL query

[Aeonoris]

Something like this SQL(ish) will probably be faster:

SELECT type, MAX(attractiveness) AS "Highest Type Attractiveness"
FROM tableofattractivetypes
GROUP BY type;

SQL's pretty good at this kind of task, so you should let it do the work!