timotheeg / nestrischamps

A web-based OCR and restreamer system for NES Classic Tetris players
MIT License
48 stars 12 forks source link

Add a progress page #104

Closed timotheeg closed 2 years ago

timotheeg commented 2 years ago

With all games being tracked, nestrischamps has a huge amount of information to work with. The scores summary page is interesting but not very insightful. Information could be provided in better ways to be more interesting

Progress is what many people are interested in, for example:

A progress page could make this data available and let people extract insight into their performance. Using some freely available charting libraries could even make this dynamic (e.g. highcharts, or d3js).

As for DB, some simple queries ought to do the trick, for example for scores:

select Date(datetime) as date, max(score)
from scores
where player_id=12345
group by date
order by date asc
timotheeg commented 2 years ago

Done with highcharts: https://nestrischamps.herokuapp.com/stats/progress