Computer Chess Club Archives


Search

Terms

Messages

Subject: Re: SQL For an opening book... Request for feedback

Author: Dann Corbit

Date: 02:27:46 02/11/03

Go up one level in this thread


On February 11, 2003 at 04:28:09, Angrim wrote:

>  This format certainly provides a lot of data.  Much of this data is
>unlikely to be useful for a specific program, but having all of it
>means that multiple programs which use different criteria for picking
>book moves could share a book db.
>  I have some doubts about the usefulness of storing an expected move,
>since the first move out of book is a surprise move almost by definition.
>If you know what they will play, and the current position is at
>all common, you should already have the counter to their next
>move in book.

If you have analyzed it with a chess program, you will probably have both the pm
and the follow-on (as long as your pv is at least two plies in length).

>  Not being an SQL expert, I do have one other concern.  Can an SQL field
>of type "char" store all values from 0 to 255?  That ability is needed
>if you are storing a 64 bit hash into an 8 char field.

Yes.  Some database systems allow 64 bit integers, but some do not.  That's why
I chose char(8).



This page took 0 seconds to execute

Last modified: Thu, 15 Apr 21 08:11:13 -0700

Current Computer Chess Club Forums at Talkchess. This site by Sean Mintz.