Giter VIP home page Giter VIP logo

stk-stats's People

Contributors

arthur-d avatar edwardbetts avatar hiker avatar stephenjust avatar vampy avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

stk-stats's Issues

Add a stk-version information

Not only would we need the version number, but if possible also the 'source': e.g. self compiled, our binary, Ubuntu, ... not sure how to enforce this though :(

We would require at cmake time to add a specific -D (but then we need this for any user as well :( ). Perhaps only enforce this in our src package (assuming that all packager just pick up the src package, and not a certain revision from our repo). Or is there an api/etc-something-file we could use to find which distribution was being used? For Suse we can look at /etc/SuSE-release (for older Suse), and /etc/os-release:

NAME=openSUSE
VERSION="13.1 (Bottle)"
VERSION_ID="13.1"
PRETTY_NAME="openSUSE 13.1 (Bottle) (x86_64)"
ID=opensuse
ANSI_COLOR="0;32"
CPE_NAME="cpe:/o:opensuse:opensuse:13.1"
BUG_REPORT_URL="https://bugs.opensuse.org"
HOME_URL="https://opensuse.org/"
ID_LIKE="suse"

Similarly information about windows and osx version.

It's easy enough to add this on the STK side (once we figure out how to get it ;) ), I have just no idea about the server side.

Statistics mostly empty

The user count and OS data appears to be fine, but all other tables either show only one or no entry.

Performance improvement. Process raw JSON data incrementally.

Currently every time the maint_graphics.py generates the report data, it removes all the old data and starts to process all the new data from scratch.
This is quite inefficient as it takes quite a lot of CPU power and memory (especially on low ram machines, cough digitalocean VPS).

A better solution would be:

  1. Every time we run the generation script we will keep track of the last ID in the userreport table that was affected.
  2. Every time the generation script is run it will only process data from the previous remembered ID to the current latest ID.
  3. Handle user count for each device by looking up in the table to see if the device is already there https://github.com/supertuxkart/stk-stats/blob/master/userreport%2Fmaint.py#L48.
    Maybe another column which has the SHA1 sum of all the columns that identifies the device, so that we do not have to add non-clustered keys on all columns in the graphicsdevice table.
    But I am not sure which is faster, one column SHA1 sum (non-clustered key) OR all columns non-clustered keys (that uniquely identify a entry device).

Reset data version to 1.

As this code is forked from 0 A.D. it has some custom data version logic specific to it.
I think it will be better to reset all data versions checking in the code to 1. We can add our own specific data version checking later, if we change what kind of data is sent in different versions of STK.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.