ArieOne thing I would consider, is to move "log_wlt" and "player_last" from views to materialized views (unlike a view these need their own indexes). You could update these materialized views (concurrently) after a new batch of log files is imported. This might improve part of the peers query.
Hm, that's a good idea. Previously, player_last was a table, which I suppose is a kind of manually-materialized view.
supradoes this site has any sort of API?
Nope. Please send a PR :)
it would be cool to have it because then we could use it for skill prediction on tf2pickup.org I guess
This is being tracked by this issue. But it's not very high on the list of priorities atm. Though part of the reason for switching to postgres in the first place was so I could have multiple processes modifying the database at once, such as a process which calculated elo.
+ some option to filter 6v6/hl/2v2 games out from the rest when checking a player
that would be way cooler than looking at the divisions on etf2l for europeans, in case of burgers there is probably no good way to do that atm
no idea about apac
ps: this is probably the biggest issue why we don't have a european pickup site atm
I want to start scraping RGL at some point (see this issue). Unfortunately, RGL doesn't really have an API, so I'd have to scrape their site :l. Honestly, if ETF2L has an API I would look into them first.
glasscouple things i noticed
-tried filtering blaze's logs down to just soldier on product in the logs.tf era, and it returned nothing
Can you link? Thanks.
-is there a way to generate winrate after filtering out ultiduo and stuff?
Nope, sorry. I'm working on adding filters for every page on the site, but the overview hasn't gotten that treatment yet. Though perhaps I could just add this to the totals page...
-b4nny has 283% acc on pyro
TimTumthe pyro acc is possible because of the detonator or other flare guns
Basically this. At the moment there is not too much processing on top of raw stats from logs.tf. So if/when I write my own logs parser we can address this. But until then pyro will always have like 3x the hits vs shots.
-class stats seem inaccurate. it is claiming arrek is undefeated on sniper, n=5. is that like, logs where he played majority sniper
Winrate is calculated based on games with at least ⅔ time on this class. You can hover over the column headers and the tooltip will show some of the criteria. DPM, accuracy, and time played are based on all times you played that class.
cheers. don't change the design. every website built after 2010 looks like shit
I didn't have much of a choice :)
(that being said, if anyone can help me make a logo/favicon or can help with the CSS, I'd appreciate it)