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 -- _______________________________________________ Gnump3d-users mailing list [email protected] http://lists.gnu.org/mailman/listinfo/gnump3d-users
