Add rankings to monster details

MonsterEOS / monstereos

A Tamagotchi and Battle Game for EOS Blockchain :)

https://monstereos.io

MIT License

186 stars 61 forks source link

Open friedger opened 6 years ago

friedger commented 6 years ago

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 commented 6 years ago

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

leordev commented 6 years ago

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 commented 6 years ago

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