Re: [Gnump3d-users] Test the pre-release?

[Steve Kemp]

On Sun, Sep 03, 2006 at 02:49:17PM +0100, Steve Kemp wrote:

> > Your schema, while ultimately more flexible, is IMO overly complicated 
> > for what gnump3d needs.  I'd prefer to keep the DB as flat as possible, 
> > keeping with the "it's a web view of a directory of music" paradigm we 
> > work with already.  The primary key should be the path+music file.
> 
>   I guess there are pros and cons to both approaches.  In your scheme
>  it is hard to extend when new attributes are added, whereas with mine
>  the queries get more complex.

  Hmmm one big problem I've just spotted is that without having a 
 seperate table it is hard to determine a list of the directories which
 are available.

  .eg. finding the subdirectories of "/" is not possible.

Steve
--