#metabrainz

my question is do we want we to keep ignore casing in the api?

I think it's reasonable to be case-insensitive in both the api and site

makes sense +1

ruaok: can we do another full dump with the correct schema so that spark stats etc stuff can be tested.

Ok, will do when I get back to lappy

👍 thanks

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.

Ok, should be easy.

ruaok: in the new parquet dumps, can the mbids ever be not-null but still invalid? for eg: `''` etc.

[musicbrainz-server] 14reosarevok opened pull request #2175 (03master…MBS-11788): MBS-11788: Guess case: Lowercase "official" in ETI https://github.com/metabrainz/musicbrainz-serve...

lucifer: they should not be. Not sure if that is true or not

ruaok: cool, i'll execute a query on the table to see what's the current status.

[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...

\o/ release time

[acousticbrainz-server] release 03v-2021-07-20.0 has been published by 14github-actions[bot]: https://github.com/metabrainz/acousticbrainz-se...

let's see if I remember how to do this

lucifer: ok, let me know. Omw back to my lappy now.

so i guess not?

nice, released

alastairp: https://sentry.metabrainz.org/metabrainz/acoust...

yeah, not sure what happened there. I didn't touch AB database

first occurrence was 2 months old. yeah, probably not related then.

[musicbrainz-server] 14reosarevok opened pull request #2176 (03master…MBS-11796): MBS-11796: Add Internet Archive logo for sidebar https://github.com/metabrainz/musicbrainz-serve...

MBS-11796: Add Internet Archive logo for sidebar https://tickets.metabrainz.org/browse/MBS-11796

[musicbrainz-docker] release 03v-2021-07-20 has been published by 14reosarevok: https://github.com/metabrainz/musicbrainz-docke...

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?

one full is enough. i am satisfied with the import process now.

ok

lucifer: dump started. how did that query god?

-d

>https://www.irccloud.com/pastebin/HuoRGTbx/

so no invalid mbids i think.

CatQuest: URL editing popover can be tested at https://test.musicbrainz.org/release/8a7d57c7-9...

lucifer: that query didn't execute. doesn't look right to me.

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

ah, I see what you're saying. well, both ways confirm that this is/can't be the case.

yup, can simplify some queries spark even more

lucifer: just to confirm, you want this https://labs.api.listenbrainz.org/artist-countr... but for artist_credit_id ?

yes

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

I'll just make another endpoint and when you're done with the spark upgrades we can retire the old one.

alastairp: MBS doesn't ping delete-user yet, but we can add that for the next release, I have a branch for it

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

ruaok: have you heard of Roon? It appears to use MB quite heavily for metadata. https://roonlabs.com/

alastairp: I think it should be ok, perl's LWP should redirect transparently if we ping without the slash

bitmap: ok, great. thanks for confirming

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.

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.

[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...

atj: nice people too. :)

ruaok: thanks, that makes me feel a bit better about shelling out $12 a month for a service to stream my own music!

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.

it's marketed at "audiophiles" so goes with the territory

do they send the music over gold-plated packets?

alastairp: damn you - you beat me to it.

:D

lifetime license is a snip at $700

I love the guy who ran a comparison with the $1000 audio cables and coat hangers. he could tell no difference.

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

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?

You run the server on your own network

ah, right

have you been following the funkwhale discussion in here recently?

recently -> over the last 6-12 months, I guess...

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?

it sounds like what you're talking about, except free software

Ah, I did look at that at some point.

👍

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

funkwhale works best when you have MBIDs in your collection.

My entire collection is tagged using Picard

Most of the stuff I submit to MB is so I can tag it in Picard :)

and that appears to be how most of us are dragged ni

in

+1

I was afraid it wouldn't have much info on contemporary artists but I've been surprised

reosarevok: do you know any artist_credits where at least one of the performers is from a different country?

lucifer: http://bono.metabrainz.org:4201/artist-country-...

does that make sense?

alastairp: clash is running temp with loads of python procs. 95% CPU. is that expected?

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

thank you!

just my service to you, triggering an overheat so that we can replace the fans ;)

container quit. load falling. will try again

ruaok: sure, one sec

alastairp: how thoughtful of you!

ruaok: https://musicbrainz.org/artist-credit/2925190

For one

reosarevok: http://bono.metabrainz.org:4201/artist-country-...

is that right?

Yup

kewl.

bitmap: Has there been any change to the way recording’s first release date is written in the database when unknown?

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.)

also there is this issue: https://usercontent.irccloud-cdn.com/file/bNYNR...

(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

lucifer: moved to https://datasets.listenbrainz.org/artist-countr...

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)

once you ok it, I can open a PR against labs

Although I understand that sometimes it'd be good to just keep editing the now-cleaned URL too

... ooooooooooooh

uh oh

yea. ok

now i see he "cleaned up to"

so maybe having two boxes "pasted" and "saved/parsed"

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

but yes. please the default boxes

example).

yvanzo: since the schema change at least, we don't store entries for null dates at all

there kidna is a need for extra clic kif i want ot edit it ;)

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)

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))

CatQuest: which extra click?

infact that would be great

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)

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