Add rankings to monster details

[friedger]

trafficstars

As a user I would like to see the rankings of a monster in the monster details page.

This could be real-time ranking or ranking of the last day.

[friedger]

For technical reasons it is much easier to take a snapshot and evaluate the ranking every 24h.

[leordev]

why is that? we have views in postgres that could easily be used to that by pet_id or even create new ones to be served in graphql, no? @friedger

[friedger]

@leordev You are right. rownumber() on (..) should do the trick.