Jump to content

rockefeller center

Members
  • Posts

    2,112
  • Joined

  • Last visited

  • Donations

    0.00 USD 

Everything posted by rockefeller center

  1. I knew it, you are James Bond. You're my hero.
  2. I'd have a many to many relationship between instrument/musician and track (an album consists of tracks, of course; didn't want to go into such detail because your "problem" seemed to be the boxed set - album relationship). Wouldn't make sense otherwise (database normalization) because it would be a hassle to even do simple queries like (pseudocode follows) SELECT track, artist.first_name, artist.last_name FROM [tables and join bla bla] WHERE instrument = 'kbd'. Is this a test? Yes - I agree it would be a hassle - and not really produce much of an interesting result. That's why I went for putting all instruments in one field. When I get it finished, if ever, I'll be able to pick out all albums with a trombonist on them, or a named trombonist, and that'll do me. Actually I meant the opposite. If I'd care to design a database for my music collection (I don't because I'm too lazy to enter data) I would not put all instruments in one field but have a record for each instrument a musician plays on a track. If significant performance backdraws aren't to be expected I go for higher granularity. One never knows what kind of queries Rooster Ties comes up with (like "on how many different instruments do you have artist x on your records where the instrument is not a piano?").
  3. I'd have a many to many relationship between instrument/musician and track (an album consists of tracks, of course; didn't want to go into such detail because your "problem" seemed to be the boxed set - album relationship). Wouldn't make sense otherwise (database normalization) because it would be a hassle to even do simple queries like (pseudocode follows) SELECT track, artist.first_name, artist.last_name FROM [tables and join bla bla] WHERE instrument = 'kbd'. Is this a test?
  4. Can't do diagrams on the PC, but that's more or less what I've got, except that album to artist is a many to many relationship, not a many to one; eg "ESPM the reunion: Live at Akhbar Hall" is by Charles Earland, Mel Sparks, Houston Person & Idris Muhammad. And I have loads of multiple artist albums (I expect we all do). MG Album : boxed set is n : m, so I corrected that in my diagram. I would use the "band/artist" entity just to have a name under which an album was released (there are probably better names to describe this entity). I'd have another m:n relationship between album and artist (and the instruments a musician plays on a given album). [band/artist]-1-------------<compiles>-------------m-[album]-m-----------------<has>-------------------n-[artist/musician] I'm still suffering from heavy new year's eve alcohol abuse so my thinking should still be flawed. Wonder if the that leap year bug in Microsoft's Zune player is alcohol related http://blog.tiensivu.com/aaron/archives/17...-one-error.html
  5. DVD-RW is rewritable, too. Still have a couple of hundred VHS cassettes (the media was never really cheap, IMO) with music footage - guess I'll convert some of them to x264 files before the video/audio signal vanishes; gotta love VHS chroma noise.
  6. Cute avatar, aloc.
  7. Brooker Ken Read Conradin Cathomen
  8. You're typing this on the Wal-Mart of operating systems, no?
  9. Google Chrome: Kill-ID gets rid of the google chrome calling-home bullshit http://www.almisoft.de/?cont=kchrome Then there's Chromium: http://code.google.com/chromium/ Lots of stuff to choose from. I'm happy with the versatile Firefox and Konqueror.
  10. Two more: exploit, forfait. Swiss German rulez. + and of course "gooooool!!!!", not "tooooor!" :-) FC Zürich boo!
  11. Two more: exploit, forfait. Swiss German rulez. +
  12. Moron teacher confiscates pupil's Linux discs: http://linuxlock.blogspot.com/2008/12/linu...-kids-back.html Aaaah, how I love authorities like this one...
  13. Breakfast = cold dinner
  14. Ingrid Pastorius on Milkowski's book: http://jacop.net/book.html http://jacop.net/book2.html
  15. Vocal processor But who cares. At least she knows how to get out of a car.
  16. Sad stuff. And since this is an electronica forum: the background music is "Boards of Canada", "Telephasic Workshop".
  17. ChucK (at 13:00 there's some sort of a ChucK "hello world!" equivalent) ChucK is free open source and available for Linux, MacOS X and Windows. http://chuck.cs.princeton.edu/
  18. http://en.wikipedia.org/wiki/Twinkle_Twinkle_Little_Star
×
×
  • Create New...