kepstin-laptop has always known them as 'advanced relationships', no matter what the various sites called them :/
2011-09-07 25056, 2011
jessew
hm. we do seem to have a problem here.
2011-09-07 25008, 2011
nikki
kepstin: and what are relationships?
2011-09-07 25029, 2011
kepstin-laptop
nikki: advanced relationships being done by a lazy typist ;)
2011-09-07 25040, 2011
jessew
the advantage to Advanced Relationship (and it's acronym, AR) is it's somewhat more distinctive than the other two alteratives...
2011-09-07 25049, 2011
nikki
kepstin-laptop: nah, lazy people write "ARs" :P
2011-09-07 25059, 2011
kepstin-laptop
well, true.
2011-09-07 25029, 2011
kepstin-laptop
but yeah; relationships just seems like too general of a term.
2011-09-07 25036, 2011
ehrgeiz
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'
2011-09-07 25058, 2011
kepstin-laptop
ehrgeiz: works that aren't in a special category are ones that were performed by that artist.
2011-09-07 25001, 2011
reosarevok
That
2011-09-07 25003, 2011
kepstin-laptop
they really should be labelled as such :/
2011-09-07 25015, 2011
reosarevok
Which, following CSG, are all of them for classical composers
2011-09-07 25018, 2011
reosarevok
Thus the duplication
2011-09-07 25013, 2011
kepstin-laptop
hmm. I guess performed is the wrong work
2011-09-07 25039, 2011
kepstin-laptop
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.
jessew: btw, modpending is actually edits_pending in the database. it seems the diagram needs updating
2011-09-07 25008, 2011
jessew
argh.
2011-09-07 25012, 2011
jessew
Good to know.
2011-09-07 25027, 2011
nikki
link_type and l_*_* also have a last_updated column, link has a created column
2011-09-07 25039, 2011
jessew
nikki: modpending (or edits_pending) -- is my description of what it *does* accurate?
2011-09-07 25021, 2011
ehrgeiz
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?
2011-09-07 25036, 2011
nikki
jessew: it's actually a count of the open edits, so not quite a flag
2011-09-07 25036, 2011
kepstin-laptop
ehrgeiz: exactly.
2011-09-07 25050, 2011
jessew
nikki: I'll correct that.
2011-09-07 25008, 2011
reosarevok
So wait, are we getting stuff documented?
2011-09-07 25010, 2011
reosarevok
Correctly?
2011-09-07 25014, 2011
kepstin-laptop
ehrgeiz: this is particularly useful for songs performed by a band, but written by members of the bad.
2011-09-07 25015, 2011
reosarevok
mind=blown
2011-09-07 25017, 2011
kepstin-laptop
band*
2011-09-07 25033, 2011
nikki
reosarevok: feel free to help :P
2011-09-07 25000, 2011
jessew
reosarevok: well, I wouldn't go so far as to claim *correctness* -- but I hope I'm being at least pleasently imaginative...
2011-09-07 25039, 2011
ehrgeiz
kepstin-laptop: makes sense now, thx. one more reason to change artist credits from composer to performer on recordings.
2011-09-07 25049, 2011
ehrgeiz
for classical
2011-09-07 25050, 2011
reosarevok agrees
2011-09-07 25006, 2011
jessew
is Lukas (the guy who made the diagram) still around -- does he have the graphviz source available?
2011-09-07 25019, 2011
nikki prods luks
2011-09-07 25029, 2011
nikki
I think it's actually some program he wrote himself
2011-09-07 25043, 2011
jessew
hah.
2011-09-07 25057, 2011
jessew
luks: please do update the diagram
2011-09-07 25027, 2011
jessew
nikki: so, what is the link_attribute table do, exactly?
2011-09-07 25021, 2011
nikki
relationships can have multiple attributes. so guest performed violin would have one row in 'link' and two rows in 'link_attribute'
2011-09-07 25028, 2011
jessew
I should really just download a copy of the database and poke around myself...
2011-09-07 25049, 2011
nikki
that's how I learnt everything I know about it :)
2011-09-07 25017, 2011
ehrgeiz is hooked to ebay again :/
2011-09-07 25024, 2011
reosarevok
:p
2011-09-07 25035, 2011
reosarevok bought 6 Spongebob plushes last time that happened
2011-09-07 25008, 2011
ehrgeiz wants some 70-80 stereo amp :3
2011-09-07 25002, 2011
murdos joined the channel
2011-09-07 25017, 2011
ocharles joined the channel
2011-09-07 25040, 2011
_bibi joined the channel
2011-09-07 25043, 2011
Leftmost joined the channel
2011-09-07 25056, 2011
CatCat
RARG
2011-09-07 25051, 2011
CatCat
i can't get wine to work on on ubuntu karmic 9.10.. it wont dl
2011-09-07 25013, 2011
CatCat
it keeps crying about dependencies. so i followed webistes thing
