Thread: [Pypentago-devel] Questions about db structure
Status: Pre-Alpha
Brought to you by:
segfaulthunter
Menu
▾
▴
pypentago-devel
|
From: Hardik M. <har...@gm...> - 2008-05-30 21:19:30
|
Hi J. Kovacs, While implementing the database bindings, I had some questions about the design document. 1. What is the pgn_string field in GameHistory for if it is not the player_name of the winner 2. If the above field is not the player_id of the winner, Shouldn't it be there in the game history somewhere ? 3. I added real_name to the Player structure instead of adding firstname and lastname 4. Are we not going to need an Email id for the registrationi process ? If yes, should I add it ? regards, Hardik |
|
From: J. K. <ko...@fr...> - 2008-05-30 22:33:14
|
> 1. What is the pgn_string field in GameHistory for if it is not the > player_name of the winner I would like to store all the moves of the game in string format in that field. The field would use the PGN (portable game notation) that we agreed upon a ways back in the mailing list, which I think was: For example, a chess game can be represented in PGN format: such as: 1. e4 c5 2. Nf3 d6 3. Bb5+ Bd7 ......... [potentially long string, but for us it will be much shorter!] So, for a pypentago PGN, once the game is over, we might have a full string 1. a1,al b1,ar 2. b1,dl d2,dr ........ That is what I intended the gamehistory.pgn_string field for. > 2. If the above field is not the player_id of the winner, Shouldn't it be > there in the game history somewhere ? Good question. I was going to assume that the winner of the game was always p1. But I think I like your direction better. A new field for "winner_id" or something? > 3. I added real_name to the Player structure instead of adding firstname Sounds good! > 4. Are we not going to need an Email id for the registration process ? If > yes, should I add it ? Yes, yes! (We have not actually discussed this, but maybe we just all assumed email address would be in there.) In fact, maybe we should look at another open source DB structure and make sure we aren't forgetting other fields needed in the Players table. A "player_avatar" image blob also sounds potentially useful... Thanks, Kovacs |
|
From: Hardik M. <har...@gm...> - 2008-06-01 21:07:44
|
> > Good question. > I was going to assume that the winner of the game was always p1. > But I think I like your direction better. A new field for "winner_id" or > something? Hi the idea of p1_id being the winner_id is good, saves a field but what about the condition when it is a draw ? So I added the winner_id in a way that it will be p1_id or p2_id or None(empty) in case of a draw. I think you will agree with this. Now I have some other questions about the GameHistory table. I think that the rating, RD and volatility of both the players you store in GameHistory table are the values at the time of creation of the GameHistory e.g. when they were playing the game. They will not change with the player's current rating, RD and volatility. Am I right ? And yes, there will be Foreign keys p1_id and p2_id and also the winner_id. > > > > > 3. I added real_name to the Player structure instead of adding firstname > > Sounds good! > > > > > 4. Are we not going to need an Email id for the registration process ? If > > yes, should I add it ? > > Yes, yes! > > > (We have not actually discussed this, but maybe we just all assumed email > address would be in there.) > > In fact, maybe we should look at another open source DB structure and make > sure we aren't forgetting other fields needed in the Players table. > > A "player_avatar" image blob also sounds potentially useful... > > Thanks, > > Kovacs > > > > > > > > > > > > > > > |
|
From: Florian M. <flo...@ai...> - 2008-06-02 11:21:04
|
Hardik Mehta wrote: >> Good question. >> I was going to assume that the winner of the game was always p1. >> But I think I like your direction better. A new field for "winner_id" or >> something? > > > Hi the idea of p1_id being the winner_id is good, saves a field but what > about the condition when it is a draw ? > > So I added the winner_id in a way that it will be p1_id or p2_id or > None(empty) in case of a draw. I think you will agree with this. > > Now I have some other questions about the GameHistory table. > > I think that the rating, RD and volatility of both the players you store in > GameHistory table are the values at the time of creation of the GameHistory > e.g. when they were playing the game. They will not change with the player's > current rating, RD and volatility. > > Am I right ? > > And yes, there will be Foreign keys p1_id and p2_id and also the winner_id. > > > > > > > >> >> >>> 3. I added real_name to the Player structure instead of adding firstname >> Sounds good! >> >> >> >>> 4. Are we not going to need an Email id for the registration process ? If >>> yes, should I add it ? >> Yes, yes! >> >> >> (We have not actually discussed this, but maybe we just all assumed email >> address would be in there.) >> >> In fact, maybe we should look at another open source DB structure and make >> sure we aren't forgetting other fields needed in the Players table. >> >> A "player_avatar" image blob also sounds potentially useful... >> >> Thanks, >> >> Kovacs >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> > > > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > > > ------------------------------------------------------------------------ > > _______________________________________________ > Pypentago-devel mailing list > Pyp...@li... > https://lists.sourceforge.net/lists/listinfo/pypentago-devel Please keep all the discussion to the *Sorceforge* mailing list. And please keep the discussion *to* the mailing list, not fork them into private responses, if not necessary. As soon as I get response from Gna! on why I can't send to the mailing list and I fix it, we'll reactivate the Gna! one, until then I will disable it to avoid confusion. Florian Mayer |
|
From: Hardik M. <har...@gm...> - 2008-06-02 11:55:10
|
Hi Please keep all the discussion to the *Sorceforge* mailing list. And > please keep the discussion *to* the mailing list, not fork them into > rivate responses, if not necessary. where do you see here private discussion ? Did I ask anybody for a date or something ? > > As soon as I get response from Gna! on why I can't send to the mailing > list and I fix it, we'll reactivate the Gna! one, until then I will > disable it to avoid confusion. Disable the list, as I see both the list are working for me. I post to both the list to make sure everybody gets it. I am not sure who is reading which list.. regards, Hardik > > Florian Mayer > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Pypentago-devel mailing list > Pyp...@li... > https://lists.sourceforge.net/lists/listinfo/pypentago-devel > |
|
From: J. K. <ko...@fr...> - 2008-06-02 17:05:14
|
> So I added the winner_id in a way that it will be p1_id or p2_id or > None(empty) in case of a draw. I think you will agree with this. Yes, good idea! > Now I have some other questions about the GameHistory table. > > I think that the rating, RD and volatility of both the players you store > in > GameHistory table are the values at the time of creation of the > GameHistory > e.g. when they were playing the game. They will not change with the > player's > current rating, RD and volatility. > > Am I right ? You are correct. |
|
From: Florian M. <flo...@ai...> - 2008-06-02 12:00:35
|
Hardik Mehta wrote: > > Hi > > > > Please keep all the discussion to the *Sorceforge* mailing list. And >> >> please keep the discussion *to* the mailing list, not fork them into >> >> rivate responses, if not necessary. > > > > > > where do you see here private discussion ? Did I ask anybody for a date or > > something ? I meant Kovacs not responding to the list but rather directly to you, that's what I meant. It's frustrating seeing you quoting Kovacs, while not seeing his mail. Sorry if I did not make clear what I meant. Florian Mayer PS: Argh I am a jerk, now I did the same thing. Sorry :) |
|
From: Hardik M. <har...@gm...> - 2008-06-02 12:02:10
|
> > I meant Kovacs not responding to the list but rather directly to you, > that's what I meant. It's frustrating seeing you quoting Kovacs, while > not seeing his mail. > Sorry if I did not make clear what I meant. This is because we don't have the reply-to property set for the list. Naturally somebody replies and the reply goes to sender and not the list. No offenses I was just surprised to see that how a discussion about db design can be private On Mon, Jun 2, 2008 at 3:59 PM, Florian Mayer <flo...@ai...> wrote: > Hardik Mehta wrote: > > > Hi > > > > > > Please keep all the discussion to the *Sorceforge* mailing list. And > >> >> please keep the discussion *to* the mailing list, not fork them into > >> >> rivate responses, if not necessary. > > > > > > > > > where do you see here private discussion ? Did I ask anybody for a > date or > > > something ? > I meant Kovacs not responding to the list but rather directly to you, > that's what I meant. It's frustrating seeing you quoting Kovacs, while > not seeing his mail. > Sorry if I did not make clear what I meant. > > Florian Mayer > > PS: Argh I am a jerk, now I did the same thing. Sorry :) > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Pypentago-devel mailing list > Pyp...@li... > https://lists.sourceforge.net/lists/listinfo/pypentago-devel > |
Thanks for helping keep SourceForge clean.
X