applerank fixtures, postgres sql, settings