OpenChess

Saw this at rybkaforum.net

r1b1k2r/pp1p1ppp/2n1p3/qN2P3/5P2/2bBB3/P1P2KPP/R2Q3R b kq -

Decided to let Stockfish take a long look, using MultiPV=3:

I had the castle move as best, but I had only analyzed to 37 plies.
r1b1k2r/pp1p1ppp/2n1p3/qN2P3/5P2/2bBB3/P1P2KPP/R2Q3R b kq - acd 37; acs 795; bm O-O; ce 16; pm O-O; pv O-O Bxh7+ Kxh7 Qd3+ Kg8 Nxc3 b6 Bd2 Ba6 Qxd7 Rfd8;

User923005 wrote:I had the castle move as best, but I had only analyzed to 37 plies.
r1b1k2r/pp1p1ppp/2n1p3/qN2P3/5P2/2bBB3/P1P2KPP/R2Q3R b kq - acd 37; acs 795; bm O-O; ce 16; pm O-O; pv O-O Bxh7+ Kxh7 Qd3+ Kg8 Nxc3 b6 Bd2 Ba6 Qxd7 Rfd8;

Hi user923005

How do you edit/read and hold the database of EPD with spreadsheet? I ask the question because I know you hold a large database EPD. But mostly because I did not find available tool for this. Currently I'm trying EPD with libreoffice calc.

My database is in SQL Server format.
I can easily change it to any other database, but I have dozens of stored procedures that would not port so easily as the structures and data.

For instance, this is the table Epd:


USE [Chess]
GO

/****** Object: Table [dbo].[Epd] Script Date: 2/19/2014 6:10:58 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Epd](
[Epd] [varchar](255) NOT NULL,
[acd] [smallint] NULL,
[acn] [int] NULL,
[ce] [smallint] NULL,
[pv] [varchar](255) NULL,
[am] [varchar](255) NULL,
[dm] [smallint] NULL,
[id] [varchar](255) NULL,
[CheckoutCount] [smallint] NULL,
[c0] [varchar](255) NULL,
[c1] [varchar](255) NULL,
[c2] [varchar](255) NULL,
[c3] [varchar](255) NULL,
[c4] [varchar](255) NULL,
[acs] [int] NULL,
[EpdID] [uniqueidentifier] NOT NULL,
[tag] [char](10) NULL,
[white_wins] [int] NULL,
[black_wins] [int] NULL,
[draws] [int] NULL,
[coef] [float] NULL,
[bm] [varchar](1000) NULL,
[pm] [varchar](1000) NULL,
[Opening] [varchar](400) NULL,
[games] AS (([white_wins]+[black_wins])+[draws]),
CONSTRAINT [PK_Epd_1] PRIMARY KEY CLUSTERED
(
[EpdID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[Epd] ADD CONSTRAINT [DF_Epd_EpdID] DEFAULT (newid()) FOR [EpdID]
GO

ALTER TABLE [dbo].[Epd] ADD CONSTRAINT [DF_Epd_white_wins] DEFAULT ((0)) FOR [white_wins]
GO

ALTER TABLE [dbo].[Epd] ADD CONSTRAINT [DF_Epd_black_wins] DEFAULT ((0)) FOR [black_wins]
GO

ALTER TABLE [dbo].[Epd] ADD CONSTRAINT [DF_Epd_draws] DEFAULT ((0)) FOR [draws]
GO

ChessDrone wrote:

User923005 wrote:I had the castle move as best, but I had only analyzed to 37 plies.
r1b1k2r/pp1p1ppp/2n1p3/qN2P3/5P2/2bBB3/P1P2KPP/R2Q3R b kq - acd 37; acs 795; bm O-O; ce 16; pm O-O; pv O-O Bxh7+ Kxh7 Qd3+ Kg8 Nxc3 b6 Bd2 Ba6 Qxd7 Rfd8;

Hi user923005

How do you edit/read and hold the database of EPD with spreadsheet? I ask the question because I know you hold a large database EPD. But mostly because I did not find available tool for this. Currently I'm trying EPD with libreoffice calc.

I recommend against spreadsheet format, because it is slow and limited. Many spreadsheets will only hold 64000 rows and besides, you cannot index the spreadsheet columns.

PostgreSQL is a nice format. I can send you PostgreSQL schema for my database if you like.

Thanks for the offer , but I fear not know how use it. I was more referring to a tool all in one as for PGN files.

From here:
http://www.7sun.com/chess/
there is a tool called pgn2fen by Tim Foden.

It does a real nice job of turning PGN files into Epd records.
I often use it like this:
pgn2fen file.epd -e -l
which will turn a PGN file called file.epd into EPD records (the -e flag) and also includes the last move (-l for leaf nodes).

Rémi Coulom has a similar utility at his chess site that even comes with source code.

I usually use some sort of stream editor to pull off the full move number and the half move clock value. I trust the chess engines to track that since the basic concepts of the position are mostly independent of those two values when using many tools.

PGN-Extract by Barnes is extremely useful.

Norm Pollock has a mighty army of PGN tools.

Thank you for the useful information :)