#musicbrainz

/

      • JonnyJD joined the channel
      • 2014-01-21 02114, 2014

      • HibiscusKazeneko joined the channel
      • 2014-01-21 02141, 2014

      • HibiscusKazeneko
        watching last week's episode of Rachael vs Guy
      • 2014-01-21 02133, 2014

      • Nyanko-sensei joined the channel
      • 2014-01-21 02109, 2014

      • SultS
        is Brilliantbox (German) the same as Jewel Case?
      • 2014-01-21 02123, 2014

      • chirlu`
        Not exactly.
      • 2014-01-21 02137, 2014

      • SultS
        what’s the difference?
      • 2014-01-21 02124, 2014

      • Nyanko-sensei
        looks like digipak to me
      • 2014-01-21 02129, 2014

      • chirlu`
        I am searching for an image.
      • 2014-01-21 02106, 2014

      • Nyanko-sensei
      • 2014-01-21 02129, 2014

      • Nyanko-sensei
      • 2014-01-21 02141, 2014

      • SultS
        Oh, I see
      • 2014-01-21 02150, 2014

      • SultS
        I’ve used Jewel Case for those…
      • 2014-01-21 02138, 2014

      • rock joined the channel
      • 2014-01-21 02142, 2014

      • SultS
        never even knew they had a different name
      • 2014-01-21 02159, 2014

      • nikki
        I've always called them jewel cases too
      • 2014-01-21 02117, 2014

      • chirlu`
        I wouldn't call it a Digipak either.
      • 2014-01-21 02132, 2014

      • chirlu`
        (Only found the same link to additivmedia.com as Nyanko-sensei.)
      • 2014-01-21 02108, 2014

      • SultS
        it’s certainly closer to jewel case than to digipak
      • 2014-01-21 02114, 2014

      • Nyanko-sensei
      • 2014-01-21 02115, 2014

      • nikki
        yeah, that one isn't. a digipak to me is a cardboard thing with a plastic tray stuck to it
      • 2014-01-21 02127, 2014

      • SultS
        yeah
      • 2014-01-21 02152, 2014

      • nikki
        and that thing is just the fairly obvious solution to "how do we fit two cds in this jewel case?" to me XD
      • 2014-01-21 02103, 2014

      • Nyanko-sensei
        :D
      • 2014-01-21 02123, 2014

      • Nyanko-sensei
        japan's solution is funny
      • 2014-01-21 02139, 2014

      • chirlu`
        "Fairly obvious"? It's certainly patented.
      • 2014-01-21 02149, 2014

      • SultS
        I have digipaks with 2-3 CD’s as well, and I don’t call them any differently
      • 2014-01-21 02150, 2014

      • chirlu`
        So it can't be obvious.
      • 2014-01-21 02102, 2014

      • nikki
        yes, to me it's a fairly obvious solution to how to put two cds in a jewel case
      • 2014-01-21 02129, 2014

      • nikki
        the only other things I can think of are trays on both halves (which makes it thicker and leaves nowhere to put the booklet) or stacking them on top of each other
      • 2014-01-21 02144, 2014

      • HibiscusKazeneko
        Oh, there was a special term for that>
      • 2014-01-21 02105, 2014

      • HibiscusKazeneko
        That definitely isn't a Digipak
      • 2014-01-21 02118, 2014

      • nikki
        switching packaging to a digipak is *a* solution, but not a solution to "how do I put two cds in a jewel case?"
      • 2014-01-21 02140, 2014

      • HibiscusKazeneko
        I thought a Digipak was made of paper with a plastic tray glued in
      • 2014-01-21 02149, 2014

      • nikki
        yeah, that's my definition of it too
      • 2014-01-21 02105, 2014

      • SultS
      • 2014-01-21 02117, 2014

      • SultS
        maybe we could use Brilliant Box in MB?
      • 2014-01-21 02121, 2014

      • HibiscusKazeneko
        Oh yeah
      • 2014-01-21 02138, 2014

      • HibiscusKazeneko
        I was wanting to make a new ticket to add cover art types (mostly for Japanese 8cm CD cases)
      • 2014-01-21 02145, 2014

      • HibiscusKazeneko
        now we can add that
      • 2014-01-21 02152, 2014

      • chirlu`
        nikki: I don’t consider patentability any measure of non-obviousness in earnest. :)
      • 2014-01-21 02113, 2014

      • HibiscusKazeneko
        Patents are ridiculously easy to obtain
      • 2014-01-21 02131, 2014

      • HibiscusKazeneko
        Some college students patented playing with a cat by making it chase a laser in 1995
      • 2014-01-21 02131, 2014

      • chirlu`
        chirlu` has changed the topic to: Developers: #musicbrainz-devel | Latest Release: http://blog.musicbrainz.org/?p=2493 | IRC Log: http://chatlogs.musicbrainz.org/
      • 2014-01-21 02148, 2014

      • SultS
        what took them so long?
      • 2014-01-21 02106, 2014

      • HibiscusKazeneko
        Who? The developers?
      • 2014-01-21 02119, 2014

      • SultS
        those college students
      • 2014-01-21 02123, 2014

      • HibiscusKazeneko
        No clue
      • 2014-01-21 02143, 2014

      • HibiscusKazeneko
        I think they were trying to prove a point how stupidly easy it is to patent trivial things
      • 2014-01-21 02129, 2014

      • HibiscusKazeneko
        Or they were thinking they could troll with it later
      • 2014-01-21 02143, 2014

      • mb-chat-logger
        New post: blog: Server update, 2014-01-20 <http://blog.musicbrainz.org/2014/01/21/server-update-2014-01-20/>
      • 2014-01-21 02141, 2014

      • HibiscusKazeneko
        I saw they implemented the batch of packaging types I proposed
      • 2014-01-21 02127, 2014

      • SultS
      • 2014-01-21 02141, 2014

      • HibiscusKazeneko
        No, apparently it did not.
      • 2014-01-21 02144, 2014

      • SultS
        that page seems broken
      • 2014-01-21 02147, 2014

      • HibiscusKazeneko
        Should I fix it myself?
      • 2014-01-21 02107, 2014

      • nikki
        arrrgh that bug was supposed to be fixed I thought
      • 2014-01-21 02139, 2014

      • nikki
        oh wait, it's not a bug
      • 2014-01-21 02151, 2014

      • nikki
        we really did just finish the list with a heading with no description
      • 2014-01-21 02138, 2014

      • SultS
        and I really wanted to know what kind of packaging book was…
      • 2014-01-21 02116, 2014

      • nikki
        well, you might want to know what it's supposed to be for :P
      • 2014-01-21 02147, 2014

      • santiissopasse joined the channel
      • 2014-01-21 02120, 2014

      • nikki
        (all the stuff I have that comes with a book comes in a paper sleeve, so I'm not sure when I would use book)
      • 2014-01-21 02100, 2014

      • nikki
        or card sleeves for the more flexible things like magazines
      • 2014-01-21 02136, 2014

      • SultS
        I guess you can’t search releases with specific packaging tyoe
      • 2014-01-21 02139, 2014

      • SultS
        type*
      • 2014-01-21 02158, 2014

      • danoply joined the channel
      • 2014-01-21 02139, 2014

      • HibiscusKazeneko
        I fixed the Packaging doc
      • 2014-01-21 02151, 2014

      • nikki
        seems not. enter a search ticket if you want that, I guess
      • 2014-01-21 02102, 2014

      • HibiscusKazeneko
        or at least the wiki page
      • 2014-01-21 02118, 2014

      • HibiscusKazeneko
        a Transclusion Editor has to do the rest
      • 2014-01-21 02122, 2014

      • SultS
        thanks HibiscusKazeneko
      • 2014-01-21 02126, 2014

      • HibiscusKazeneko
        no prob
      • 2014-01-21 02139, 2014

      • nikki
        the page isn't in the transclusion table, so it'll update automatically
      • 2014-01-21 02142, 2014

      • SultS
        but yeah, that search would be interesting, if nothing else…
      • 2014-01-21 02146, 2014

      • nikki
        it's probably cached right now though
      • 2014-01-21 02107, 2014

      • HibiscusKazeneko
        nikki: I have a few CDs and cassettes packaged in books
      • 2014-01-21 02155, 2014

      • HibiscusKazeneko
      • 2014-01-21 02137, 2014

      • nikki
        I have some similar to digipaks that seem to be called "digibook", but I wouldn't consider them books
      • 2014-01-21 02105, 2014

      • HibiscusKazeneko
        "Digibook"? Pics please. This sounds interesting
      • 2014-01-21 02154, 2014

      • HibiscusKazeneko
      • 2014-01-21 02106, 2014

      • nikki
        yeah
      • 2014-01-21 02144, 2014

      • nikki
        plastic tray on one side, booklet fixed to the other, like a digipak, just made out of harder stuff rather than the flimsier digipak-style card
      • 2014-01-21 02152, 2014

      • HibiscusKazeneko
        I see
      • 2014-01-21 02112, 2014

      • HibiscusKazeneko
        I seem to recall having some book-tape combos from when I was a kid
      • 2014-01-21 02133, 2014

      • HibiscusKazeneko
      • 2014-01-21 02112, 2014

      • SultS
        nikki, I hope that ticket didn’t have to go under search server, because I didn’t put it there…
      • 2014-01-21 02138, 2014

      • nikki moves it
      • 2014-01-21 02153, 2014

      • SultS
        thanks
      • 2014-01-21 02157, 2014

      • SultS
        HibiscusKazeneko: I noticed that the wiki page is inconsistent in it’s upper and lower case usage
      • 2014-01-21 02107, 2014

      • HibiscusKazeneko
        let me check
      • 2014-01-21 02138, 2014

      • HibiscusKazeneko
        that wasn't my doing, but I'll fix it anyway
      • 2014-01-21 02146, 2014

      • SultS
        :)
      • 2014-01-21 02148, 2014

      • SultS
        well, time to go to bed… night all!
      • 2014-01-21 02149, 2014

      • chirlu` has left the channel
      • 2014-01-21 02129, 2014

      • santiissopasse joined the channel
      • 2014-01-21 02124, 2014

      • ariscop joined the channel
      • 2014-01-21 02112, 2014

      • santiissopasse joined the channel
      • 2014-01-21 02152, 2014

      • STalKer-X joined the channel
      • 2014-01-21 02125, 2014

      • CallerNo6 watches http://www.youtube.com/watch?v=_V4q0o-nKp4 , tries mentally substituting "genre" for "gender" :-)
      • 2014-01-21 02124, 2014

      • HibiscusKazeneko is trying to read through the Cicada 3301 puzzle progress, but her brain is starting to go numb
      • 2014-01-21 02130, 2014

      • hawke1 joined the channel
      • 2014-01-21 02154, 2014

      • ariscop joined the channel
      • 2014-01-21 02132, 2014

      • santiissopasse joined the channel
      • 2014-01-21 02114, 2014

      • johnb003 joined the channel
      • 2014-01-21 02100, 2014

      • ariscop joined the channel
      • 2014-01-21 02148, 2014

      • JesseW joined the channel
      • 2014-01-21 02112, 2014

      • ariscop joined the channel
      • 2014-01-21 02139, 2014

      • ariscop joined the channel
      • 2014-01-21 02153, 2014

      • ariscop joined the channel
      • 2014-01-21 02127, 2014

      • zas joined the channel
      • 2014-01-21 02139, 2014

      • ariscop joined the channel
      • 2014-01-21 02142, 2014

      • HibiscusKazeneko joined the channel
      • 2014-01-21 02154, 2014

      • HibiscusKazeneko
        shower accomplished
      • 2014-01-21 02148, 2014

      • simukis_ joined the channel
      • 2014-01-21 02102, 2014

      • HibiscusKazeneko has left the channel
      • 2014-01-21 02120, 2014

      • chirlu` joined the channel
      • 2014-01-21 02113, 2014

      • ruaok joined the channel
      • 2014-01-21 02113, 2014

      • simukis_ joined the channel
      • 2014-01-21 02112, 2014

      • ariscop joined the channel
      • 2014-01-21 02124, 2014

      • saebekassebil joined the channel
      • 2014-01-21 02114, 2014

      • reosarevok joined the channel
      • 2014-01-21 02131, 2014

      • hilikus joined the channel
      • 2014-01-21 02114, 2014

      • EM3RY joined the channel
      • 2014-01-21 02117, 2014

      • EM3RY joined the channel
      • 2014-01-21 02106, 2014

      • jcazevedo joined the channel
      • 2014-01-21 02102, 2014

      • v6lur joined the channel
      • 2014-01-21 02128, 2014

      • ruaok joined the channel
      • 2014-01-21 02118, 2014

      • hilikus joined the channel
      • 2014-01-21 02125, 2014

      • hilikus
        Hi guys, I am looking for some help. Maybe there is someone know how to do this.
      • 2014-01-21 02140, 2014

      • hilikus
        I was trying to query and dump only artists name that have the same name (namesake) and mbid.
      • 2014-01-21 02153, 2014

      • hilikus
        e.g. the killers:95e1ead9-4d31-4808-a7ac-32c3614c116b the killers:4665e836-2c96-4569-9462-bfea34850b69 the killers:24b4aee8-32ed-4163-98f7-55bae67411ae
      • 2014-01-21 02153, 2014

      • reosarevok
        Heh
      • 2014-01-21 02110, 2014

      • reosarevok
        Yeah, that should certainly be doable, given we have a report which basically does that query
      • 2014-01-21 02113, 2014

      • reosarevok goes find it
      • 2014-01-21 02159, 2014

      • hilikus
        Thanks, now I know it can be done. I am still finding on how to do it this under schema 19. thanks reosarevok :)
      • 2014-01-21 02113, 2014

      • hilikus
        Thanks, now I know it can be done. I am still finding on how to do this under schema 19. thanks reosarevok :)
      • 2014-01-21 02126, 2014

      • reosarevok
      • 2014-01-21 02136, 2014

      • reosarevok
        But that's probably more than you need to do
      • 2014-01-21 02111, 2014

      • reosarevok
        I'd imagine just a select name, gid from artist group by name when count larger than 1 should do
      • 2014-01-21 02116, 2014

      • reosarevok
        (or something to that effect)
      • 2014-01-21 02154, 2014

      • reosarevok
        (our code probably looks at aliases and whatnot too)
      • 2014-01-21 02114, 2014

      • nikki
        trying to find artists where the names are identical?
      • 2014-01-21 02134, 2014

      • reosarevok
        Yeah
      • 2014-01-21 02143, 2014

      • hilikus
        absolutely yes! :)
      • 2014-01-21 02157, 2014

      • nikki
        I would do select a.gid, a.name from (select name from artist group by name having count(*) > 1) as q join artist a on a.name=q.name;
      • 2014-01-21 02121, 2014

      • reosarevok
        heh
      • 2014-01-21 02145, 2014

      • reosarevok
        Yeah, ok, true, you can't just do one group by / having thingy with gid there
      • 2014-01-21 02151, 2014

      • reosarevok
        So, what she said :)
      • 2014-01-21 02144, 2014

      • reosarevok wonders why you want specifically dupe-name artists, heh :)