Wander, you're right. I thought about that too, but then i stared thinking about the query's i would like to do. and the speed of them, the number of joins/subjoins would be verry high.
The is no solid implementation yet, so any comments are welcome I missed much of the discussion too. Martijn. On 5/25/05, Wander Winkelhorst <[EMAIL PROTECTED]> wrote: > On 5/24/05, Martijn Voncken <[EMAIL PROTECTED]> wrote: > > > > Hi, > > Hi > > > -changing sql-schema's is hard!, i use lots of exotic mp3 tags: > > (replaygain*4,album_artist,date_add,last_played,first_played etc..) > > every user/media will have different needs. > > Well, you don't have to have a different schema for every tag you add, > you can set up a very generic set of tables that give you a lot of > flexibility. Something like this: > > A table called "files" with a filename and an ID > A table called "tag_types" with a tag name and an ID > A table "filetags" with a file ID, a tag ID and a description > > These three tables will allow you to store any tag for any file, > without changing the SQL schema. > > I'm not saying that you should change your code, if your code works, > then keep it that way. > > Cheers, > Wander. > > > PS. Didn't read any of your code, don't know the disscussion that went > on before this, so I might be talking out of my ass here, please > forgive me if I do. > > > ------------------------------------------------------- > This SF.Net email is sponsored by Yahoo. > Introducing Yahoo! Search Developer Network - Create apps using Yahoo! > Search APIs Find out how you can build Yahoo! directly into your own > Applications - visit http://developer.yahoo.net/?froffad-ysdn-ostg-q22005 > _______________________________________________ > Freevo-devel mailing list > Freevo-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/freevo-devel > ------------------------------------------------------- This SF.Net email is sponsored by Yahoo. Introducing Yahoo! Search Developer Network - Create apps using Yahoo! Search APIs Find out how you can build Yahoo! directly into your own Applications - visit http://developer.yahoo.net/?fr=offad-ysdn-ostg-q22005 _______________________________________________ Freevo-devel mailing list Freevo-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/freevo-devel
