OpenRA/OpenRAWeb

Player statistics

Mailaender opened this issue · 11 comments

Mailaender commented

OpenRA/OpenRA#10803 and OpenRA/OpenRAMasterServer#35 collect a lot of data that is currently only manually analysed. Displaying the anonymous data in pie charts per release might be interesting to thirdparties as well. https://www.gamingonlinux.com does surveys all the time to assess the Linux gaming market share. Displaying the collected data might also help against the irrational fear "my data is collected" without differentiating what data is collected and that our approach really protects privacy.

kingo55 commented

I like this idea. Are you collecting this in a database somewhere?

If so, you could embed graphs with another Python open source project called Superset: https://github.com/airbnb/superset

Mailaender commented

I like this idea. Are you collecting this in a database somewhere?

Yes, see https://github.com/OpenRA/OpenRAMasterServer but I can't find a link to the live one at the moment. It was http://master.openra.net/db/openra.db last time I checked.

  • 👍1
pchote commented

The database was made private after we became aware of a specific security issue related to the data it contained. If we have a real use case for making the data public then somebody will need to write a frontend API that serves the relevant and sanitized data.

  • 👍1
kingo55 commented

Thanks - maybe there's a sanitised DB somewhere or a schema.

I'll take a look at the SQLite(?) DB on Github but it sounds like that might be old/empty?

Mailaender commented

I suggest you join http://www.openra.net/community/ especially the IRC channel for coordination.

kingo55 commented

Sorry about the wait, @Mailaender - I've provisioned a server with Superset and have a rough dashboard setup:

screen shot 2017-03-19 at 3 17 08 pm

It's designed to be interactive and easy to use with a wide array of visualisations:

screen shot 2017-03-19 at 3 17 40 pm

There's also got a built in SQL editor integrated into the visualisation workflow, so you can explore the raw data without jumping into the command line, Excel etc.

screen shot 2017-03-19 at 3 13 24 pm

And any charts you build inside it, can be embedded elsewhere on the internet through iframes:

screen shot 2017-03-19 at 3 27 12 pm

At work I've deployed it through Docker, which gives us an easy upgrade/setup path. Requests are handled through Nginx to allow for caching, SSL, SPDY and any serverside redirects.

Anyway, if you want to have a closer look at it let me know and I'll share the login/address. The permissions are very fine-grained, so it's easy to share as much or as little access as you like.

PS. When is a good time to join IRC? It looks like everyone is in EU/US.

Mailaender commented

Looks good. Try to contact @ihptru and @baxxxster in IRC or via e-Mail for deployment. I don't have access to the servers.

kingo55 commented
Baxxster commented

You can e-mail me at glenn_jensen2@hotmail.com with what kind of setup you'd need, like resources, ports, what kind of access etc and I can see if there's room for another VPS :)

pchote commented

See also https://github.com/mindriot101/openra-analysis, which gives a starting point for data we can export to json and display on http://www.openra.net/players/.

kingo55 commented