Feature Idea: Team Head-to-Heads

[ipaulhamus]

I'm a Smash player who moved over to Splatoon around 2 years ago, and one feature that stats viewers such as Supermajor or PGStats have is to see player's you've played against and your win/loss ratio against them. A large number of Sendou teams put some highlight teams they have beaten on their profile, and making it easy to view all of the head-to-heads for a team would be a very useful feature. I haven't read into the structure of the database to see how hard to this would be to implement; however, if this is a reasonable feature request I would be happy to help out with it.

[Sendouc]

I agree this would be really cool and the design choices I made with the tournament feature were done partly with this in mind (e.g. that you need to select exact roster playing)

First step would probably to chart out the current DB design and to find out can it support this use-case without denormalizing and if not then what should the shape be like to efficiently query head to head across all tournaments/SQ etc.