[Freeciv-Dev] (PR#13633) New gamelog format

["Per I. Mathisen" <per@xxxxxxxxxxx>]

<URL: http://bugs.freeciv.org/Ticket/Display.html?id=13633 >

I and Mike had a discussion on irc about the future of the pubserver, and
one thing we touched upon was the gamelog. We agreed that the change to
xml had been a failure, and probably a waste of code. We did not agree
where to go from there. Mike wanted to go back to a simple flat file
gamelog. I want to drop the gamelog (and perhaps also the scorelog), and
instead just insert the data directly into the mysql db from the server.

The benefits of doing it my way:
 - you can easily insert the data into a mysql db on another machine,
which can be on the other side of the world; this allows a distributed
setup of pubservers with one central authserver which does authentication
and post-processing of game results
 - it avoids one level of interpretation and parsing (scripts that read
the gamelog and insert the results into the db); we still need a script to
massage the data in the db to conform to the ranking mechanism (ELO), but
this script can be much shorter and only needs to run on the authserver

The downside:
 - gamelog may have other users? (doubtful.)
 - I hear that sql in C is not pretty
 - some things I (conveniently) forgot

What is the opinion of everyone else on this?

  - Per