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 _______________________________________________ Qgis-developer mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-developer
