Video statistics database
This database is a derived database, which aims to respond efficiently to queries on Tournesol.
A video's statistics is tuple < video_id, reliability_score, important_score, engaging_score, habit_score, pedagogical_score, layman_score, diversity_score, backfire_score, entertaining_score, n_contributors, n_ratings, pareto_optimal, public_contributors >.
Currently, the list of public_contributors contains a random set of 20 of the public contributors to the video.
Every hour, the entries n_contributors, n_ratings, pareto_optimal and public_contributors are updated.
To do so, we go through all the video ratings
Upon new rating.