taddeimania / lctva

Live Coding TV Analytics
17 stars 6 forks source link

Leaderboards #13

Open taddeimania opened 8 years ago

taddeimania commented 8 years ago

Daily / Monthly leaderboards.

I'd love to have a task that puts together a leaderboard of previous days data and just saves the user and their numbers to a series of tables (or just a single table with serialized complex data). This could be compiled at midnight UTC.

taddeimania commented 8 years ago

Okay i can't stay still on this one - picking up this task.

http://lctva.joel.io/leaderboards/

it actually caches the result in the DB so it doesn't touch the huge Node table but an indexed/precalculated (by a nightly task) table. :dancers: