#metabrainz

/

      • lucifer
        my question is do we want we to keep ignore casing in the api?
      • alastairp
        I think it's reasonable to be case-insensitive in both the api and site
      • lucifer
        makes sense +1
      • ruaok: can we do another full dump with the correct schema so that spark stats etc stuff can be tested.
      • ruaok
        Ok, will do when I get back to lappy
      • lucifer
        đź‘Ť thanks
      • agatzk joined the channel
      • ruaok: i forgot one thing, for the map. LB does a labs api lookup to get country codes of artists using MBIDs, since we know use artist credit id we need a labs api lookup for that.
      • ruaok
        Ok, should be easy.
      • ritiek has quit
      • ritiek joined the channel
      • lucifer
        ruaok: in the new parquet dumps, can the mbids ever be not-null but still invalid? for eg: `''` etc.
      • BrainzGit
        [musicbrainz-server] 14reosarevok opened pull request #2175 (03master…MBS-11788): MBS-11788: Guess case: Lowercase "official" in ETI https://github.com/metabrainz/musicbrainz-serve...
      • ruaok
        lucifer: they should not be. Not sure if that is true or not
      • lucifer
        ruaok: cool, i'll execute a query on the table to see what's the current status.
      • BrainzGit
        [acousticbrainz-server] 14alastair merged pull request #405 (03master…AB-460-chords_changes_rate): AB-460: Add tonal.chords_changes_rate to allowed lowlevel features https://github.com/metabrainz/acousticbrainz-se...
      • [acousticbrainz-server] 14alastair merged pull request #406 (03master…dataset-evaluation-download): Add link to download a dataset evaluation's history file https://github.com/metabrainz/acousticbrainz-se...
      • lucifer
        \o/ release time
      • BrainzGit
        [acousticbrainz-server] release 03v-2021-07-20.0 has been published by 14github-actions[bot]: https://github.com/metabrainz/acousticbrainz-se...
      • alastairp
        let's see if I remember how to do this
      • ruaok
        lucifer: ok, let me know. Omw back to my lappy now.
      • lucifer
      • so i guess not?
      • alastairp
        nice, released
      • _BrainzGit joined the channel
      • lucifer
      • alastairp
        yeah, not sure what happened there. I didn't touch AB database
      • lucifer
        first occurrence was 2 months old. yeah, probably not related then.
      • BrainzGit has quit
      • _BrainzGit
        [musicbrainz-server] 14reosarevok opened pull request #2176 (03master…MBS-11796): MBS-11796: Add Internet Archive logo for sidebar https://github.com/metabrainz/musicbrainz-serve...
      • BrainzBot
        MBS-11796: Add Internet Archive logo for sidebar https://tickets.metabrainz.org/browse/MBS-11796
      • _BrainzGit
        [musicbrainz-docker] release 03v-2021-07-20 has been published by 14reosarevok: https://github.com/metabrainz/musicbrainz-docke...
      • _BrainzGit has quit
      • BrainzGit joined the channel
      • ruaok returns
      • ruaok
        lucifer: "can we do another full dump with the correct schema so that spark stats etc stuff can be tested."
      • full dump and two incrementals like last time?
      • lucifer
        one full is enough. i am satisfied with the import process now.
      • ruaok
        ok
      • lucifer: dump started. how did that query god?
      • -d
      • lucifer
        >https://www.irccloud.com/pastebin/HuoRGTbx/
      • so no invalid mbids i think.
      • yvanzo
        CatQuest: URL editing popover can be tested at https://test.musicbrainz.org/release/8a7d57c7-9...
      • ruaok
        lucifer: that query didn't execute. doesn't look right to me.
      • lucifer
        ruaok: yeah, but that means its not possible to '' in a uuid column? if some other process tried to do that, it would also get that error
      • ruaok
        ah, I see what you're saying. well, both ways confirm that this is/can't be the case.
      • lucifer
        yup, can simplify some queries spark even more
      • ruaok
        lucifer: just to confirm, you want this https://labs.api.listenbrainz.org/artist-countr... but for artist_credit_id ?
      • lucifer
        yes
      • ritiek has quit
      • i just saw we have two lookups here https://github.com/metabrainz/listenbrainz-serv...
      • artist_credit from artist_mbid, and country from artist_mbid
      • so even just joining the two could work
      • ruaok
        I'll just make another endpoint and when you're done with the spark upgrades we can retire the old one.
      • bitmap
        alastairp: MBS doesn't ping delete-user yet, but we can add that for the next release, I have a branch for it
      • alastairp
        bitmap: the only question I had was related to https://github.com/metabrainz/listenbrainz-serv... - we're adding a trailing / to all urls. A url without a / will get redirected with HTTP308
      • I omitted this endpoint from our verification test, so it's not really a blocker in the grand scheme of things, I was just wondering if there was some flexibility in the structure of the URL
      • atj
        ruaok: have you heard of Roon? It appears to use MB quite heavily for metadata. https://roonlabs.com/
      • bitmap
        alastairp: I think it should be ok, perl's LWP should redirect transparently if we ping without the slash
      • alastairp
        bitmap: ok, great. thanks for confirming
      • ruaok
        atj: yep, they have been customers for a few years now. Not sure why they never made it to the supporters page. I should fix that.
      • atj
        ruaok: ah, I looked and didn't see them on there, hence the question.
      • It's quite a good service actually. Made me very happy to discover they used MB for metadata.
      • BrainzGit
        [musicbrainz-server] 14reosarevok opened pull request #2177 (03master…MBS-11794): MBS-11794: Link to edit searches on statistics/edits page https://github.com/metabrainz/musicbrainz-serve...
      • ruaok
        atj: nice people too. :)
      • atj
        ruaok: thanks, that makes me feel a bit better about shelling out $12 a month for a service to stream my own music!
      • ruaok
        oy -- that's a bit pricey.
      • buy hey, there is something to be said for a service that isn't the tech giants and works.
      • atj
        it's marketed at "audiophiles" so goes with the territory
      • alastairp
        do they send the music over gold-plated packets?
      • ruaok
        alastairp: damn you - you beat me to it.
      • alastairp
        :D
      • atj
        lifetime license is a snip at $700
      • ruaok
        I love the guy who ran a comparison with the $1000 audio cables and coat hangers. he could tell no difference.
      • atj
        they have a deep integration with Tidal and Qobuz and have gone all in on this MQA format
      • which apparently, and somwhat amusingly is lossy, but is still somehow better quality than FLAC
      • alastairp
        atj: how does it work? You send them a copy of what you have? or there's audio fingerprinting on your collection then they stream you their own copy?
      • atj
        You run the server on your own network
      • alastairp
        ah, right
      • have you been following the funkwhale discussion in here recently?
      • recently -> over the last 6-12 months, I guess...
      • atj
        and give it access to your collection. However you can also log in to Tidal or Qobuz and apparently it integrates your own collection with what is available by streaming via those services completely transparently.
      • No I haven't, do you have any links?
      • alastairp
      • it sounds like what you're talking about, except free software
      • atj
        Ah, I did look at that at some point.
      • alastairp
        đź‘Ť
      • atj
        I currently use Jellyfin for streaming my collection away from home, and Kodi for listening locally. Everything else I tried doesn't deal with the metadata properly
      • ruaok
        funkwhale works best when you have MBIDs in your collection.
      • atj
        My entire collection is tagged using Picard
      • Most of the stuff I submit to MB is so I can tag it in Picard :)
      • alastairp
        and that appears to be how most of us are dragged ni
      • in
      • outsidecontext
        +1
      • atj
        I was afraid it wouldn't have much info on contemporary artists but I've been surprised
      • ruaok
        reosarevok: do you know any artist_credits where at least one of the performers is from a different country?
      • akashgp09 has quit
      • does that make sense?
      • alastairp: clash is running temp with loads of python procs. 95% CPU. is that expected?
      • alastairp
        ruaok: yes, I'm running an AB process. However, I see that it's using all the threads. I think I'll quit it and tweak this to use fewer threads in order to keep the server happier
      • ruaok
        thank you!
      • alastairp
        just my service to you, triggering an overheat so that we can replace the fans ;)
      • container quit. load falling. will try again
      • reosarevok
        ruaok: sure, one sec
      • ruaok
        alastairp: how thoughtful of you!
      • reosarevok
      • For one
      • ruaok
      • is that right?
      • reosarevok
        Yup
      • ruaok
        kewl.
      • yvanzo
        bitmap: Has there been any change to the way recording’s first release date is written in the database when unknown?
      • CatQuest
        :|
      • yvanso: thanks
      • first thing I can say i that it's *right now* not an improvement? ifi paste some url it turns into a lin kand I have to open a modal to edit it (incase I wanted to edit it for whatever reason) it does this even if the "link type" isn't selected (something I tink it should do.)
      • (if i paste some not parsed url it parses it, but ehne opened for editing it's the old url.)
      • having a modal that lets you open it to edit things like "is it ended? date/start/end" is awesome!
      • but the old functionality of textbox editing sohudl remain imho
      • also could we really not make the div a *littlebit* wider?
      • it's really easy to click the "X" icon instead of the uh "pencil"
      • really prefer having simple url textbox
      • a posibility is to have it liek before, but thne have a "done" button at the bottom wich thne parses or thingyfies the links when one is done
      • ruaok
      • reosarevok
        CatQuest: the "having the old url" is intentional, the idea is to be able to see what the url you pasted is and what the system turned it into (it's the whole point of having the popup right now)
      • ruaok
        once you ok it, I can open a PR against labs
      • reosarevok
        Although I understand that sometimes it'd be good to just keep editing the now-cleaned URL too
      • CatQuest
        ... ooooooooooooh
      • uh oh
      • yea. ok
      • now i see he "cleaned up to"
      • so maybe having two boxes "pasted" and "saved/parsed"
      • yvanzo
        CatQuezt: improvements are: 1) you can see the URL before/after clean-up and edit raw URL if needed 2) see the whole URL in the list (and not just what input field let you see) 3) errors related to the URL only (not the relationship type) will be displayed next to the URL input field. But yes, there are some regressions at the moment, we tried to address the most severe ones (no need of extra click for
      • CatQuest
        but yes. please the default boxes
      • yvanzo
        example).
      • bitmap
        yvanzo: since the schema change at least, we don't store entries for null dates at all
      • CatQuest
        there kidna is a need for extra clic kif i want ot edit it ;)
      • reosarevok
        CatQuest: you mean you'd want to be able to both do a basic edit of the URL as text, and have the popup if you want more info?
      • (or fancier edits)
      • CatQuest
        reosarevok: I mean. sure why not?
      • and seeing the full url is easy in the popup for the url now (tho i did dislike having that nad not just having it automatically show asit did before (it worked liek you put the cursor in the box and thne the sideballon (similar to the infoboox for other textfields) would show the entire url))
      • yvanzo
        CatQuest: which extra click?
      • CatQuest
        infact that would be great
      • reosarevok
        I can see that, at least for URLs you just added
      • yvanzo: if you want to edit the URL you need to click the edit button rather than just, well, editing the URL :)
      • (so that is an extra click)
      • CatQuest
        just have a text box, and if you place the cursor in it the sidealoon shows this extra modal, no need tof clicking extra tiny pencils