#metabrainz

and i evidently chose the wrong relationship type to do this form of "crediting"

soundandvision: yeah, if we decide to support this more properly then we'll eventually need to add such a relationship, I guess?

*such a relationship type

just thought it was a fun bit of data to track ultimately

hmmm, lots of words there, not sure what is being said in that article.

soundandvision: I would personally love for MB to store "top X" lists (could no doubt be interesting for machine learning stuff too), but as mayhem said before (re: copyright) “what we think of this and whether we agree with this are largely meaningless.”

I think it's just meant to be a musing but thought it was nice to see what they saw as useful from the different 'here are your music stat' services

(just finishing reading now too)

Spotify: useless, last.fm: that genre graph is just too good, listenbrainz: does very well considering this blogger is an avid Discogs fan. Well done all round tbh

soundandvision: (FWIW, I did a uni course a year or so back on "The Swedish Music Industry" which also covered a ton of (Swedish) copyright law. In my final assignment I wrote a lot of not-nice things about both the music industry, labels, rights organisations, and copyright law and still got away with a top grade. 😅 )

Any idea why listenbrainz would display less scrobbles for last year than lastfm? I'll leave them a comment if there's a good answer

there are a number of possible reasons:

1. if listens travel via last.fm, some might get lost. last.fm is not the most reliable service these days.

2. We are pickier about the quality of listens -- we'll reject data that is clearly crap.

3. Unless this user has done due diligence on their listens, one cannot judge the quality of listens by their total count. LB could've missed some. last.fm could have a pile of dupes.

[12:45] <lucifer> my personal top 100 could be a collection instead

+1 to this

Thanks! No 3. means we are stricter on timestamp overlaps?

stricter overall.

duplicates in particular are a key issue.

alastairp: hi! do you remember if there's a case where we would want to set the error message in listens importer table but not clear the external service oauth id?

[12:53] <reosarevok> aerozol: ok, I guess we do have "don't make up your own compilations" :)

that covers also personal lits imho

there are ~260 entries in the table. this combination looks wrong to me. i am unsure how these entries ended up this way. i intend to add a constaint at db level for this and run a script to clear the error messages.

*clear the error messages for these users

lucifer: hmm, I'm not sure. what kind of error messages are there?

all kinds actually :/

this is independent of if the oauth key is up to date?

no, external service oauth represents the oauth key.

is there a guide on how to make the most out of IRC - like quoting people's previous messages?

so if that id is present we have the oauth key else not.

soundandvision: you don't quote on irc (like on matrix) you jsut write their name to reply ot them

(like i did just now)

I see, thank-you CatQuest

👍

irc is definitely very.. text-simple

but that is why i prefer it actually. no bells and whistles, but works one anything

lucifer: and you're proposing that we always clear the oauth id if we set an error?

on* anything

lucifer: in this case that we're talking about with the temporary failure in auth, are you planning on setting a message or a log at all?

alastairp: uh yeah i was but not re-reading it, we decided the opposite so no shouldn't that.

*but re-reading

I guess a possible solution would be to have more functionality in user collections, then people can build whatever lists they like; their own ones, imaginary ones, published elsewhere ones

ok an idea re the lists: how about.. we create an user called "billboard" (or something) and these will have collaboratorive lists where anyone can contrbute really

<Freso> "soundandvision: I would personal..." <- user collages would be really cool to have in musicbrainz

uh uh what are the lists we can make of stuff called again >_<

thats what makes sites like redacted, rateyourmusic, etc nice social spaces

i think long term musicbrainz and critiquebrainz should be closely integrated

collections!

tandy1000: As CatQuest says, we already have collections. :p

collaborative collections. and special users which

like the things that make collections difficult to use for these kind of "ordered" lists is that there is no way of ordering them by position, like I can do with series

*everyone* can add to their collections

yeah i use collections

soundandvision: sounds like a ticket!

plus there's no freetext field, which is something I would really like (even if its just called notes/comments)

but UX is very different to collages like other sites

again. sounds liek a ticket for collection improvements

no handy album art grid display

ok i will check in JIRA if something already exists, as a lot of the time it seems someone else has already thought of this in the past

:D

soundandvision: There’s a PR waiting review for ordered collections: https://tickets.metabrainz.org/browse/MBS-5818

MBS-5818: Make it possible to have ordered collections (lists)

if you dind them (or make tikcets) pls ping me here with it since i'd liek to follow such ticket

ha

You're doing good work, Freso!

s/dind/find

my collection of music on my server :)

kept up to date with beets

oh my i'd love to be albe to order my persona lcollections too actually

oh wow that ticket is actually amazing

Lots of tickets about collections: https://tickets.metabrainz.org/issues/?jql=proj... :)

oh https://tickets.metabrainz.org/browse/MBS-1658

MBS-1658: My Collection: add free text comment field

already voted for this

reo had a pull open since 2021 on it

https://tickets.metabrainz.org/browse/MBS-9737 is about collaborative collections. Seems like CatQuest was happy with the current state a year or so ago, so I guess a new (linked?) ticket could/should be made if anyone wants globally-editable collections.

MBS-9737: Community Collections, collections anyone can edit

Yes, but it's a *draft* PR I need to work on :/

oh no

yea

Freso: I'll make a ticket if noone else does

wait who did mbs-9737

wasn't it reo? yo ushould assign yourself reosarevok

MBS-12261: UX: Collections as collages

CatQuest: reosarevok assigned themselves to https://tickets.metabrainz.org/browse/MBS-9428 :)

MBS-9428: Allow multiple users to share one collection

Changed the link type on MBS-9428 to better reflect this.

Eh.

9737

tandy1000: this relies on two other tickets which i have now linked

ha

"Additionally, there could be a way to create a fully open collection (owned by ModBot or something? Dunno) - that would probably require extra changes, but not sure"

ohhh. wait so did reo think my ticket https://tickets.metabrainz.org/browse/MBS-9737 wa that?

MBS-9737: Community Collections, collections anyone can edit

uhh

I'm going to have anoher cup of tea and do the dishes. if noone creates a ticket I'll do this

ping me if you make such a ticket <3

yvanzo: thanks for dealing with the tricatel spam <3

reosarevok: do we have the genre tables documented somewhere?

mayhem: https://github.com/metabrainz/musicbrainz-serve... ? 🙄

We really should put out an updated schema diagram :/

(the rolling eyes are at the docs, not you, in case it's unclear :D )

yep.

But IIRC the way we used to do it is some old luks-written app that is probably unmaintained and undocumented

So we should ideally find a better one

remember when I got an open source award for pointing people to createtables.sql?

lol

I do not :D

I should find the video.

I still have the clown nose reward he gave me.

"reward"

I'm looking at the createtables page, but it isn't clear how genre relates to tags

help me out?

I worked onto updating these diagrams when working on previous schema changes, I can look at it again.

mayhem: it doesn't directly relate on a DB level, because all we care are matching names, not ids

So we join on name

(in some rare cases, a genre can not even appear on tag, because nobody has used it yet)

yvanzo: thanks!!!

ah, ok.

[listenbrainz-server] 14amCap1712 opened pull request #1908 (03master…reset-error-message): Fix ON CONFLICT clause for spotify reader https://github.com/metabrainz/listenbrainz-serv...

reosarevok: so, in orrder to fetch genres, I would fetch tags and any tags where the tag name matched to a genre, then that tag is also a genre?

You're fetching from the DB?

yes

but I could fetch from your mom's house, if that is easier.

I would generally just JOIN genre ON tag.name = genre.name

yeah, that is what I am planning on doing.

Since that already limits then to genres, anyway, and gives you genre IDs in case you care, as well

That's what we do on MBS

k

That's find_user_genres_for_entities

thx

[musicbrainz-server] 14reosarevok opened pull request #2459 (03master…MBS-12260): MBS-12260 / MBS-12262: Block Facebook and YouTube search URLs https://github.com/metabrainz/musicbrainz-serve...

[musicbrainz-server] 14reosarevok opened pull request #2460 (03master…MBS-12263): MBS-12263: Only display "VIAF: " on VIAF pretty links when on sidebar https://github.com/metabrainz/musicbrainz-serve...

reosarevok: in the MB side-bar, what does "Other Tags" signify?

Not-genres

ok

Show? :)

I can't explain the `down-temp` tag on the morcheeba artist page. in my DB the count is 0.

+o on the tag name