Re: [GENERAL] Searchable chess positions in a Postgress DB

2012-04-12 Thread Michael Nolan
On Thu, Apr 12, 2012 at 4:50 PM, Gavin Flower wrote: > On 11/04/12 21:24, Gavin Flower wrote: > > On 11/04/12 19:15, Sidney Cadot wrote: > > Dear all, > > As a hobby project, I am toying around with a database containing > about 5 million chess games. On average, these games have about 80 > posi

Re: [GENERAL] Searchable chess positions in a Postgress DB

2012-04-12 Thread Gavin Flower
On 11/04/12 21:24, Gavin Flower wrote: On 11/04/12 19:15, Sidney Cadot wrote: Dear all, As a hobby project, I am toying around with a database containing about 5 million chess games. On average, these games have about 80 positions (~ 40 moves by both black and white), which means there are abou

Re: [GENERAL] Searchable chess positions in a Postgress DB

2012-04-12 Thread Merlin Moncure
2012/4/11 Ondrej Ivanič : > Hi, > > On 11 April 2012 17:15, Sidney Cadot wrote: >> I have written code to extract these positions, and now I want to put >> them into a Postgres database. Specifically, I want to do this in a >> way that allows *fast* lookups of positions, e.g. "give me all >> posit

Fwd: Re: [GENERAL] Searchable chess positions in a Postgress DB

2012-04-12 Thread Gavin Flower
Original Message Subject:Re: [GENERAL] Searchable chess positions in a Postgress DB Date: Fri, 13 Apr 2012 00:33:17 +1200 From: Gavin Flower Organisation: ArchiDevSys To: Sidney Cadot On 12/04/12 01:14, Sidney Cadot wrote: Hi Gavin, I appreciate the

Re: [GENERAL] Searchable chess positions in a Postgress DB

2012-04-11 Thread Cédric Villemain
Le mercredi 11 avril 2012 09:15:59, Sidney Cadot a écrit : > Dear all, > > As a hobby project, I am toying around with a database containing > about 5 million chess games. On average, these games have about 80 > positions (~ 40 moves by both black and white), which means there are > about 400 mill

Re: [GENERAL] Searchable chess positions in a Postgress DB

2012-04-11 Thread Gavin Flower
On 11/04/12 19:15, Sidney Cadot wrote: Dear all, As a hobby project, I am toying around with a database containing about 5 million chess games. On average, these games have about 80 positions (~ 40 moves by both black and white), which means there are about 400 million chess positions in there.

Re: [GENERAL] Searchable chess positions in a Postgress DB

2012-04-11 Thread Ondrej Ivanič
Hi, On 11 April 2012 17:15, Sidney Cadot wrote: > I have written code to extract these positions, and now I want to put > them into a Postgres database. Specifically, I want to do this in a > way that allows *fast* lookups of positions, e.g. "give me all > positions that have a White King on c4 a

Re: [GENERAL] Searchable chess positions in a Postgress DB

2012-04-11 Thread Bèrto ëd Sèra
> > Hi! > > As a hobby project, I am toying around with a database containing > about 5 million chess games. On average, these games have about 80 > positions (~ 40 moves by both black and white), which means there are > about 400 million chess positions in there. > What happens if you think of

Re: [GENERAL] Searchable chess positions in a Postgress DB

2012-04-11 Thread Gianni Ciolli
On Wed, Apr 11, 2012 at 09:15:59AM +0200, Sidney Cadot wrote: > Dear all, > > As a hobby project, I am toying around with a database containing > about 5 million chess games. On average, these games have about 80 > positions (~ 40 moves by both black and white), which means there are > about 400 m

Re: [GENERAL] Searchable chess positions in a Postgress DB

2012-04-11 Thread Alban Hertroys
On 11 April 2012 09:15, Sidney Cadot wrote: > Dear all, > > As a hobby project, I am toying around with a database containing > about 5 million chess games. On average, these games have about 80 > positions (~ 40 moves by both black and white), which means there are > about 400 million chess posit