[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

From: Steve Kemp
Subject: Re: [Gnump3d-users] Test the pre-release?
Date: Sun, 3 Sep 2006 21:18:18 +0100
User-agent: Mutt/1.5.9i

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.


reply via email to

[Prev in Thread] Current Thread [Next in Thread]