> And having primary keys is kinda important in database design, at least from
> a theorical point of view.
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 mentioning primary keys and normalisation in order to not put people off
from helping me. However, if people are comfortable with database terminology I
am more than happy to use it.
I'm not a professional programmer but I can program modestly in C++, C, Tcl,
perl, bash, ksh, T-SQL (obviously) and a few others. Recently I've taken some
time to work through the code that manipulates the scid files and several of
these "theoretical" database questions crop up. I've not wanted to fill up the
email list with these because the file structure seems quite stable and most
efforts seem to be in the area of functionality and user interface. Are people
open to the idea of suggestions regarding the file structure or is it something
to be avoided ? Are people happy if I investigate this area and ask questions ?
Steve W
________________________________
From: Ben St-Pierre <benbon...@gmail.com>
To: stephen williamson <stephen_g_william...@yahoo.co.uk>
Cc: Scid Users List <scid-users@lists.sourceforge.net>
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 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 files and use
> the unique game number just as a reference field in the display or for
> exporting games then I would have thought that speed would not be such an
> issue.
I agree with this idea. Since the game ids change when compacting or
sorting (!) the games, I fail to see how they could be considered
primary keys. And having primary keys is kinda important in database
design, at least from a theorical point of view.
And from a practical point of view, this seems to be what prevents
Scid from implementing a linking mechanism inside annotations. We
should be able to link from one game to another in the same database.
More on that another time, perhaps.
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
_______________________________________________
Scid-users mailing list
Scid-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/scid-users
