#metabrainz

/

      • Nyanko-sensei joined the channel
      • 2020-09-18 26244, 2020

      • Nyanko-sensei has quit
      • 2020-09-18 26209, 2020

      • Nyanko-sensei joined the channel
      • 2020-09-18 26201, 2020

      • supersandro2000 has quit
      • 2020-09-18 26220, 2020

      • supersandro2000 joined the channel
      • 2020-09-18 26251, 2020

      • thomasross has quit
      • 2020-09-18 26220, 2020

      • shivam-kapila
        Morning
      • 2020-09-18 26253, 2020

      • kori joined the channel
      • 2020-09-18 26253, 2020

      • kori has quit
      • 2020-09-18 26253, 2020

      • kori joined the channel
      • 2020-09-18 26210, 2020

      • pristine___
        reosarevok: you about?
      • 2020-09-18 26226, 2020

      • reosarevok
        Just woke up, so depends on how hard the question is :D
      • 2020-09-18 26236, 2020

      • pristine___
        I wanted to read about join phrases in MB
      • 2020-09-18 26248, 2020

      • pristine___
        Any resource/link?
      • 2020-09-18 26255, 2020

      • pristine___
        Oh. Good morning!
      • 2020-09-18 26200, 2020

      • reosarevok
        Oh
      • 2020-09-18 26219, 2020

      • reosarevok
        I don't think there's much of a resource other than just https://musicbrainz.org/doc/Artist%20Credits
      • 2020-09-18 26223, 2020

      • reosarevok
        What doubts do you have? :)
      • 2020-09-18 26243, 2020

      • reosarevok
        That doesn't sound too hard so I'm probably awake enough
      • 2020-09-18 26258, 2020

      • reosarevok doesn't do coffee so at least he's not extra groggy before his drugs
      • 2020-09-18 26231, 2020

      • supersandro2000 has quit
      • 2020-09-18 26207, 2020

      • supersandro2000 joined the channel
      • 2020-09-18 26254, 2020

      • pristine___
        reosarevok: if I have a collaboration, I want to fetch all the artists from that collab. I guess I can just split on join phrases?
      • 2020-09-18 26215, 2020

      • reosarevok
        yvanzo: Well, was trying to figure out why BrainzBot is in #bookbrainz-devel but posting BB-whatever doesn't seem to trigger it
      • 2020-09-18 26224, 2020

      • reosarevok
        (CatQuest reported it last night)
      • 2020-09-18 26243, 2020

      • reosarevok
        The repos are assigned to BB, and in fact the same does work in here
      • 2020-09-18 26216, 2020

      • reosarevok
        pristine___: what do you actually have? code wise
      • 2020-09-18 26251, 2020

      • reosarevok
        Just an artist string? If so, it's hard to know what the join phrases are
      • 2020-09-18 26208, 2020

      • pristine___
        A table of artist names, artist credit ids
      • 2020-09-18 26208, 2020

      • reosarevok
        If you have a full artist credit, you might even just have the names/artists separately already
      • 2020-09-18 26220, 2020

      • reosarevok
        How are you getting it?
      • 2020-09-18 26225, 2020

      • reosarevok
        Show me the code :)
      • 2020-09-18 26228, 2020

      • pristine___
        Oooooo. Right.
      • 2020-09-18 26231, 2020

      • pristine___
        A sec
      • 2020-09-18 26255, 2020

      • pristine___
      • 2020-09-18 26240, 2020

      • pristine___
        Let us say top artist = a & b, I want to filter a and b separately
      • 2020-09-18 26215, 2020

      • pristine___
        I think I should get artist mbid from the list of artist mbids
      • 2020-09-18 26222, 2020

      • pristine___
        no?
      • 2020-09-18 26238, 2020

      • reosarevok
        Hmm
      • 2020-09-18 26250, 2020

      • reosarevok
        Do you have access to a full MB DB?
      • 2020-09-18 26211, 2020

      • reosarevok
        If you have an artist credit ID, you could do select artist from artist_credit_name where artist_credit is $artist_credit_id (https://wiki.musicbrainz.org/-/images/5/52/ngs.png)
      • 2020-09-18 26233, 2020

      • reosarevok
        That'd give you the separate artist IDs (or if you need to get the artist names you could join artist)
      • 2020-09-18 26239, 2020

      • reosarevok
        But I'm not sure how your ORM works
      • 2020-09-18 26246, 2020

      • v6lur_ joined the channel
      • 2020-09-18 26259, 2020

      • yvanzo
        bitmap: thanks for beta's update and fix!
      • 2020-09-18 26216, 2020

      • diru1100
        Afternoon!!
      • 2020-09-18 26257, 2020

      • shivam-kapila has quit
      • 2020-09-18 26246, 2020

      • shivam-kapila joined the channel
      • 2020-09-18 26205, 2020

      • pristine___ has quit
      • 2020-09-18 26218, 2020

      • Mr_Monkey has quit
      • 2020-09-18 26218, 2020

      • HorusHorrendus has quit
      • 2020-09-18 26218, 2020

      • outsidecontext has quit
      • 2020-09-18 26224, 2020

      • pristine___ joined the channel
      • 2020-09-18 26230, 2020

      • revi has quit
      • 2020-09-18 26236, 2020

      • Mr_Monkey joined the channel
      • 2020-09-18 26241, 2020

      • diru1100 has quit
      • 2020-09-18 26247, 2020

      • reosarevok has quit
      • 2020-09-18 26253, 2020

      • imdeni has quit
      • 2020-09-18 26254, 2020

      • diru1100 joined the channel
      • 2020-09-18 26249, 2020

      • HorusHorrendus joined the channel
      • 2020-09-18 26252, 2020

      • reosarevok joined the channel
      • 2020-09-18 26209, 2020

      • imdeni joined the channel
      • 2020-09-18 26230, 2020

      • revi joined the channel
      • 2020-09-18 26248, 2020

      • jmp_music_ has quit
      • 2020-09-18 26254, 2020

      • jmp_music_ joined the channel
      • 2020-09-18 26216, 2020

      • outsidecontext joined the channel
      • 2020-09-18 26219, 2020

      • alastairp joined the channel
      • 2020-09-18 26207, 2020

      • _lucifer
        yvanzo: seems this https://github.com/metabrainz/brainzutils-python is not watched by BrainzGit
      • 2020-09-18 26230, 2020

      • yvanzo
        _lucifer: now it is
      • 2020-09-18 26251, 2020

      • _lucifer
        👍
      • 2020-09-18 26242, 2020

      • shivam-kapila
        metabrainz.org dependencies are depricated
      • 2020-09-18 26253, 2020

      • shivam-kapila
        can we trigger dependabot for it
      • 2020-09-18 26244, 2020

      • alastairp
        are they just out of date, or are there known security issues? we already get alerts for security issues
      • 2020-09-18 26230, 2020

      • alastairp
        dependabot requires someone to be responsive to all of the reports. personally I prefer to update all dependencies at once periodically. are you offering to test changes on metabrainz? :)
      • 2020-09-18 26240, 2020

      • shivam-kapila
        what would be the required steps in testing?
      • 2020-09-18 26253, 2020

      • shivam-kapila
      • 2020-09-18 26204, 2020

      • alastairp
        at a very basic level, checking that tests still pass, but I don't know how much of the functionality has tests
      • 2020-09-18 26231, 2020

      • alastairp
        we probably only use node to compile js assets, it's possible that we could upgrade to the latest LTS directly
      • 2020-09-18 26253, 2020

      • alastairp
        however I don't know if MeB still uses gulp or if it has been upgraded to webpack
      • 2020-09-18 26204, 2020

      • alastairp
        parts of the gulp stack don't work with node 10 and above
      • 2020-09-18 26250, 2020

      • shivam-kapila
        I dont think it uses either
      • 2020-09-18 26245, 2020

      • BrainzGit
        [acousticbrainz-server] alastair closed pull request #362 (master…sim-docs): Add Similarity Documentation https://github.com/metabrainz/acousticbrainz-serv…
      • 2020-09-18 26208, 2020

      • shivam-kapila
        there's only less in package.json
      • 2020-09-18 26223, 2020

      • shivam-kapila
        python packages were last updated 3 years ago
      • 2020-09-18 26256, 2020

      • alastairp
        right, so it seems that node is only used to install less to build css
      • 2020-09-18 26216, 2020

      • shivam-kapila
        yep
      • 2020-09-18 26248, 2020

      • maxlath[m] has quit
      • 2020-09-18 26249, 2020

      • kepstin has quit
      • 2020-09-18 26255, 2020

      • MagnusSvensson[m has quit
      • 2020-09-18 26200, 2020

      • Cyna[m] has quit
      • 2020-09-18 26206, 2020

      • goldenshimmer has quit
      • 2020-09-18 26207, 2020

      • joshuaboniface has quit
      • 2020-09-18 26210, 2020

      • reg[m] has quit
      • 2020-09-18 26225, 2020

      • modwizcode has quit
      • 2020-09-18 26225, 2020

      • modwizcode joined the channel
      • 2020-09-18 26201, 2020

      • Gazooo794 has quit
      • 2020-09-18 26248, 2020

      • Gazooo794 joined the channel
      • 2020-09-18 26204, 2020

      • BrainzGit
        [critiquebrainz] amCap1712 opened pull request #302 (master…CB-368): CB-368: Submitting a review, clicking back, and submitting again causes error https://github.com/metabrainz/critiquebrainz/pull…
      • 2020-09-18 26206, 2020

      • BrainzBot
        CB-368: Submitting a review, clicking back, and submitting again causes error https://tickets.metabrainz.org/browse/CB-368
      • 2020-09-18 26235, 2020

      • ruaok
        moooin!
      • 2020-09-18 26247, 2020

      • ruaok
        pristine___: do you wear a small t-shirt size?
      • 2020-09-18 26244, 2020

      • pristine___
        Large
      • 2020-09-18 26208, 2020

      • ruaok
        alas.
      • 2020-09-18 26220, 2020

      • BrainzGit
        [musicbrainz-server] reosarevok opened pull request #1699 (master…MBS-11112): MBS-11112: Convert /main error pages to React https://github.com/metabrainz/musicbrainz-server/…
      • 2020-09-18 26222, 2020

      • BrainzBot
        MBS-11112: Convert /main error pages to React https://tickets.metabrainz.org/browse/MBS-11112
      • 2020-09-18 26223, 2020

      • ruaok has a small women's timescale t-shirt to give away
      • 2020-09-18 26234, 2020

      • shivam-kapila
        I guessed that
      • 2020-09-18 26255, 2020

      • shivam-kapila
        ruaok: why did they send you a women tee?
      • 2020-09-18 26205, 2020

      • ruaok
        it was part of their community award that I was awarded for that blog post.
      • 2020-09-18 26229, 2020

      • shivam-kapila
        didnt they ask size and all?
      • 2020-09-18 26250, 2020

      • Leo_Verto joined the channel
      • 2020-09-18 26218, 2020

      • Leo_Verto has quit
      • 2020-09-18 26249, 2020

      • kepstin joined the channel
      • 2020-09-18 26222, 2020

      • iliekcomputers
      • 2020-09-18 26230, 2020

      • iliekcomputers
        love mass media lol
      • 2020-09-18 26252, 2020

      • iliekcomputers
        ishaanshah: hey
      • 2020-09-18 26251, 2020

      • iliekcomputers
        once the dump PR is merged, does it make sense to kick off the yearly report project?
      • 2020-09-18 26243, 2020

      • MajorLurker joined the channel
      • 2020-09-18 26200, 2020

      • goldenshimmer joined the channel
      • 2020-09-18 26200, 2020

      • maxlath[m] joined the channel
      • 2020-09-18 26201, 2020

      • joshuaboniface joined the channel
      • 2020-09-18 26201, 2020

      • Leo_Verto joined the channel
      • 2020-09-18 26201, 2020

      • reg[m] joined the channel
      • 2020-09-18 26201, 2020

      • MagnusSvensson[m joined the channel
      • 2020-09-18 26208, 2020

      • Cyna[m] joined the channel
      • 2020-09-18 26255, 2020

      • Nyanko-sensei has quit
      • 2020-09-18 26205, 2020

      • Nyanko-sensei joined the channel
      • 2020-09-18 26227, 2020

      • _lucifer
      • 2020-09-18 26243, 2020

      • _lucifer
        yvanzo: is the above output expected ?
      • 2020-09-18 26256, 2020

      • reosarevok
        Why wouldn't it be? :)
      • 2020-09-18 26208, 2020

      • _lucifer
        no i mean the case of the names
      • 2020-09-18 26219, 2020

      • _lucifer
        ws accepts only lower case
      • 2020-09-18 26250, 2020

      • reosarevok
        Yes, it's stored like that - but you can always get them lowercased if you need them like that
      • 2020-09-18 26208, 2020

      • _lucifer
        no worries on that just, there was a bug due to incorrect casing
      • 2020-09-18 26219, 2020

      • _lucifer
        should probably document this somewhere
      • 2020-09-18 26203, 2020

      • _lucifer
        reosarevok, is there some documentation on using the musicbrainz db. it might make sense to have this there imo
      • 2020-09-18 26257, 2020

      • reosarevok
        Nothing too specific. There's stuff about the schema but that's about it
      • 2020-09-18 26210, 2020

      • reosarevok
        Most stuff is named capitalized
      • 2020-09-18 26237, 2020

      • MajorLurker has quit
      • 2020-09-18 26236, 2020

      • ruaok
      • 2020-09-18 26206, 2020

      • pristine___
        ruaok: bono isn't up?
      • 2020-09-18 26218, 2020

      • iliekcomputers
        i assume that's not gonna happen much, cloudflare outages are big events
      • 2020-09-18 26209, 2020

      • ruaok
        pristine___: bono is up, but the data set hoster instance appears down. let me look
      • 2020-09-18 26251, 2020

      • ruaok
        alastairp: all containers on bono are stopped for some reason.
      • 2020-09-18 26217, 2020

      • ruaok
        pristine___: is back
      • 2020-09-18 26242, 2020

      • pristine___
        ruaok: please remind me, what does multiple credit ids for a mbid mean? Artist_mbid = [a], artist credit id = [1, 2]
      • 2020-09-18 26253, 2020

      • ruaok
      • 2020-09-18 26221, 2020

      • ruaok
        see the section "artist credits"
      • 2020-09-18 26233, 2020

      • ruaok
        "Queen & David Bowie" -- two artists ("Queen" and "David Bowie"), no name variations, joined with " & "
      • 2020-09-18 26246, 2020

      • MajorLurker joined the channel