[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Bug-gnubg] Relational database
From: |
Christian Anthon |
Subject: |
Re: [Bug-gnubg] Relational database |
Date: |
Mon, 11 Feb 2008 22:14:07 +0100 |
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
>
>