#musicbrainz

/

      • yeeeargh
        so yeah, in the case of "crosby stills nash & young" the artist is a band which happens to have the same name as their members last names, so to say
      • 2014-10-10 28339, 2014

      • yeeeargh
        so you would have to do a artist lookup on musicbrainz to get a list of the members of this band
      • 2014-10-10 28309, 2014

      • yeeeargh
        i don't think that there is a way without the additional lookup on musicbrainz
      • 2014-10-10 28317, 2014

      • Freso
        "But my scans are dark and full of terrors"
      • 2014-10-10 28327, 2014

      • _Dave_
        ?
      • 2014-10-10 28343, 2014

      • Freso
        Or is it horrors?
      • 2014-10-10 28305, 2014

      • _Dave_
        no clue as to your memetic reference
      • 2014-10-10 28327, 2014

      • yeeeargh
        http://musicbrainz.org/ws/2/artist/46a782ea-4308-… there you get a list of the band members
      • 2014-10-10 28341, 2014

      • _Dave_
        here's another good example: Medeski Scofield Martin & Wood
      • 2014-10-10 28300, 2014

      • _Dave_
        I'd interpret this more as "Medeski Martin & Wood" + "Scofield"
      • 2014-10-10 28325, 2014

      • _Dave_
        ah yeah artist-rels
      • 2014-10-10 28329, 2014

      • VxJasonxV
        hmm
      • 2014-10-10 28344, 2014

      • VxJasonxV
        it would appear that murdos' bandcamp script is currently breaking the ability to buy anything from it
      • 2014-10-10 28311, 2014

      • CallerNo6
        hmm, could be "MMW" plus "Scofield". I mean, a case could be made for sure.
      • 2014-10-10 28325, 2014

      • CallerNo6
        Jazz is hard. The artists are often pretty promiscuous.
      • 2014-10-10 28340, 2014

      • _Dave_
        I can disambiguate a lot of that personally
      • 2014-10-10 28343, 2014

      • _Dave_
        but yeah
      • 2014-10-10 28355, 2014

      • _Dave_
        My use cases are a bit off from the norm
      • 2014-10-10 28332, 2014

      • yeeeargh
        from time to time those collaborations are a bit finicky because it's not so clear if it's should be considered a project/collaboration or a new band
      • 2014-10-10 28345, 2014

      • _Dave_
        Flora Purim & Airto Moreira is another hard one
      • 2014-10-10 28311, 2014

      • CallerNo6
        But if you're looking for an underlying logic, it's usually this: does the artist Foo&Bar have relationships that require that entity to exist? Like a webpage dedicated to Foo&Bar or something?
      • 2014-10-10 28342, 2014

      • _Dave_
        well, I favor decomposition, so I don't mind having two artist mbid where it's considered one because I will "and" any queries for both
      • 2014-10-10 28308, 2014

      • _Dave_
        I am looking for an underlying logic yes!
      • 2014-10-10 28310, 2014

      • _Dave_
        :D
      • 2014-10-10 28350, 2014

      • _Dave_
        that doesn't explain Prince & The New Power Generation though?
      • 2014-10-10 28321, 2014

      • yeeeargh
        some of those might be merged together out of historical reasons i think
      • 2014-10-10 28320, 2014

      • kepstin-laptop
        hysterical raisons.
      • 2014-10-10 28320, 2014

      • CallerNo6
        yeah, I'd split that one
      • 2014-10-10 28332, 2014

      • yeeeargh
        assigning multiple artists to a release/recording was probably not possible at first
      • 2014-10-10 28341, 2014

      • _Dave_
        How about Paul McCartney & Wings? :D
      • 2014-10-10 28306, 2014

      • kepstin-laptop
        yeeeargh: yeah, multiple artists was a feature of "ngs", the "next generation schema"
      • 2014-10-10 28324, 2014

      • kepstin-laptop
        released at the same time as the big site redesign, etc.
      • 2014-10-10 28325, 2014

      • _Dave_
        clearly it was added after the fact...hey my software dates back to 1998 and I am just adding that idea because of MB
      • 2014-10-10 28308, 2014

      • kepstin-laptop
        (if you ever feel like a blast from the past, the old musicbrainz db can still be seen at http://classic.musicbrainz.org/ )
      • 2014-10-10 28354, 2014

      • yeeeargh
        doesn't look that different *ducks*
      • 2014-10-10 28317, 2014

      • CallerNo6
        if it doesn't look different than a duck, and...
      • 2014-10-10 28348, 2014

      • yeeeargh
        cover?
      • 2014-10-10 28318, 2014

      • CallerNo6
        word
      • 2014-10-10 28342, 2014

      • _Dave_
        you guys are a quack up
      • 2014-10-10 28305, 2014

      • VxJasonxV
        ugh
      • 2014-10-10 28309, 2014

      • VxJasonxV
        differing artwork for the same release
      • 2014-10-10 28317, 2014

      • VxJasonxV
      • 2014-10-10 28320, 2014

      • CallerNo6
        it' all about choice, right?
      • 2014-10-10 28320, 2014

      • CallerNo6
        anyway, rather than worry about splitting or not splitting CSN-and-sometimes-Y or MMW+S, I'd like to have a better way to build an aritst's discography based on performance names, eponymous bands etc
      • 2014-10-10 28305, 2014

      • _Dave_
        I suggest looking at whether an artist has recorded anything on their own
      • 2014-10-10 28315, 2014

      • _Dave_
        if they have, then IMO they should be split
      • 2014-10-10 28328, 2014

      • kepstin-laptop
        .
      • 2014-10-10 28338, 2014

      • kepstin-laptop
        er, oops,
      • 2014-10-10 28347, 2014

      • kepstin-laptop has no idea how he typed a single .
      • 2014-10-10 28322, 2014

      • CallerNo6
        one character at a time, like the rest of us?
      • 2014-10-10 28341, 2014

      • CallerNo6
        akk. I'm worse than usual today.
      • 2014-10-10 28310, 2014

      • _Dave_
        Another issue is...given the Miles Davis Quintet ... how do we find out just the albums with John Coltrane on them?
      • 2014-10-10 28327, 2014

      • VxJasonxV
        Hey Mineo, got a question for you sorta re: an edit you made last year
      • 2014-10-10 28304, 2014

      • CallerNo6
        _Dave_: generally, you'd have to look at performance credits on the recordings.
      • 2014-10-10 28326, 2014

      • CallerNo6
        But in this case, wasn't Coltrane a stable member of the quintet? I can't remember.
      • 2014-10-10 28350, 2014

      • _Dave_
        either way
      • 2014-10-10 28305, 2014

      • _Dave_
        I'd like to find this information
      • 2014-10-10 28321, 2014

      • CallerNo6
        oh, oops. no, he was only in the first quintet.
      • 2014-10-10 28329, 2014

      • _Dave_
        it looks like I'm going to eventually have to make a postgres slave for MB
      • 2014-10-10 28352, 2014

      • _Dave_
        on FreeBSD
      • 2014-10-10 28304, 2014

      • _Dave_
        so I can really look at all this data without impacting your main servers
      • 2014-10-10 28342, 2014

      • CallerNo6
        Depending on what kind of queries you want to do, you could also check out https://github.com/redapple/sql2graph/tree/master…
      • 2014-10-10 28322, 2014

      • CallerNo6
        I haven't tried it, but presumably it's optimized for following relationships down paths.
      • 2014-10-10 28336, 2014

      • _Dave_
        argh!
      • 2014-10-10 28349, 2014

      • _Dave_
        I absolutely loathe large SQL queries like that...personal issue
      • 2014-10-10 28332, 2014

      • CallerNo6 goes back to work
      • 2014-10-10 28311, 2014

      • _Dave_
        thanks for the feedback
      • 2014-10-10 28357, 2014

      • spinza joined the channel
      • 2014-10-10 28338, 2014

      • chungy joined the channel
      • 2014-10-10 28350, 2014

      • Gentlecat joined the channel
      • 2014-10-10 28318, 2014

      • Nyanko-sensei joined the channel
      • 2014-10-10 28358, 2014

      • Nyanko-sensei joined the channel
      • 2014-10-10 28317, 2014

      • Nyanko-sensei joined the channel
      • 2014-10-10 28342, 2014

      • Nyanko-sensei joined the channel
      • 2014-10-10 28329, 2014

      • Nyanko-sensei joined the channel