#metabrainz

/

      • alastairp
        yes it is
      • mayhem
        50 lookups will take eons unless we do a batch lookup.
      • lucifer
        that would generate greater load on frontend.
      • alastairp
        right, so we're trying to work out a solution to speed it up
      • does labs have direct access to caa tables?
      • lucifer
        yup
      • mayhem
        yes.
      • alastairp
        the frontend can make a single query with 50 ids
      • mayhem
        its a single query to the MB db.
      • yep.
      • 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
      • mayhem
        that would work as well.
      • dogga
        I can't seem to find a table for cover art in the database, how can I add it? i'm using docker
      • mayhem
        lucifer: alastairp where can we find the 50 release_mbids ?
      • lucifer
        i think its for top releases stats?
      • each item in `top-releases` array has a release mbid.
      • alastairp
        dogga: there are multiple schemas in the database, coverart is in the `cover_art_archive` schema - `cover_art_archive.cover_art` table
      • lucifer: ^
      • lucifer
        awesome! that looks right to me
      • dogga
        alastairp: wow thank you
      • 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.
      • Lotheric_ has quit
      • I guess you're saying here that the pins page includes loved tracks, because you pinned it because you really liked it?
      • lucifer
        that was my understanding too. but mayhem can confirm
      • monkey
        I think I added that.
      • I figured they are both feedback pages, but maybe the wording isn't right
      • mayhem returns
      • mayhem
        I'm finally able to get to the office. there in a few minutes.
      • if you want me to write a script that does the lookup, lemme know.
      • bbiab
      • 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
      • monkey
        lucifer: Proposition for the wording of that phrase: "Feedback page [link] and pins page [link] which show tracks you loved (or hated!)"
      • 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
      • lucifer
        monkey: sounds good to me. will update
      • Lotheric joined the channel
      • alastairp
        monkey: are you propositioning me?
      • monkey
        akshaaatt: To fix the typescript issue with coverflow, add this line to js/src/types.d.ts: `declare module "react-coverflow";`
      • akshaaatt
        Ah okay monkey!
      • monkey
        Then you can commit the coverflow back in again :)
      • 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"
      • CatQuest
        "Import finished
      • Successfully submitted 1633619 listens to ListenBrainz
      • The number submitted listens is different from the 1633638 that lastfm reports due to an inconsistency in their API, sorry!
      • Thank you for using ListenBrainz!"
      • whooo
      • akshaaatt
        !m monkey
      • BrainzBot
        You're doing good work, monkey!
      • monkey
        Congrats CatQuest on being a metadata millionaire !
      • CatQuest
        :O and it's updated woooooo https://listenbrainz.org/user/CatCat/
      • weird that it grabs the back cover for the artwork tho :D
      • 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/0bf... :)
      • PopperBruda joined the channel
      • CatQuest still kinda wished the yim would include the music i'm gonig ot listen to tomorrow and the next 10 days :o
      • CatQuest
        !m Freso
      • BrainzBot
        You're doing good work, Freso!
      • lucifer
        monkey: alastairp: akshaaatt: mayhem: would anyone like to drop out of the next iteration of yim test mails?
      • alastairp
        yes please
      • don't need to ask me if you want to keep sending test emails
      • monkey
        Freso: That's neat !
      • lucifer
        the question who does want to receive one :)
      • CatQuest feels weird about showing up on https://listenbrainz.org/similar-users/ becasue of the test artist :D
      • monkey
        I don't mind getting a mail
      • lucifer
        👍 incoming
      • 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. :)
      • 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!
      • CatQuest
        hahah
      • yea no i bet the test user will come in handy later too
      • Freso deletes "CatCat"
      • Freso
        O wait.
      • CatQuest
        ಠ_ಠ
      • Freso
        Oops.
      • :p
      • CatQuest
        man I just finished a 15+ hour import
      • i don't nat ot do it again :P
      • Freso
        I didn’t delete you. :)
      • CatQuest
        i know :P
      • alastairp
        someone's come into the office and is smashing doors everywhere and making so much noise
      • CatQuest
        :
      • :(
      • mayhem
        > someone's come into the office and is smashing doors everywhere and making so much noise
      • they must be spanish, right?
      • CatQuest
        i'm expecting thme to be making loads of mayhem :>
      • mayhem
        I'm happy to keep receiving mails.
      • wooo logo!
      • alastairp
        mayhem: to confirm - it'd be great if you could do the labs coverart lookup
      • lucifer
        monkey: did it render for you?
      • ehh mayhem ^
      • it didn't in gmail for me.
      • the latest one does but lol its too big need to reduce its size
      • monkey
      • CatQuest
        something in the middle maybe?
      • lucifer
        i see, this is gmail or other client?
      • the first one is exactly what i wanted.
      • err the second one
      • 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-serve...
      • alastairp
        lucifer: remote image, or embedded?
      • lucifer
        remote
      • alastairp
        (thunderbird blocked it ;)
      • lucifer
        one was from LB other from github
      • embedding should be possible too methinks, let me look into it. it'll fix gmail woes too probably
      • alastairp
        yeah, exactly. there was an example in the flask-mail docs which should be able to be recreated with the python lib
      • lucifer
        oh i thought that was an attachment
      • let me look again
      • 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.
      • task me if you need anything.
      • alastairp
        I'll be doing the coverart stuff. starting now
      • monkey
        lucifer: That was from the macos mail app
      • lucifer
        mayhem: end of year holidays' chocolates for the team would be nice ;D
      • monkey: i see, gmail is doing something weird svgs, pngs render fine. i'll look into embedding
      • alastairp
        oh yeah, svg sounds like asking for trouble
      • mayhem hands several bars of chocolate to each teammember
      • mayhem: can you check the search console to see what that redirect error is?
      • mayhem
        not very useful -- wanna come look?
      • alastairp
        sure
      • mayhem
        lucifer: in the PR I suggested that we document some stuff -- would you like me to do that now?
      • lucifer
        mayhem: sure 👍
      • alastairp
        do we need to poke the backup server to fix the disk space alert?
      • mayhem
        I just did that.
      • lucifer: ok.
      • alastairp
        thanks
      • lucifer: hi, what's the easiest way for me to get a yim subset into my local development environment?
      • copy the tables from kiss?
      • lucifer
        yes probably
      • if you want a small subset you can use the api on test to fetch the data and insert it locally
      • for a larger subset, copying table or copy row_to_json will be faster.
      • this is for cover art stuff?
      • 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?
      • lucifer
        sgtm
      • reosarevok
        +1, but, mayhem?
      • lucifer
        monkey: svg is creating problems, i'll download a png from meb logos repo and add to static/images in LB. sounds good?
      • monkey
        Sure.
      • mayhem
        sure
      • monkey
        Do make sure it's the new logo
      • (we might have the old one lying around too)
      • lucifer
        oh can you point me to the correct one then?
      • alastairp
        lucifer: yes
      • lucifer
        i see. what are you planning to do? add the urls to yim or a labs endpoint?
      • alastairp
        adding the urls to yim, so that we don't have a public api that bypasses caa ;)
      • mayhem
        alastairp: what top level key will you use in the yim data element? or will you add that in a sub-key?
      • mayhem is documenting the keys used
      • lucifer
        this would likely benefit top stats in general so a dump would be better actually.
      • or nvm let's just do yim for now. can handle general case later.
      • alastairp
        what's the key for top releases?
      • lucifer
        top_releases :)
      • alastairp
        top_releases, perhaps ;)
      • mayhem nods