#musicbrainz

Arghghg.

yes

well, this is on the wiki, so it should use the wiki term, then, no? ;-)

feel free to change it

Or we could kill the term in the wiki, adapt to the page and be coherent

:p

well there's also pages in the wiki that call them "relationships" :P

reosarevok: yeah, that would be nice.

like http://wiki.musicbrainz.org/Category:Relationsh... is not "Category:Advanced_Relationship_Type" (and I didn't create it, so it's not just me :D)

hm. we do seem to have a problem here.

kepstin: and what are relationships?

nikki: advanced relationships being done by a lazy typist ;)

the advantage to Advanced Relationship (and it's acronym, AR) is it's somewhat more distinctive than the other two alteratives...

kepstin-laptop: nah, lazy people write "ARs" :P

well, true.

but yeah; relationships just seems like too general of a term.

why are some works duplicated on the artists worklist-page? i just dont see a difference between works that are listed under 'composer' and works that are not in a special 'category'

ehrgeiz: works that aren't in a special category are ones that were performed by that artist.

That

they really should be labelled as such :/

Which, following CSG, are all of them for classical composers

Thus the duplication

hmm. I guess performed is the wrong work

the works that aren't in a special category is the ones that have that artist listed in the artist credit on at least one recording of the work.

now our terminological confusion is at least documented: http://wiki.musicbrainz.org/Advanced_Relationsh...

so, about AR attributes...

jessew: btw, modpending is actually edits_pending in the database. it seems the diagram needs updating

argh.

Good to know.

link_type and l_*_* also have a last_updated column, link has a created column

nikki: modpending (or edits_pending) -- is my description of what it *does* accurate?

oh-kay.. so works from pop releases where the composer and lyricist is not the 'known' performing artist will still be listed under the artists workpage; thats the purpose of this i guess?

jessew: it's actually a count of the open edits, so not quite a flag

ehrgeiz: exactly.

nikki: I'll correct that.

So wait, are we getting stuff documented?

Correctly?

ehrgeiz: this is particularly useful for songs performed by a band, but written by members of the bad.

mind=blown

band*

reosarevok: feel free to help :P

reosarevok: well, I wouldn't go so far as to claim *correctness* -- but I hope I'm being at least pleasently imaginative...

kepstin-laptop: makes sense now, thx. one more reason to change artist credits from composer to performer on recordings.

for classical

is Lukas (the guy who made the diagram) still around -- does he have the graphviz source available?

I think it's actually some program he wrote himself

hah.

nikki: so, what is the link_attribute table do, exactly?

relationships can have multiple attributes. so guest performed violin would have one row in 'link' and two rows in 'link_attribute'

I should really just download a copy of the database and poke around myself...

that's how I learnt everything I know about it :)

:p

RARG

i can't get wine to work on on ubuntu karmic 9.10.. it wont dl

it keeps crying about dependencies. so i followed webistes thing

but i honestly.. it wont dl it's dependencies?

the package is unhappy