Move/Results Database?

Use this forum to discuss Diplomacy strategy.
Forum rules
This forum is limited to topics relating to the game Diplomacy only. Other posts or topics will be relocated to the correct forum category or deleted. Please be respectful and follow our normal site rules at http://www.webdiplomacy.net/rules.php.
Post Reply
Message
Author
mhsmith0
Posts: 318
Joined: Wed Jan 03, 2018 12:35 am
Karma: 186
Contact:

Move/Results Database?

#1 Post by mhsmith0 » Fri Jan 05, 2018 9:18 pm

Is there a database somewhere of individual games and the detailed data from the games (moves, results, etc). that is available publicly for analysis and the like?

Octavious
Posts: 3844
Joined: Fri Sep 29, 2017 4:16 pm
Location: The Five Valleys, Gloucestershire
Karma: 2605
Contact:

Re: Move/Results Database?

#2 Post by Octavious » Fri Jan 05, 2018 9:33 pm

mhsmith0 wrote:
Fri Jan 05, 2018 9:18 pm
Is there a database somewhere of individual games and the detailed data from the games (moves, results, etc). that is available publicly for analysis and the like?
God, I hope not. No good would come of it.

Condescension
Posts: 79
Joined: Fri Sep 29, 2017 5:09 pm
Karma: 19
Contact:

Re: Move/Results Database?

#3 Post by Condescension » Sat Jan 06, 2018 9:53 pm

I tried for a while to get some data from the admin team to do some data science shit but it was a painful experience and I gave up.

A_Tin_Can
Lifetime Site Contributor
Posts: 283
Joined: Fri Sep 29, 2017 9:18 pm
Karma: 451
Contact:

Re: Move/Results Database?

#4 Post by A_Tin_Can » Tue Jan 09, 2018 10:22 am

You're the same guy who said "I'd contribute to the code, but you wouldn't accept the pull request", right?

A_Tin_Can
Lifetime Site Contributor
Posts: 283
Joined: Fri Sep 29, 2017 9:18 pm
Karma: 451
Contact:

Re: Move/Results Database?

#5 Post by A_Tin_Can » Tue Jan 09, 2018 10:40 am

Anyway, @mhsmith0 - not exactly, but also yes. It's possible to get a database dump of just the public information, but it's kind of annoying to generate (someone has to write a query that gives you a valid database without exposing private information like press or other user data).

If you're super interested and prepared to do a bit of leg work, you can see the database structure in the github repo - if you write a query that will pick up what you want without exposing private data. I'd be happy to run it for you. Unfortunately I don't have the time to put together the queries, otherwise.

Other options if you don't want to do that are to ask the current admin team (I don't work here, I just have database access in case anything catches fire), or to construct it based on the data you can see as a logged in user (but please be polite in any screen scraping you do).

I'm always interested in the results of anything done with the webdip data. I did some analysis a while back which is buried deep in the old forum somewhere.. I also did some generations of solo maps like these that I thought might be interesting, but they pretty much showed the same picture.
1

A_Tin_Can
Lifetime Site Contributor
Posts: 283
Joined: Fri Sep 29, 2017 9:18 pm
Karma: 451
Contact:

Re: Move/Results Database?

#6 Post by A_Tin_Can » Tue Jan 09, 2018 10:47 am

Oh, also, I made a docker harness that you might find useful if you want to see the database schema without running all those scripts yourself - you can find it here.

I haven't tried this, but you can probably do a docker run of

Code: Select all

mysql -u "webdiplomacy" --password="Admin2015"
to get straight into a DB console.

Condescension
Posts: 79
Joined: Fri Sep 29, 2017 5:09 pm
Karma: 19
Contact:

Re: Move/Results Database?

#7 Post by Condescension » Wed Jan 10, 2018 2:27 am

ATC if you would run queries I'd be delighted. I tried to get some form of database access from HR but it went nowhere.

eturnage
Bronze Donator
Bronze Donator
Posts: 60
Joined: Sun Dec 31, 2017 12:31 pm
Karma: 27
Contact:

Re: Move/Results Database?

#8 Post by eturnage » Thu Jan 11, 2018 12:01 pm

ATC, it is unlikely you will find much difference in the stats from here to whereever Josh Burton game stats came from. At some point, the sample size is going to even everything out. I sincerely doubt the platform would make much difference.

What would be interesting would be to find data only on games with experienced players involved. It would probably not be much different, but I am curious to see if there is any significant difference in outcomes.

mhsmith0
Posts: 318
Joined: Wed Jan 03, 2018 12:35 am
Karma: 186
Contact:

Re: Move/Results Database?

#9 Post by mhsmith0 » Thu Jan 11, 2018 5:40 pm

I actually suspect there would be substantial differences, particularly in gunboat. Austria becomes viable instead of toast, Turkey becomes harder to succeed at, etc.

bo_sox48
Site Admin
Site Admin
Posts: 3901
Joined: Thu Jun 08, 2017 1:01 am
Karma: 2785
Contact:

Re: Move/Results Database?

#10 Post by bo_sox48 » Fri Jan 12, 2018 5:59 pm

Condescension wrote:
Wed Jan 10, 2018 2:27 am
I tried to get some form of database access from HR but it went nowhere.
I went ahead and underlined the main source of all your problems.

Condescension
Posts: 79
Joined: Fri Sep 29, 2017 5:09 pm
Karma: 19
Contact:

Re: Move/Results Database?

#11 Post by Condescension » Fri Jan 12, 2018 7:48 pm

bo_sox48 wrote:
Fri Jan 12, 2018 5:59 pm
Condescension wrote:
Wed Jan 10, 2018 2:27 am
I tried to get some form of database access from HR but it went nowhere.
I went ahead and underlined the main source of all your problems.
Yeah, I didn't really know who's responsible for what. I could've done without all the leg pulling though.

A_Tin_Can
Lifetime Site Contributor
Posts: 283
Joined: Fri Sep 29, 2017 9:18 pm
Karma: 451
Contact:

Re: Move/Results Database?

#12 Post by A_Tin_Can » Sun Jan 14, 2018 1:13 am

It wouldn't be appropriate to give out database access - it's not designed to be given out, and the site has a reasonable responsibility to keep players private data well, private. Plus the only way to access the database is via shell access to the account that hosts the site.

The "only experienced players" thing is interesting, but I'm not sure how best to measure experienced players. GR is certainly not very predictive (I wrote a longer post on this on the old forum).

I do think that webdip play comes in fashions, especially among players who are very active. There was a time where france was doing well (and Italy poorly), because few italian players were going to Piedmont. I haven't hit on a good way to analyse that.

By far the most interesting analysis was looking for "natural allies" - countries that tend to both do well in pairs. The correlations were not strong, and then the results were not particularly surprising - for example, France and Austria tend to do well together (probably in games where italy has done poorly). Even then, the correlations weren't strong enough to make big conclusions about.

Post Reply

Who is online

Users browsing this forum: No registered users and 47 guests