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/?fr=offad-ysdn-ostg-q22005 _______________________________________________ Freevo-devel mailing list Freevo-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/freevo-devel