#metabrainz

Morning

reosarevok: you about?

Just woke up, so depends on how hard the question is :D

I wanted to read about join phrases in MB

Any resource/link?

Oh. Good morning!

Oh

I don't think there's much of a resource other than just https://musicbrainz.org/doc/Artist%20Credits

What doubts do you have? :)

That doesn't sound too hard so I'm probably awake enough

reosarevok: if I have a collaboration, I want to fetch all the artists from that collab. I guess I can just split on join phrases?

yvanzo: Well, was trying to figure out why BrainzBot is in #bookbrainz-devel but posting BB-whatever doesn't seem to trigger it

(CatQuest reported it last night)

The repos are assigned to BB, and in fact the same does work in here

pristine___: what do you actually have? code wise

Just an artist string? If so, it's hard to know what the join phrases are

A table of artist names, artist credit ids

If you have a full artist credit, you might even just have the names/artists separately already

How are you getting it?

Show me the code :)

Oooooo. Right.

A sec

Let us say top artist = a & b, I want to filter a and b separately

I think I should get artist mbid from the list of artist mbids

no?

Hmm

Do you have access to a full MB DB?

If you have an artist credit ID, you could do select artist from artist_credit_name where artist_credit is $artist_credit_id (https://wiki.musicbrainz.org/-/images/5/52/ngs.png)

That'd give you the separate artist IDs (or if you need to get the artist names you could join artist)

But I'm not sure how your ORM works

bitmap: thanks for beta's update and fix!

Afternoon!!

yvanzo: seems this https://github.com/metabrainz/brainzutils-python is not watched by BrainzGit

_lucifer: now it is

👍

metabrainz.org dependencies are depricated

can we trigger dependabot for it

are they just out of date, or are there known security issues? we already get alerts for security issues

dependabot requires someone to be responsive to all of the reports. personally I prefer to update all dependencies at once periodically. are you offering to test changes on metabrainz? :)

what would be the required steps in testing?

at a very basic level, checking that tests still pass, but I don't know how much of the functionality has tests

we probably only use node to compile js assets, it's possible that we could upgrade to the latest LTS directly

however I don't know if MeB still uses gulp or if it has been upgraded to webpack

parts of the gulp stack don't work with node 10 and above

I dont think it uses either

[acousticbrainz-server] alastair closed pull request #362 (master…sim-docs): Add Similarity Documentation https://github.com/metabrainz/acousticbrainz-se...

there's only less in package.json

python packages were last updated 3 years ago

right, so it seems that node is only used to install less to build css

yep

[critiquebrainz] amCap1712 opened pull request #302 (master…CB-368): CB-368: Submitting a review, clicking back, and submitting again causes error https://github.com/metabrainz/critiquebrainz/pu...

CB-368: Submitting a review, clicking back, and submitting again causes error https://tickets.metabrainz.org/browse/CB-368

moooin!

pristine___: do you wear a small t-shirt size?

Large

alas.

[musicbrainz-server] reosarevok opened pull request #1699 (master…MBS-11112): MBS-11112: Convert /main error pages to React https://github.com/metabrainz/musicbrainz-serve...

MBS-11112: Convert /main error pages to React https://tickets.metabrainz.org/browse/MBS-11112

I guessed that

ruaok: why did they send you a women tee?

it was part of their community award that I was awarded for that blog post.

didnt they ask size and all?

love mass media lol

ishaanshah: hey

once the dump PR is merged, does it make sense to kick off the yearly report project?

yvanzo: is the above output expected ?

Why wouldn't it be? :)

no i mean the case of the names

ws accepts only lower case

Yes, it's stored like that - but you can always get them lowercased if you need them like that

no worries on that just, there was a bug due to incorrect casing

should probably document this somewhere

reosarevok, is there some documentation on using the musicbrainz db. it might make sense to have this there imo

Nothing too specific. There's stuff about the schema but that's about it

Most stuff is named capitalized

ruaok: bono isn't up?

i assume that's not gonna happen much, cloudflare outages are big events

pristine___: bono is up, but the data set hoster instance appears down. let me look

alastairp: all containers on bono are stopped for some reason.

pristine___: is back

ruaok: please remind me, what does multiple credit ids for a mbid mean? Artist_mbid = [a], artist credit id = [1, 2]

see the section "artist credits"

"Queen & David Bowie" -- two artists ("Queen" and "David Bowie"), no name variations, joined with " & "