#metabrainz

/

      • mayhem
        thx!
      • 2023-12-05 33925, 2023

      • lucifer
        np
      • 2023-12-05 33943, 2023

      • lucifer
      • 2023-12-05 33956, 2023

      • mayhem nods
      • 2023-12-05 33900, 2023

      • lucifer
        specifically this line but you can reuse the entire query, both seem to be extracting the same data
      • 2023-12-05 33929, 2023

      • petitminion joined the channel
      • 2023-12-05 33911, 2023

      • petitminion has quit
      • 2023-12-05 33957, 2023

      • petitminion joined the channel
      • 2023-12-05 33900, 2023

      • mayhem
        monkey: just pushed the change to include release_group_artist_credit_mbids in the release_groups data for the artist page
      • 2023-12-05 33916, 2023

      • monkey
        Ace
      • 2023-12-05 33924, 2023

      • monkey
        AH, bollocks. Looks like my local dev branch still points to more-cached-data branch…
      • 2023-12-05 33933, 2023

      • monkey
        I know it was a bad idea !
      • 2023-12-05 33913, 2023

      • mayhem
        you walked into the one fully knowing, lol
      • 2023-12-05 33954, 2023

      • monkey
        > Elvis Presley will resurrect and the Earth will turn into a donut.
      • 2023-12-05 33954, 2023

      • monkey
        I love this yvanzo
      • 2023-12-05 33904, 2023

      • monkey
        Beautiful vision
      • 2023-12-05 33939, 2023

      • mayhem
        flat donut, please.
      • 2023-12-05 33903, 2023

      • mayhem
        lucifer: next thing to pester you with: I am looking for an SQL fragment that collects the release_date for a release-group. know of one I can pilfer?
      • 2023-12-05 33937, 2023

      • lucifer
        all the release dates of a release group ?
      • 2023-12-05 33948, 2023

      • mayhem
        first one would be ideal.
      • 2023-12-05 33958, 2023

      • lucifer
        the query i shared before has it
      • 2023-12-05 33905, 2023

      • mayhem
        thx
      • 2023-12-05 33914, 2023

      • lucifer
        `rgm.first_release_date_year`
      • 2023-12-05 33943, 2023

      • lucifer
        there's also first_release_date_month and first_release_date_day in that table
      • 2023-12-05 33943, 2023

      • mayhem
        great
      • 2023-12-05 33928, 2023

      • minimal joined the channel
      • 2023-12-05 33915, 2023

      • mayhem
        monkey: pushed
      • 2023-12-05 33917, 2023

      • mayhem
      • 2023-12-05 33936, 2023

      • mayhem
        eh, I guess that key name is less than gud now.
      • 2023-12-05 33939, 2023

      • mayhem
        gud. hmm.
      • 2023-12-05 33939, 2023

      • monkey
        What we do in other places in the codebase is output a list of MBIDs on one side and a separate list of AC names next to it
      • 2023-12-05 33954, 2023

      • monkey
        Might be best to follow the same structure?
      • 2023-12-05 33924, 2023

      • mayhem
        the other method is worse method if you ask me. this is a better way of doing it.
      • 2023-12-05 33934, 2023

      • mayhem
        and it would be more work making it suckier.
      • 2023-12-05 33947, 2023

      • monkey
        Example from last year's YIM:
      • 2023-12-05 33949, 2023

      • monkey
      • 2023-12-05 33955, 2023

      • monkey
        Ah, more work?
      • 2023-12-05 33956, 2023

      • lucifer
        {"name": name, "mbid": mbid, "joinphrase": & }
      • 2023-12-05 33920, 2023

      • mayhem
        sure, I can make it a dict, but two arrays makes things harder.
      • 2023-12-05 33924, 2023

      • lucifer
        we can do better than last year's YIM for sure.
      • 2023-12-05 33930, 2023

      • lucifer
      • 2023-12-05 33957, 2023

      • lucifer
        this is the format that listens use in LB now, stats and playlists too with recent bugfixes.
      • 2023-12-05 33910, 2023

      • lucifer
        let's stick to that imo.
      • 2023-12-05 33915, 2023

      • mayhem
        thanks, will follow.
      • 2023-12-05 33904, 2023

      • monkey
        Yes, I think that'll work well
      • 2023-12-05 33916, 2023

      • lusciouslover joined the channel
      • 2023-12-05 33912, 2023

      • BrainzGit
        [musicbrainz-server] 14reosarevok merged pull request #3112 (03master…MBS-13388): MBS-13388: Handle vk.gy links https://github.com/metabrainz/musicbrainz-server/…
      • 2023-12-05 33926, 2023

      • lusciouslover has quit
      • 2023-12-05 33946, 2023

      • BrainzGit
        [musicbrainz-server] 14reosarevok merged pull request #2494 (03master…MBS-11556): MBS-11556: Standardise / clean up YouTube Music URLs https://github.com/metabrainz/musicbrainz-server/…
      • 2023-12-05 33957, 2023

      • mayhem
        monkey: found a weird bug with some data results monkey, digging now.
      • 2023-12-05 33923, 2023

      • monkey
        Data results monkeys are the worst monkeys of them all
      • 2023-12-05 33946, 2023

      • Rotab joined the channel
      • 2023-12-05 33940, 2023

      • petitminion has quit
      • 2023-12-05 33949, 2023

      • mayhem
        monkey: pushed.
      • 2023-12-05 33900, 2023

      • monkey
        Thx
      • 2023-12-05 33932, 2023

      • reosarevok
      • 2023-12-05 33941, 2023

      • reosarevok
        Looks huge but I expect a lot of that is the pot file generation
      • 2023-12-05 33951, 2023

      • yvanzo
        Thanks! 👏
      • 2023-12-05 33937, 2023

      • reosarevok
        I'm around for quite a while today still in case changes are needed :)
      • 2023-12-05 33952, 2023

      • mayhem
        zas: is it just me or does wolf seem to be acting up more recently?
      • 2023-12-05 33904, 2023

      • mayhem
        its a server we got some an auction, so it likely quite old.
      • 2023-12-05 33912, 2023

      • zas
        well, more stuff runs on it too, and users don't seem to care much about resources
      • 2023-12-05 33928, 2023

      • zas
        but yes, auction servers are cheaper for a reason ;)
      • 2023-12-05 33944, 2023

      • mayhem
        well, monkey is going to get his own lappy to work on soon.
      • 2023-12-05 33950, 2023

      • mayhem
        that might help.
      • 2023-12-05 33957, 2023

      • mayhem tries running his query again
      • 2023-12-05 33933, 2023

      • monkey
        I do'nt use it super often, to be honest
      • 2023-12-05 33939, 2023

      • prathamg joined the channel
      • 2023-12-05 33922, 2023

      • Kladky_ joined the channel
      • 2023-12-05 33940, 2023

      • Kladky has quit
      • 2023-12-05 33941, 2023

      • Kladky_ is now known as Kladky
      • 2023-12-05 33950, 2023

      • yvanzo
        reosarevok: pushed a fix if you want to review it (while I continue reviewing the rest)
      • 2023-12-05 33916, 2023

      • reosarevok
        yvanzo: should be Nl_p, no? : )
      • 2023-12-05 33955, 2023

      • reosarevok
        (and you'd need to import it as such)
      • 2023-12-05 33958, 2023

      • reosarevok
        But it seems sensible
      • 2023-12-05 33944, 2023

      • bitmap
        N_lp* :)
      • 2023-12-05 33958, 2023

      • yvanzo
        Good catch :)
      • 2023-12-05 33916, 2023

      • yvanzo
        (both of you)
      • 2023-12-05 33918, 2023

      • reosarevok
        :D yeah that
      • 2023-12-05 33922, 2023

      • ApeKattQuest
        🐟
      • 2023-12-05 33949, 2023

      • antlarr2 is now known as antlarr
      • 2023-12-05 33917, 2023

      • monkey
        mayhem: Just realized on the album page we're also missing the artist credits for the release
      • 2023-12-05 33935, 2023

      • monkey
        So that I can compose the full artist credit complete with links
      • 2023-12-05 33950, 2023

      • mayhem
        I'm so glad we're doing the shake-out right now. :/
      • 2023-12-05 33953, 2023

      • monkey
        Sorry for the trickle…
      • 2023-12-05 33959, 2023

      • jivte_ joined the channel
      • 2023-12-05 33944, 2023

      • jivte_
        Hey everyone!!
      • 2023-12-05 33952, 2023

      • jivte_
        just checked out listenbrainz with lucifer as masterchief from halo
      • 2023-12-05 33931, 2023

      • jivte_
        on twitter
      • 2023-12-05 33947, 2023

      • jivte_ found it cool
      • 2023-12-05 33922, 2023

      • jivte_ has quit
      • 2023-12-05 33923, 2023

      • rdswift
        reosarevok, yvanzo, aerozol: Am I understanding correctly that you plan to self-host the documentation rather than putting it on ReadTheDocs? That would indeed allow a LOT more flexibility in the resulting look and feel, with a corresponding increase in the work required. And for the record, I have paused all of my work in this until further notice so as to not "waste my time".
      • 2023-12-05 33929, 2023

      • ApeKattQuest
        the only thing I'm confused by is if this is a replacement of the /docs on mb proper and/or the wiki-editing background, in which case I'd prefer editing on the wiki, but acc reo in the ticket it's only things that are like official official so only changed due to policy ie, style or code change in-which updating git thing while changing code (which is fine and I understand the logic) but personally I'd rather do "whip"s on the wiki an
      • 2023-12-05 33930, 2023

      • ApeKattQuest
        yway
      • 2023-12-05 33953, 2023

      • ApeKattQuest
        erh
      • 2023-12-05 33900, 2023

      • ApeKattQuest
        "wip"s
      • 2023-12-05 33912, 2023

      • rdswift
        Would the intent to still base the documentation on using Sphinx, or something else? Don't need an answer now, but it's something that should be considered early.
      • 2023-12-05 33904, 2023

      • ApeKattQuest
        spinx?
      • 2023-12-05 33907, 2023

      • ApeKattQuest
        dammit
      • 2023-12-05 33914, 2023

      • ApeKattQuest
        sphinx
      • 2023-12-05 33909, 2023

      • kellnerd
        Windows 10's support for Ogg files is so fucked up, you can't even move/rename them without causing the file explorer to hang for minutes 🙄
      • 2023-12-05 33917, 2023

      • reosarevok
        rdswift: not sure how much you can do to style readthedocs itself - so not quite sure re: self hosting :) I'm sure mayhem would love us to host less stuff
      • 2023-12-05 33951, 2023

      • kellnerd
        (https://answers.microsoft.com/en-us/windows/forum… still not fixed after 4 years...)
      • 2023-12-05 33939, 2023

      • mayhem
        RTD has themes, Soni suspect that we can roll our own. Even if we just tweak colors a bit, it would look better.
      • 2023-12-05 33918, 2023

      • atj
      • 2023-12-05 33945, 2023

      • rdswift
        Otherwise we could likely host it on github using github pages (like we do with the Picard docs).
      • 2023-12-05 33935, 2023

      • reosarevok
        yvanzo: are you updating your new commit or should I update the update? :D
      • 2023-12-05 33924, 2023

      • lucifer
        mayhem: your top genres,
      • 2023-12-05 33928, 2023

      • lucifer
      • 2023-12-05 33953, 2023

      • lucifer
      • 2023-12-05 33950, 2023

      • ApeKattQuest
        ooh show me mine :o
      • 2023-12-05 33917, 2023

      • lucifer
        ApeKattQuest: what's your LB username?
      • 2023-12-05 33921, 2023

      • ApeKattQuest
        🙏
      • 2023-12-05 33929, 2023

      • ApeKattQuest
        uh should be the same?
      • 2023-12-05 33940, 2023

      • ApeKattQuest
        ApeKattQuest, MonkeyPython
      • 2023-12-05 33944, 2023

      • ApeKattQuest
        as on mb
      • 2023-12-05 33904, 2023

      • ApeKattQuest
      • 2023-12-05 33937, 2023

      • lucifer
      • 2023-12-05 33944, 2023

      • ApeKattQuest
        :O thank you lucifer !
      • 2023-12-05 33908, 2023

      • ApeKattQuest
        wtf arena rock :
      • 2023-12-05 33910, 2023

      • ApeKattQuest
        :D
      • 2023-12-05 33920, 2023

      • ansh
        lucifer: do we have an endpoint / a table in database to fetch top albums for an artist?
      • 2023-12-05 33938, 2023

      • lucifer
        monkey: generated all the data for YIM.
      • 2023-12-05 33950, 2023

      • lucifer
        ready for testing. if you want i can put it up on testing.
      • 2023-12-05 33900, 2023

      • ApeKattQuest
        man this maks me look boring :C
      • 2023-12-05 33913, 2023

      • ApeKattQuest
        wait.. breakbeat? :D
      • 2023-12-05 33906, 2023

      • lucifer
      • 2023-12-05 33912, 2023

      • lucifer
        this is for top recordings.
      • 2023-12-05 33919, 2023

      • monkey
        lucifer: thanks, that's great! Hold off on putting it on test please, currently testing entity pages there
      • 2023-12-05 33938, 2023

      • lucifer
        you can copy the code and modify it for albums.
      • 2023-12-05 33953, 2023

      • ansh
        Cool!
      • 2023-12-05 33955, 2023

      • lucifer
        if you want me to, i can do that.
      • 2023-12-05 33900, 2023

      • lucifer
        monkey: sure
      • 2023-12-05 33929, 2023

      • BrainzGit
        [listenbrainz-server] 14amCap1712 merged pull request #2631 (03master…duplicate-msids-3): Replace duplicates MSIDs in recording_feedback, pinned_recording and user_timelime_event tables https://github.com/metabrainz/listenbrainz-server…
      • 2023-12-05 33931, 2023

      • monkey
        Lol, my top genres = rock subgenres bingo
      • 2023-12-05 33904, 2023

      • ApeKattQuest
        ya, me too
      • 2023-12-05 33912, 2023

      • ansh
        lucifer: I'll do it, just checking rn if i have the the tables in my DB or I need to import them from production
      • 2023-12-05 33920, 2023

      • lucifer
        cool
      • 2023-12-05 33919, 2023

      • BrainzGit
        [listenbrainz-server] 14amCap1712 merged pull request #2653 (03master…periodic-jams-max-artist): LB-1352: Weekly Jams makes playlists of 90% one artist https://github.com/metabrainz/listenbrainz-server…
      • 2023-12-05 33954, 2023

      • ApeKattQuest
        wait. iirc akshaaatt in japan?
      • 2023-12-05 33919, 2023

      • monkey
        Thanks for fixing the playlist generation lucifer !
      • 2023-12-05 33931, 2023

      • monkey gets to enjoy recs again!
      • 2023-12-05 33900, 2023

      • ansh
        monkey: Are these the final designs for the artist similarity page? Or are these just the proposed designs?
      • 2023-12-05 33901, 2023

      • ansh
      • 2023-12-05 33922, 2023

      • ansh
      • 2023-12-05 33936, 2023

      • monkey
        ansh: not sure,and on my phone at the moment so I can't tell you straight away. Maybe ask aerozol when he's up?
      • 2023-12-05 33910, 2023

      • ansh
        Cool
      • 2023-12-05 33945, 2023

      • yvanzo
        reosarevok: You can update it if you want, I’m still at reviewing the rest :/
      • 2023-12-05 33937, 2023

      • ApeKattQuest
        akshaaatt: if you in japan, you need to chekc out https://mainichi.jp/articles/20231205/spp/000/006…
      • 2023-12-05 33955, 2023

      • ApeKattQuest
        Lupin Kabuki!!!