Re: [Bug-gnubg] Relational database

[Christian Anthon]

Hi Jon,

when I try to add a match I get the following error

table session has no column named match_id

One thing I would like to be able to is a "how much do I win/loose at
specific score"

Christian.

On Feb 11, 2008 10:17 AM, Jonathan Kinsey <address@hidden> wrote:
> I've finished the first set of changes to the relational database player
> records.  I've moved the sql code from Python into the C code and the db
> settings from a settings file into gnubg options.  It's largely untried so
> doubtless there are some errors to be found.
>
> The next (more exciting) part is to write some queries to show the data.  I 
> like
> the idea of a "report gallery" which has a list of standard reports which can
> then be customised by the user.  Without thinking about how it might be done 
> (or
> when...), it would be good if people could suggest some ideas of things they'd
> like to see.
>
> Here's a few ideas from me:
>
>         * Display error rates over time
> Show a list of cheq/cube/overall error rates per match in time order and 
> include
> average at end.
>
>         * Error rates per match length
> Show a list of cheq/cube/overall error rates for each match length and include
> average at end.
>
>         * Score away "temperture map"
> show a 2d grid with each grid coloured based on the average error at that 
> score.
>
>         * List of opponents
> Matches played w/l record, avg errors and avg fibs ratings.
>
>
> Each report could have filters for player names, match scores, chequer/cube or
> both errors (and other things...).  So for example you might select "error 
> rates
> over time", one player = "Jon", match length >= 5, cube errors, post crawford.
>
> I'm not sure how to build up a kind of requirements list (lots of emails is
> likely to get confusing), I guess some kind of web wiki would be good, can we
> use the gnubg help section?
>
> Jon
>
>
> _______________________________________________
> Bug-gnubg mailing list
> address@hidden
> http://lists.gnu.org/mailman/listinfo/bug-gnubg
>
>