Database Access

Game development with Board Game Arena Studio
Post Reply
User avatar
Phoxtrot
Posts: 493
Joined: 03 January 2012, 20:55

Database Access

Post by Phoxtrot »

Hello!

I was wondering if devs have read access the game plays database or if it was possible get such an access (for game dev or non-dev) ?
I would love to be able to run some statistics on some games and share the results.

For example, for Marco Polo II, i would:
* Check how many times each character is chosen (in 4 players games, without caravans and without "all characters")
* See how often players finish 1st, second,... with each character (in 4 players games, without caravans and without "all characters", with and without the black dice variants))
* See how often players finish 1st,second,... depending on the first visited city
* See how often the player with the most contracts finishes 1st, second,...
* ...

In short, produce statistics that are fun or give some insights as to what strategies might be best or how the game could be better balanced.

I sometimes do stats at work (I'm an analyst with a technical background) and I've done that kind of things for other games before (on other platforms).
I could do it by accessing lots of game through HTTP and parsing of the pages but that would require a lot more work and it would probably put an unwelcome load on the server even if I load only the minimum necessary.
User avatar
Tisaac
Posts: 2743
Joined: 26 August 2014, 21:28

Re: Database Access

Post by Tisaac »

Phoxtrot wrote: 04 January 2021, 12:41 Hello!

I was wondering if devs have read access the game plays database or if it was possible get such an access (for game dev or non-dev) ?
I would love to be able to run some statistics on some games and share the results.

For example, for Marco Polo II, i would:
* Check how many times each character is chosen (in 4 players games, without caravans and without "all characters")
* See how often players finish 1st, second,... with each character (in 4 players games, without caravans and without "all characters", with and without the black dice variants))
* See how often players finish 1st,second,... depending on the first visited city
* See how often the player with the most contracts finishes 1st, second,...
* ...

In short, produce statistics that are fun or give some insights as to what strategies might be best or how the game could be better balanced.

I sometimes do stats at work (I'm an analyst with a technical background) and I've done that kind of things for other games before (on other platforms).
I could do it by accessing lots of game through HTTP and parsing of the pages but that would require a lot more work and it would probably put an unwelcome load on the server even if I load only the minimum necessary.
No, the devs don't have access to database from the main site, only the ones on the studio. Even if they would, AFAIK the database is automatically destroyed a few days after (except if a bug report is linked to the table) and only the statistics from the game are kept, otherwise I would guess the amount of data would be tremendeous.
User avatar
paramesis
Posts: 398
Joined: 28 April 2020, 05:00

Re: Database Access

Post by paramesis »

With a few exceptions, there is enough information preserved to play almost every game (initial state + all notifications). I was able to replay my very first game on BGA from 8 months ago just now.

There is a way to get raw JSON data of the notification log and do some analysis with regex for all the examples you've described, but the problem is, as Tisaac mentions, that these notification logs can be quite large depending on the game. A statistically significant number of logs could easily be several gigabytes, and attempting to extract too many logs in a short time will cause you to hit a replay limit, and you'll be unable to view any replays for several days. This is what happened when I attempted to analyze turn order advantage in Kingdom Builder.

There are a few other threads that have the same question. AFAIK, the latest response from administrators is here:
https://boardgamearena.com/forum/viewto ... 12&t=18565
Post Reply

Return to “Developers”