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

["Jason Short" <jdorje@xxxxxxxxxxxxxxxxxxxxx>]

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

Per I. Mathisen wrote:
> <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?

 From a GGZ point of view I think it would be much better to put the 
data straight into the DB.

-jason