[Qgis-developer] Plugins "popularity" algorithm

[Alessandro Pasotti]

Hi,

with the new voting system we have the opportunity to sort the plugins
by popularity, we just need to decide the formula (SQL) to do the
math, this is what we have in each plugin record and can be used for
the SQL math:

* rating_score (sum of all scores)
* rating_votes (number of votes)
* downloads (number of)

the idea is that the number of  download is and index of popularity
but can be biased by how long the plugin has been on the repository,
the woting system should instead be weighted by the number of votes,
the simple average is not probably sufficient.

The score is an integer, ranging 1-5

This is the current quick and dirty scoring algorithm:

 SELECT downloads * (1 + (rating_score/(rating_votes+0.01)/3))

any idea (possibly avoid GROUP BY and SUM or other expensive computations) ?

-- 
Alessandro Pasotti
w3:   www.itopen.it