I will have a look at the ui_branch and the message archives.
The extra AlbumArtist attribute was so that you could identify the compilations, even though they may have the same name. I actually have a few dupe album names, which hasn't got the same tracks on them... I know it is rare, but still, it happens. And another thing you could "control" is if an ablum had a guest artist on it, say if on U2's next album, they for some reason had a track done by Depeche Mode... This is typically for some albums... But I haven't even seen your proposal yet, so maybe your idea is a better solution, I will have a look one of these next days... As for the Jukebox, it can actually holds 480 CD's, I have a smaler one that holds 150 CD's and 4 drives. I have been working as a storage technician for some years, working with Tape/CD/DVD Jukeboxes and large disk systems. The large jukebox is about $40.000 and the small one is about $20.000 from new ofcause. I got them for free, as they were demo units, and the company had to close down, so I was quick and lucky :-) http://www.plasmon.com Here you can see how it looks, it's called D480... The cost of about 360GB (480x700MB) is too high, I agree, you must also look at the cost of the media which is about $300 But I expect to upgrade the drives from CD-ROM to DVD-ROM or DVD-RAM as soon as the prices become lower... The problem is that the drives are specially tweaked from Plasmon, so I have to get them from there, and this adds about 100% on the cost off the street... But if only I added the smalest DVD discs with only 4GB per disc, things start to look allright (thats about 2TB)... I don't think I will ever fill it with that much MP3 ;- ) But who knows, maybe VCD's then ;-) /Heino > Have you looked at the code in the ui_branch ? You can check this out > of CVS, and have a look if you want, however the code is in a bit of a > state of limbo (and has been for some time I'm afraid). > > I had a go at adding compilation support to this branch. I think if you > look through the mailing list achive you will see my earlier messages > about it. > > I'm not sure that I understand what you propose below. The database > structure already has an 'Artist' field in the Album table and an > 'Artist' field in the 'Track' table, so you effectively already have a > TrackArtist and DiscArtist already. > > My approach was to scan the database for groups of Albums with the same > name and different artists, and then to merge them into one > 'metaartist' called 'Compilation' or something. > > There were quite a few changes required, and I think there are still a > few problems. Maybe we could collaborate a bit. > > btw how does the cost of a CD jukebox with 300 cd's like you > describe compare to a couple of large harddiscs? > > Rob > >> Artist table... >> >> A Compilation Album would then look something like this: >> >> Id Name Artist AlbumArtist >> 101 "Mix 1" 3 (Artist1) 1 (Various >> Artists) >> 102 "Mix 1" 4 (Artist2) 1 (Various >> Artists) >> etc... >> >> A normal Album would look like this: >> >> Id Name Artist >> AlbumArtist >> 201 "101" 10 (Depeche Mode) >> 10 (Depeche Mode) >> >> I realize that this will need some changes in the SQL scripts, and the >> displaying of the albums... >> >> I cannot see a problem with the SQL side of things, if agreed on this >> way to do it, I could go though the SQL scripting, and adjust it if >> you like ? >> >> Also it shouldn't be a biggie to write a quick Perl script to fill up >> the AlbumArtist attribute with either "Various Artist" or the Artist >> name... >> >> Tell me what you think about this solution... >> >> Regards, >> Heino Walther >> >> >> > > -- > 01010010 01101111 01100010 01100101 01110010 01110100 > 01001000 01100001 01110010 01110100 > > > > _______________________________________________ > Obs-dev mailing list > [EMAIL PROTECTED] > http://www.freeamp.org/mailman/listinfo/obs-dev _______________________________________________ Obs-dev mailing list [EMAIL PROTECTED] http://www.freeamp.org/mailman/listinfo/obs-dev
