#metabrainz

/

      • soundandvision
        and i evidently chose the wrong relationship type to do this form of "crediting"
      • 2022-03-17 07632, 2022

      • reosarevok
        soundandvision: yeah, if we decide to support this more properly then we'll eventually need to add such a relationship, I guess?
      • 2022-03-17 07646, 2022

      • reosarevok
        *such a relationship type
      • 2022-03-17 07607, 2022

      • soundandvision
        just thought it was a fun bit of data to track ultimately
      • 2022-03-17 07647, 2022

      • mayhem
        hmmm, lots of words there, not sure what is being said in that article.
      • 2022-03-17 07649, 2022

      • Freso
        soundandvision: I would personally love for MB to store "top X" lists (could no doubt be interesting for machine learning stuff too), but as mayhem said before (re: copyright) “what we think of this and whether we agree with this are largely meaningless.”
      • 2022-03-17 07658, 2022

      • aerozol
        I think it's just meant to be a musing but thought it was nice to see what they saw as useful from the different 'here are your music stat' services
      • 2022-03-17 07610, 2022

      • aerozol
        (just finishing reading now too)
      • 2022-03-17 07635, 2022

      • aerozol
        Spotify: useless, last.fm: that genre graph is just too good, listenbrainz: does very well considering this blogger is an avid Discogs fan. Well done all round tbh
      • 2022-03-17 07613, 2022

      • Freso
        soundandvision: (FWIW, I did a uni course a year or so back on "The Swedish Music Industry" which also covered a ton of (Swedish) copyright law. In my final assignment I wrote a lot of not-nice things about both the music industry, labels, rights organisations, and copyright law and still got away with a top grade. 😅 )
      • 2022-03-17 07643, 2022

      • aerozol
        Any idea why listenbrainz would display less scrobbles for last year than lastfm? I'll leave them a comment if there's a good answer
      • 2022-03-17 07631, 2022

      • mayhem
        there are a number of possible reasons:
      • 2022-03-17 07600, 2022

      • mayhem
        1. if listens travel via last.fm, some might get lost. last.fm is not the most reliable service these days.
      • 2022-03-17 07633, 2022

      • mayhem
        2. We are pickier about the quality of listens -- we'll reject data that is clearly crap.
      • 2022-03-17 07614, 2022

      • mayhem
        3. Unless this user has done due diligence on their listens, one cannot judge the quality of listens by their total count. LB could've missed some. last.fm could have a pile of dupes.
      • 2022-03-17 07644, 2022

      • CatQuest
        [12:45] <lucifer> my personal top 100 could be a collection instead
      • 2022-03-17 07644, 2022

      • CatQuest
        +1 to this
      • 2022-03-17 07647, 2022

      • aerozol
        Thanks! No 3. means we are stricter on timestamp overlaps?
      • 2022-03-17 07658, 2022

      • mayhem
        stricter overall.
      • 2022-03-17 07626, 2022

      • mayhem
        duplicates in particular are a key issue.
      • 2022-03-17 07658, 2022

      • lucifer
        alastairp: hi! do you remember if there's a case where we would want to set the error message in listens importer table but not clear the external service oauth id?
      • 2022-03-17 07634, 2022

      • CatQuest
        [12:53] <reosarevok> aerozol: ok, I guess we do have "don't make up your own compilations" :)
      • 2022-03-17 07635, 2022

      • CatQuest
        that covers also personal lits imho
      • 2022-03-17 07608, 2022

      • lucifer
        there are ~260 entries in the table. this combination looks wrong to me. i am unsure how these entries ended up this way. i intend to add a constaint at db level for this and run a script to clear the error messages.
      • 2022-03-17 07627, 2022

      • lucifer
        *clear the error messages for these users
      • 2022-03-17 07636, 2022

      • alastairp
        lucifer: hmm, I'm not sure. what kind of error messages are there?
      • 2022-03-17 07645, 2022

      • lucifer
        all kinds actually :/
      • 2022-03-17 07600, 2022

      • alastairp
        this is independent of if the oauth key is up to date?
      • 2022-03-17 07634, 2022

      • lucifer
        no, external service oauth represents the oauth key.
      • 2022-03-17 07651, 2022

      • soundandvision
        is there a guide on how to make the most out of IRC - like quoting people's previous messages?
      • 2022-03-17 07606, 2022

      • lucifer
        so if that id is present we have the oauth key else not.
      • 2022-03-17 07638, 2022

      • CatQuest
        soundandvision: you don't quote on irc (like on matrix) you jsut write their name to reply ot them
      • 2022-03-17 07649, 2022

      • CatQuest
        (like i did just now)
      • 2022-03-17 07657, 2022

      • soundandvision
        I see, thank-you CatQuest
      • 2022-03-17 07602, 2022

      • CatQuest
        👍
      • 2022-03-17 07612, 2022

      • CatQuest
        irc is definitely very.. text-simple
      • 2022-03-17 07625, 2022

      • CatQuest
        but that is why i prefer it actually. no bells and whistles, but works one anything
      • 2022-03-17 07644, 2022

      • alastairp
        lucifer: and you're proposing that we always clear the oauth id if we set an error?
      • 2022-03-17 07645, 2022

      • CatQuest
        on* anything
      • 2022-03-17 07617, 2022

      • alastairp
        lucifer: in this case that we're talking about with the temporary failure in auth, are you planning on setting a message or a log at all?
      • 2022-03-17 07620, 2022

      • lucifer
        alastairp: uh yeah i was but not re-reading it, we decided the opposite so no shouldn't that.
      • 2022-03-17 07629, 2022

      • lucifer
        *but re-reading
      • 2022-03-17 07629, 2022

      • soundandvision
        I guess a possible solution would be to have more functionality in user collections, then people can build whatever lists they like; their own ones, imaginary ones, published elsewhere ones
      • 2022-03-17 07642, 2022

      • CatQuest
        ok an idea re the lists: how about.. we create an user called "billboard" (or something) and these will have collaboratorive lists where anyone can contrbute really
      • 2022-03-17 07600, 2022

      • tandy1000
        <Freso> "soundandvision: I would personal..." <- user collages would be really cool to have in musicbrainz
      • 2022-03-17 07625, 2022

      • CatQuest
        uh uh what are the lists we can make of stuff called again >_<
      • 2022-03-17 07626, 2022

      • tandy1000
        thats what makes sites like redacted, rateyourmusic, etc nice social spaces
      • 2022-03-17 07651, 2022

      • tandy1000
        i think long term musicbrainz and critiquebrainz should be closely integrated
      • 2022-03-17 07600, 2022

      • CatQuest
        collections!
      • 2022-03-17 07613, 2022

      • Freso
        tandy1000: As CatQuest says, we already have collections. :p
      • 2022-03-17 07616, 2022

      • CatQuest
        collaborative collections. and special users which
      • 2022-03-17 07625, 2022

      • soundandvision
        like the things that make collections difficult to use for these kind of "ordered" lists is that there is no way of ordering them by position, like I can do with series
      • 2022-03-17 07626, 2022

      • CatQuest
        *everyone* can add to their collections
      • 2022-03-17 07631, 2022

      • Freso
      • 2022-03-17 07632, 2022

      • tandy1000
        yeah i use collections
      • 2022-03-17 07645, 2022

      • CatQuest
        soundandvision: sounds like a ticket!
      • 2022-03-17 07648, 2022

      • soundandvision
        plus there's no freetext field, which is something I would really like (even if its just called notes/comments)
      • 2022-03-17 07653, 2022

      • tandy1000
        but UX is very different to collages like other sites
      • 2022-03-17 07600, 2022

      • CatQuest
        again. sounds liek a ticket for collection improvements
      • 2022-03-17 07602, 2022

      • tandy1000
        no handy album art grid display
      • 2022-03-17 07609, 2022

      • soundandvision
        ok i will check in JIRA if something already exists, as a lot of the time it seems someone else has already thought of this in the past
      • 2022-03-17 07619, 2022

      • CatQuest
        :D
      • 2022-03-17 07624, 2022

      • Freso
        soundandvision: There’s a PR waiting review for ordered collections: https://tickets.metabrainz.org/browse/MBS-5818
      • 2022-03-17 07625, 2022

      • BrainzBot
        MBS-5818: Make it possible to have ordered collections (lists)
      • 2022-03-17 07639, 2022

      • CatQuest
        if you dind them (or make tikcets) pls ping me here with it since i'd liek to follow such ticket
      • 2022-03-17 07644, 2022

      • CatQuest
        ha
      • 2022-03-17 07651, 2022

      • CatQuest
        !m Freso
      • 2022-03-17 07651, 2022

      • BrainzBot
        You're doing good work, Freso!
      • 2022-03-17 07609, 2022

      • CatQuest
        s/dind/find
      • 2022-03-17 07628, 2022

      • tandy1000
        my collection of music on my server :)
      • 2022-03-17 07628, 2022

      • tandy1000
      • 2022-03-17 07634, 2022

      • tandy1000
        kept up to date with beets
      • 2022-03-17 07654, 2022

      • CatQuest
        oh my i'd love to be albe to order my persona lcollections too actually
      • 2022-03-17 07606, 2022

      • CatQuest
        oh wow that ticket is actually amazing
      • 2022-03-17 07610, 2022

      • Freso
        Lots of tickets about collections: https://tickets.metabrainz.org/issues/?jql=projec… :)
      • 2022-03-17 07653, 2022

      • CatQuest
      • 2022-03-17 07654, 2022

      • BrainzBot
        MBS-1658: My Collection: add free text comment field
      • 2022-03-17 07611, 2022

      • CatQuest
        already voted for this
      • 2022-03-17 07638, 2022

      • CatQuest
        reo had a pull open since 2021 on it
      • 2022-03-17 07617, 2022

      • Freso
        https://tickets.metabrainz.org/browse/MBS-9737 is about collaborative collections. Seems like CatQuest was happy with the current state a year or so ago, so I guess a new (linked?) ticket could/should be made if anyone wants globally-editable collections.
      • 2022-03-17 07618, 2022

      • BrainzBot
        MBS-9737: Community Collections, collections anyone can edit
      • 2022-03-17 07633, 2022

      • reosarevok
        Yes, but it's a *draft* PR I need to work on :/
      • 2022-03-17 07645, 2022

      • CatQuest
        oh no
      • 2022-03-17 07604, 2022

      • CatQuest
        yea
      • 2022-03-17 07613, 2022

      • CatQuest
        Freso: I'll make a ticket if noone else does
      • 2022-03-17 07630, 2022

      • CatQuest
        wait who did mbs-9737
      • 2022-03-17 07640, 2022

      • CatQuest
        wasn't it reo? yo ushould assign yourself reosarevok
      • 2022-03-17 07656, 2022

      • tandy1000
      • 2022-03-17 07656, 2022

      • BrainzBot
        MBS-12261: UX: Collections as collages
      • 2022-03-17 07659, 2022

      • Freso
        CatQuest: reosarevok assigned themselves to https://tickets.metabrainz.org/browse/MBS-9428 :)
      • 2022-03-17 07659, 2022

      • BrainzBot
        MBS-9428: Allow multiple users to share one collection
      • 2022-03-17 07608, 2022

      • Freso
        Changed the link type on MBS-9428 to better reflect this.
      • 2022-03-17 07621, 2022

      • Freso
        Eh.
      • 2022-03-17 07632, 2022

      • Freso
        9737
      • 2022-03-17 07655, 2022

      • tandy1000
        tandy1000: this relies on two other tickets which i have now linked
      • 2022-03-17 07650, 2022

      • CatQuest
        ha
      • 2022-03-17 07652, 2022

      • CatQuest
        "Additionally, there could be a way to create a fully open collection (owned by ModBot or something? Dunno) - that would probably require extra changes, but not sure"
      • 2022-03-17 07612, 2022

      • CatQuest
        ohhh. wait so did reo think my ticket https://tickets.metabrainz.org/browse/MBS-9737 wa that?
      • 2022-03-17 07613, 2022

      • BrainzBot
        MBS-9737: Community Collections, collections anyone can edit
      • 2022-03-17 07620, 2022

      • CatQuest
        uhh
      • 2022-03-17 07653, 2022

      • CatQuest
        I'm going to have anoher cup of tea and do the dishes. if noone creates a ticket I'll do this
      • 2022-03-17 07608, 2022

      • CatQuest
        ping me if you make such a ticket <3
      • 2022-03-17 07655, 2022

      • agatzk has quit
      • 2022-03-17 07617, 2022

      • agatzk joined the channel
      • 2022-03-17 07657, 2022

      • reosarevok
        yvanzo: thanks for dealing with the tricatel spam <3
      • 2022-03-17 07658, 2022

      • soundandvision has quit
      • 2022-03-17 07659, 2022

      • mayhem
        reosarevok: do we have the genre tables documented somewhere?
      • 2022-03-17 07631, 2022

      • reosarevok
      • 2022-03-17 07644, 2022

      • reosarevok
        We really should put out an updated schema diagram :/
      • 2022-03-17 07602, 2022

      • reosarevok
        (the rolling eyes are at the docs, not you, in case it's unclear :D )
      • 2022-03-17 07624, 2022

      • mayhem
        yep.
      • 2022-03-17 07627, 2022

      • reosarevok
        But IIRC the way we used to do it is some old luks-written app that is probably unmaintained and undocumented
      • 2022-03-17 07637, 2022

      • reosarevok
        So we should ideally find a better one
      • 2022-03-17 07641, 2022

      • mayhem
        remember when I got an open source award for pointing people to createtables.sql?
      • 2022-03-17 07642, 2022

      • mayhem
        lol
      • 2022-03-17 07654, 2022

      • reosarevok
        I do not :D
      • 2022-03-17 07603, 2022

      • mayhem
        I should find the video.
      • 2022-03-17 07612, 2022

      • mayhem
        I still have the clown nose reward he gave me.
      • 2022-03-17 07617, 2022

      • mayhem
        "reward"
      • 2022-03-17 07604, 2022

      • mayhem
        I'm looking at the createtables page, but it isn't clear how genre relates to tags
      • 2022-03-17 07613, 2022

      • mayhem
        help me out?
      • 2022-03-17 07619, 2022

      • yvanzo
        I worked onto updating these diagrams when working on previous schema changes, I can look at it again.
      • 2022-03-17 07612, 2022

      • reosarevok
        mayhem: it doesn't directly relate on a DB level, because all we care are matching names, not ids
      • 2022-03-17 07632, 2022

      • reosarevok
        So we join on name
      • 2022-03-17 07647, 2022

      • reosarevok
        (in some rare cases, a genre can not even appear on tag, because nobody has used it yet)
      • 2022-03-17 07600, 2022

      • reosarevok
        yvanzo: thanks!!!
      • 2022-03-17 07619, 2022

      • mayhem
        ah, ok.
      • 2022-03-17 07603, 2022

      • BrainzGit
        [listenbrainz-server] 14amCap1712 opened pull request #1908 (03master…reset-error-message): Fix ON CONFLICT clause for spotify reader https://github.com/metabrainz/listenbrainz-server…
      • 2022-03-17 07628, 2022

      • mayhem
        reosarevok: so, in orrder to fetch genres, I would fetch tags and any tags where the tag name matched to a genre, then that tag is also a genre?
      • 2022-03-17 07650, 2022

      • reosarevok
        You're fetching from the DB?
      • 2022-03-17 07656, 2022

      • mayhem
        yes
      • 2022-03-17 07607, 2022

      • mayhem
        but I could fetch from your mom's house, if that is easier.
      • 2022-03-17 07624, 2022

      • reosarevok
        I would generally just JOIN genre ON tag.name = genre.name
      • 2022-03-17 07638, 2022

      • mayhem
        yeah, that is what I am planning on doing.
      • 2022-03-17 07648, 2022

      • reosarevok
        Since that already limits then to genres, anyway, and gives you genre IDs in case you care, as well
      • 2022-03-17 07655, 2022

      • reosarevok
        That's what we do on MBS
      • 2022-03-17 07603, 2022

      • mayhem
        k
      • 2022-03-17 07608, 2022

      • reosarevok
      • 2022-03-17 07612, 2022

      • reosarevok
        That's find_user_genres_for_entities
      • 2022-03-17 07626, 2022

      • mayhem
        thx
      • 2022-03-17 07633, 2022

      • BrainzGit
        [musicbrainz-server] 14reosarevok opened pull request #2459 (03master…MBS-12260): MBS-12260 / MBS-12262: Block Facebook and YouTube search URLs https://github.com/metabrainz/musicbrainz-server/…
      • 2022-03-17 07644, 2022

      • BrainzGit
        [musicbrainz-server] 14reosarevok opened pull request #2460 (03master…MBS-12263): MBS-12263: Only display "VIAF: " on VIAF pretty links when on sidebar https://github.com/metabrainz/musicbrainz-server/…
      • 2022-03-17 07644, 2022

      • mayhem
        reosarevok: in the MB side-bar, what does "Other Tags" signify?
      • 2022-03-17 07652, 2022

      • reosarevok
        Not-genres
      • 2022-03-17 07659, 2022

      • mayhem
        ok
      • 2022-03-17 07618, 2022

      • mayhem must have a bug in his query then
      • 2022-03-17 07658, 2022

      • reosarevok
        Show? :)
      • 2022-03-17 07611, 2022

      • mayhem
      • 2022-03-17 07644, 2022

      • mayhem
        I can't explain the `down-temp` tag on the morcheeba artist page. in my DB the count is 0.
      • 2022-03-17 07655, 2022

      • mayhem
        +o on the tag name