#metabrainz

/

      • alastairp
        yes it is
      • 2021-12-15 34952, 2021

      • mayhem
        50 lookups will take eons unless we do a batch lookup.
      • 2021-12-15 34959, 2021

      • lucifer
        that would generate greater load on frontend.
      • 2021-12-15 34915, 2021

      • alastairp
        right, so we're trying to work out a solution to speed it up
      • 2021-12-15 34926, 2021

      • alastairp
        does labs have direct access to caa tables?
      • 2021-12-15 34931, 2021

      • lucifer
        yup
      • 2021-12-15 34931, 2021

      • mayhem
        yes.
      • 2021-12-15 34900, 2021

      • alastairp
        the frontend can make a single query with 50 ids
      • 2021-12-15 34906, 2021

      • mayhem
        its a single query to the MB db.
      • 2021-12-15 34910, 2021

      • mayhem
        yep.
      • 2021-12-15 34937, 2021

      • alastairp
        does it make sense to do it through labs? other options: we run a job that computes all of this and put it into the yim table, and return it in page props
      • 2021-12-15 34902, 2021

      • mayhem
        that would work as well.
      • 2021-12-15 34927, 2021

      • dogga
        I can't seem to find a table for cover art in the database, how can I add it? i'm using docker
      • 2021-12-15 34955, 2021

      • mayhem
        lucifer: alastairp where can we find the 50 release_mbids ?
      • 2021-12-15 34919, 2021

      • lucifer
        i think its for top releases stats?
      • 2021-12-15 34959, 2021

      • lucifer
      • 2021-12-15 34916, 2021

      • lucifer
        each item in `top-releases` array has a release mbid.
      • 2021-12-15 34956, 2021

      • alastairp
        dogga: there are multiple schemas in the database, coverart is in the `cover_art_archive` schema - `cover_art_archive.cover_art` table
      • 2021-12-15 34931, 2021

      • alastairp
      • 2021-12-15 34932, 2021

      • alastairp
        lucifer: ^
      • 2021-12-15 34953, 2021

      • lucifer
        awesome! that looks right to me
      • 2021-12-15 34956, 2021

      • dogga
        alastairp: wow thank you
      • 2021-12-15 34958, 2021

      • alastairp
        Love/Hate page (https://listenbrainz.org/user/alastairp/feedback/) and pins page (https://listenbrainz.org/user/alastairp/pins/) which shows your loved/hated tracks.
      • 2021-12-15 34921, 2021

      • Lotheric_ has quit
      • 2021-12-15 34927, 2021

      • alastairp
        I guess you're saying here that the pins page includes loved tracks, because you pinned it because you really liked it?
      • 2021-12-15 34948, 2021

      • lucifer
        that was my understanding too. but mayhem can confirm
      • 2021-12-15 34940, 2021

      • monkey
        I think I added that.
      • 2021-12-15 34954, 2021

      • monkey
        I figured they are both feedback pages, but maybe the wording isn't right
      • 2021-12-15 34915, 2021

      • mayhem returns
      • 2021-12-15 34926, 2021

      • mayhem
        I'm finally able to get to the office. there in a few minutes.
      • 2021-12-15 34941, 2021

      • mayhem
        if you want me to write a script that does the lookup, lemme know.
      • 2021-12-15 34943, 2021

      • mayhem
        bbiab
      • 2021-12-15 34940, 2021

      • alastairp
        mayhem: yeah, you know the DB and labs infrastructure well enough that I suspect it'll be much faster for you to do compared to me
      • 2021-12-15 34924, 2021

      • monkey
        lucifer: Proposition for the wording of that phrase: "Feedback page [link] and pins page [link] which show tracks you loved (or hated!)"
      • 2021-12-15 34939, 2021

      • alastairp
        lucifer: monkey: anyway, I don't want to be too picky about the text. it's good enough that I'm not going get out my can opener
      • 2021-12-15 34959, 2021

      • lucifer
        monkey: sounds good to me. will update
      • 2021-12-15 34904, 2021

      • Lotheric joined the channel
      • 2021-12-15 34958, 2021

      • alastairp
        monkey: are you propositioning me?
      • 2021-12-15 34950, 2021

      • monkey
        akshaaatt: To fix the typescript issue with coverflow, add this line to js/src/types.d.ts: `declare module "react-coverflow";`
      • 2021-12-15 34905, 2021

      • akshaaatt
        Ah okay monkey!
      • 2021-12-15 34909, 2021

      • monkey
        Then you can commit the coverflow back in again :)
      • 2021-12-15 34940, 2021

      • monkey
        I figured out what's missing for the 3D transform as well. Will have to see where to add that, but it's all CSS solutions so "easy"
      • 2021-12-15 34952, 2021

      • monkey
      • 2021-12-15 34955, 2021

      • CatQuest
        "Import finished
      • 2021-12-15 34955, 2021

      • CatQuest
        Successfully submitted 1633619 listens to ListenBrainz
      • 2021-12-15 34955, 2021

      • CatQuest
        The number submitted listens is different from the 1633638 that lastfm reports due to an inconsistency in their API, sorry!
      • 2021-12-15 34955, 2021

      • CatQuest
        Thank you for using ListenBrainz!"
      • 2021-12-15 34959, 2021

      • CatQuest
        whooo
      • 2021-12-15 34903, 2021

      • akshaaatt
        !m monkey
      • 2021-12-15 34903, 2021

      • BrainzBot
        You're doing good work, monkey!
      • 2021-12-15 34924, 2021

      • monkey
        Congrats CatQuest on being a metadata millionaire !
      • 2021-12-15 34939, 2021

      • CatQuest
        :O and it's updated woooooo https://listenbrainz.org/user/CatCat/
      • 2021-12-15 34904, 2021

      • CatQuest
        weird that it grabs the back cover for the artwork tho :D
      • 2021-12-15 34928, 2021

      • Freso
        FWIW, service.listenbrainz is now in the official Kodi addon repository, so it’s now just a few clicks from within Kodi itself to install it: https://github.com/xbmc/repo-scripts/commit/0bf62… :)
      • 2021-12-15 34942, 2021

      • PopperBruda joined the channel
      • 2021-12-15 34947, 2021

      • CatQuest still kinda wished the yim would include the music i'm gonig ot listen to tomorrow and the next 10 days :o
      • 2021-12-15 34951, 2021

      • CatQuest
        !m Freso
      • 2021-12-15 34952, 2021

      • BrainzBot
        You're doing good work, Freso!
      • 2021-12-15 34926, 2021

      • lucifer
        monkey: alastairp: akshaaatt: mayhem: would anyone like to drop out of the next iteration of yim test mails?
      • 2021-12-15 34933, 2021

      • alastairp
        yes please
      • 2021-12-15 34943, 2021

      • alastairp
        don't need to ask me if you want to keep sending test emails
      • 2021-12-15 34920, 2021

      • monkey
        Freso: That's neat !
      • 2021-12-15 34939, 2021

      • lucifer
        the question who does want to receive one :)
      • 2021-12-15 34958, 2021

      • CatQuest feels weird about showing up on https://listenbrainz.org/similar-users/ becasue of the test artist :D
      • 2021-12-15 34911, 2021

      • monkey
        I don't mind getting a mail
      • 2021-12-15 34921, 2021

      • lucifer
        👍 incoming
      • 2021-12-15 34956, 2021

      • Freso
        It’s not perfect (e.g., it doesn’t include Release MBID currently), but I figured with YIM coming out any minute now, having it in there by today would be a good idea, so anyone who gets sucked in by YIM can just install the addon right away without jumping through a bunch of hoops. :)
      • 2021-12-15 34928, 2021

      • alastairp
        CatQuest: we can delete the test user if you want. but I'm sure that Freso isn't going to propose to delete you!
      • 2021-12-15 34935, 2021

      • CatQuest
        hahah
      • 2021-12-15 34943, 2021

      • CatQuest
        yea no i bet the test user will come in handy later too
      • 2021-12-15 34958, 2021

      • Freso deletes "CatCat"
      • 2021-12-15 34901, 2021

      • Freso
        O wait.
      • 2021-12-15 34903, 2021

      • CatQuest
        ಠ_ಠ
      • 2021-12-15 34912, 2021

      • Freso
        Oops.
      • 2021-12-15 34913, 2021

      • Freso
        :p
      • 2021-12-15 34919, 2021

      • CatQuest
        man I just finished a 15+ hour import
      • 2021-12-15 34927, 2021

      • CatQuest
        i don't nat ot do it again :P
      • 2021-12-15 34931, 2021

      • Freso
        I didn’t delete you. :)
      • 2021-12-15 34934, 2021

      • CatQuest
        i know :P
      • 2021-12-15 34914, 2021

      • alastairp
        someone's come into the office and is smashing doors everywhere and making so much noise
      • 2021-12-15 34923, 2021

      • CatQuest
        :
      • 2021-12-15 34924, 2021

      • CatQuest
        :(
      • 2021-12-15 34936, 2021

      • mayhem
        > someone's come into the office and is smashing doors everywhere and making so much noise
      • 2021-12-15 34940, 2021

      • mayhem
        they must be spanish, right?
      • 2021-12-15 34951, 2021

      • CatQuest
        i'm expecting thme to be making loads of mayhem :>
      • 2021-12-15 34907, 2021

      • mayhem
        I'm happy to keep receiving mails.
      • 2021-12-15 34924, 2021

      • mayhem
        wooo logo!
      • 2021-12-15 34955, 2021

      • alastairp
        mayhem: to confirm - it'd be great if you could do the labs coverart lookup
      • 2021-12-15 34906, 2021

      • lucifer
        monkey: did it render for you?
      • 2021-12-15 34917, 2021

      • lucifer
        ehh mayhem ^
      • 2021-12-15 34937, 2021

      • lucifer
        it didn't in gmail for me.
      • 2021-12-15 34954, 2021

      • lucifer
        the latest one does but lol its too big need to reduce its size
      • 2021-12-15 34955, 2021

      • monkey
      • 2021-12-15 34909, 2021

      • monkey
      • 2021-12-15 34923, 2021

      • CatQuest
        something in the middle maybe?
      • 2021-12-15 34933, 2021

      • lucifer
        i see, this is gmail or other client?
      • 2021-12-15 34942, 2021

      • lucifer
        the first one is exactly what i wanted.
      • 2021-12-15 34949, 2021

      • lucifer
        err the second one
      • 2021-12-15 34931, 2021

      • BrainzGit
        [musicbrainz-server] 14reosarevok opened pull request #2371 (03master…MBS-12134): MBS-12134: Convert the cancel edit page to React https://github.com/metabrainz/musicbrainz-server/…
      • 2021-12-15 34958, 2021

      • alastairp
        lucifer: remote image, or embedded?
      • 2021-12-15 34903, 2021

      • lucifer
        remote
      • 2021-12-15 34906, 2021

      • alastairp
        (thunderbird blocked it ;)
      • 2021-12-15 34915, 2021

      • lucifer
        one was from LB other from github
      • 2021-12-15 34903, 2021

      • lucifer
        embedding should be possible too methinks, let me look into it. it'll fix gmail woes too probably
      • 2021-12-15 34941, 2021

      • alastairp
        yeah, exactly. there was an example in the flask-mail docs which should be able to be recreated with the python lib
      • 2021-12-15 34902, 2021

      • lucifer
        oh i thought that was an attachment
      • 2021-12-15 34905, 2021

      • lucifer
        let me look again
      • 2021-12-15 34908, 2021

      • mayhem
        akshaaatt: lucifer I just chatted with monkey and alastairp and there are no things for me to do right now. I'll do some critical emails and then I will look at the YIM pr in detail.
      • 2021-12-15 34917, 2021

      • mayhem
        task me if you need anything.
      • 2021-12-15 34927, 2021

      • alastairp
        I'll be doing the coverart stuff. starting now
      • 2021-12-15 34913, 2021

      • monkey
        lucifer: That was from the macos mail app
      • 2021-12-15 34959, 2021

      • lucifer
        mayhem: end of year holidays' chocolates for the team would be nice ;D
      • 2021-12-15 34947, 2021

      • lucifer
        monkey: i see, gmail is doing something weird svgs, pngs render fine. i'll look into embedding
      • 2021-12-15 34907, 2021

      • alastairp
        oh yeah, svg sounds like asking for trouble
      • 2021-12-15 34933, 2021

      • mayhem hands several bars of chocolate to each teammember
      • 2021-12-15 34936, 2021

      • alastairp
        mayhem: can you check the search console to see what that redirect error is?
      • 2021-12-15 34925, 2021

      • mayhem
        not very useful -- wanna come look?
      • 2021-12-15 34929, 2021

      • alastairp
        sure
      • 2021-12-15 34934, 2021

      • mayhem
        lucifer: in the PR I suggested that we document some stuff -- would you like me to do that now?
      • 2021-12-15 34951, 2021

      • lucifer
        mayhem: sure 👍
      • 2021-12-15 34903, 2021

      • alastairp
        do we need to poke the backup server to fix the disk space alert?
      • 2021-12-15 34931, 2021

      • mayhem
        I just did that.
      • 2021-12-15 34936, 2021

      • mayhem
        lucifer: ok.
      • 2021-12-15 34942, 2021

      • alastairp
        thanks
      • 2021-12-15 34951, 2021

      • alastairp
        lucifer: hi, what's the easiest way for me to get a yim subset into my local development environment?
      • 2021-12-15 34956, 2021

      • alastairp
        copy the tables from kiss?
      • 2021-12-15 34937, 2021

      • lucifer
        yes probably
      • 2021-12-15 34918, 2021

      • lucifer
        if you want a small subset you can use the api on test to fetch the data and insert it locally
      • 2021-12-15 34948, 2021

      • lucifer
        for a larger subset, copying table or copy row_to_json will be faster.
      • 2021-12-15 34916, 2021

      • lucifer
        this is for cover art stuff?
      • 2021-12-15 34956, 2021

      • Freso
        Is "The ListenBrainz addon for @KodiTV is now available in Kodi’s official repository. Find it under the "Services" category within Kodi! —F" okay for me to tweet from @LB?
      • 2021-12-15 34906, 2021

      • lucifer
        sgtm
      • 2021-12-15 34915, 2021

      • reosarevok
        +1, but, mayhem?
      • 2021-12-15 34918, 2021

      • lucifer
        monkey: svg is creating problems, i'll download a png from meb logos repo and add to static/images in LB. sounds good?
      • 2021-12-15 34936, 2021

      • monkey
        Sure.
      • 2021-12-15 34938, 2021

      • mayhem
        sure
      • 2021-12-15 34944, 2021

      • monkey
        Do make sure it's the new logo
      • 2021-12-15 34955, 2021

      • monkey
        (we might have the old one lying around too)
      • 2021-12-15 34909, 2021

      • lucifer
        oh can you point me to the correct one then?
      • 2021-12-15 34947, 2021

      • alastairp
        lucifer: yes
      • 2021-12-15 34925, 2021

      • lucifer
        i see. what are you planning to do? add the urls to yim or a labs endpoint?
      • 2021-12-15 34946, 2021

      • alastairp
        adding the urls to yim, so that we don't have a public api that bypasses caa ;)
      • 2021-12-15 34932, 2021

      • mayhem
        alastairp: what top level key will you use in the yim data element? or will you add that in a sub-key?
      • 2021-12-15 34936, 2021

      • mayhem is documenting the keys used
      • 2021-12-15 34902, 2021

      • lucifer
        this would likely benefit top stats in general so a dump would be better actually.
      • 2021-12-15 34917, 2021

      • lucifer
        or nvm let's just do yim for now. can handle general case later.
      • 2021-12-15 34931, 2021

      • alastairp
        what's the key for top releases?
      • 2021-12-15 34943, 2021

      • lucifer
        top_releases :)
      • 2021-12-15 34944, 2021

      • alastairp
        top_releases, perhaps ;)
      • 2021-12-15 34958, 2021

      • mayhem nods