Re: [Scid-users] Referencing a game in a scid database

2013-03-19 Thread John
On 23/02/13 22:20, stephen williamson wrote: > Thanks for your reply, Ben. I'm a database professional both on the > theoretical side (data modelling and architecture) and on the > implementation side (design, administration and performance on Sybase > and MS-SQL). I deliberately tried to avoid men

Re: [Scid-users] Referencing a game in a scid database

2013-02-23 Thread stephen williamson
his area and ask questions ? Steve W From: Ben St-Pierre To: stephen williamson Cc: Scid Users List Sent: Friday, 22 February 2013, 21:09 Subject: Re: [Scid-users] Referencing a game in a scid database > With regard to the specific scid unique game id I was thinking

Re: [Scid-users] Referencing a game in a scid database

2013-02-22 Thread Ben St-Pierre
> With regard to the specific scid unique game id I was thinking more of a > unique game id within the context of a scid database rather than a global id. > With that in mind, if you continue to use the game number (the relative > position in the index file) for linking between the database file

Re: [Scid-users] Referencing a game in a scid database

2013-02-19 Thread stephen williamson
ister Cc: Scid Users List Sent: Monday, 18 February 2013, 22:52 Subject: Re: [Scid-users] Referencing a game in a scid database > I suppose an internal scid unique number is out of the question because of > database merges etc. ? As I recall it, the issues were size and speed, coupled w

Re: [Scid-users] Referencing a game in a scid database

2013-02-18 Thread Ben St-Pierre
> I suppose an internal scid unique number is out of the question because of > database merges etc. ? As I recall it, the issues were size and speed, coupled with the need to create an online repository that could act as the equivalent of a DOI or ISBN for chess games, at least for Scid's sake.

Re: [Scid-users] Referencing a game in a scid database

2013-02-18 Thread Chris Bannister
On Mon, Feb 18, 2013 at 04:39:14PM -0500, Ben St-Pierre wrote: > > Any other ideas welcome. I suppose an internal scid unique number is out of the question because of database merges etc. ? -- "If you're not careful, the newspapers will have you hating the people who are being oppressed, and lo

Re: [Scid-users] Referencing a game in a scid database

2013-02-18 Thread stephen williamson
ay, thanks again. I will certainly look into what you've suggested to see if it will help. Regards, Steve W From: Ben St-Pierre To: Steve A Cc: stephen williamson ; Scid Users List Sent: Monday, 18 February 2013, 18:39 Subject: Re: [Scid-users] Referenc

Re: [Scid-users] Referencing a game in a scid database

2013-02-18 Thread Ben St-Pierre
Hello, > I was wondering if there was a simple way to uniquely reference a game in a > scid database which doesn't break after compacting ? The short answer is no: Scid does not provide rigid identificators. > When I export a set of games for use in another application I would like to > keep a

Re: [Scid-users] Referencing a game in a scid database

2013-02-18 Thread Steve A
I'm thinking using bookmarks is the best alternative. They seem to persist across base compaction, though there are probably cases where they don't. "If the database is sorted or compacted, the bookmark details may become out of date. In this case, Scid will search the database for the best matchi

[Scid-users] Referencing a game in a scid database

2013-02-18 Thread stephen williamson
Hi, I was wondering if there was a simple way to uniquely reference a game in a scid database which doesn't break after compacting ? When I export a set of games for use in another application I would like to keep a note of the games that I have exported so that if I need to regenerate the list