reosarevok remembers somewhere in the page 1965-12-03 sorts before 1965
2011-07-01 18239, 2011
reosarevok
Label releases, can it be?
2011-07-01 18207, 2011
ocharles
the page bitmap links to sorts like that
2011-07-01 18211, 2011
ocharles
but I'm not talking about the page sorting
2011-07-01 18221, 2011
reosarevok
Yeah, sure
2011-07-01 18227, 2011
reosarevok just wonders if it should be consistent
2011-07-01 18246, 2011
bitmap
well, I prefer sorting the more-specific dates first, because a lot of times the original date is known, and the less-specific ones are just slightly later issues in other countries around the same time...
2011-07-01 18227, 2011
reosarevok
Speaking of dates
2011-07-01 18251, 2011
ocharles nods
2011-07-01 18257, 2011
reosarevok
The "age" thing assumes January if no month is given
adhawkins: potentially you might kill off the version 2.x entirely, since the RDF web service doesn't even exist anymore
2011-07-01 18231, 2011
ianmcorvidae
(on that page, specifically)
2011-07-01 18243, 2011
adhawkins
Oh ok, I'll edit the Wiki to that effect.
2011-07-01 18252, 2011
ianmcorvidae joined the channel
2011-07-01 18242, 2011
ianmcorvidae
hm
2011-07-01 18231, 2011
reosarevok
ianmcorvidae: I seem to hear that a lot lately
2011-07-01 18241, 2011
reosarevok wonders if Opera is made in perl
2011-07-01 18220, 2011
ianmcorvidae
don't think so
2011-07-01 18232, 2011
reosarevok
So they are just breaking things separately
2011-07-01 18235, 2011
reosarevok
How evil of them
2011-07-01 18204, 2011
ianmcorvidae
heh
2011-07-01 18223, 2011
ianmcorvidae
for mine it's probably Arch Linux that's to blame
2011-07-01 18227, 2011
ianmcorvidae
super-new perl and all
2011-07-01 18233, 2011
ianmcorvidae
5.14.1
2011-07-01 18210, 2011
ianmcorvidae
bleh
2011-07-01 18212, 2011
ianmcorvidae
can't run anything
2011-07-01 18249, 2011
warp
nothing at all!
2011-07-01 18206, 2011
reosarevok
Not even 100m?
2011-07-01 18239, 2011
ianmcorvidae
lol
2011-07-01 18253, 2011
ianmcorvidae
well, some stuff is working, even though it's perl
2011-07-01 18203, 2011
ianmcorvidae
but e.g. cpan{m,p,} aren't working
2011-07-01 18208, 2011
ianmcorvidae
and certainly none of the mb_server anything
2011-07-01 18230, 2011
warp is currently on Ubuntu :S
2011-07-01 18246, 2011
ianmcorvidae deleted the directory of local::lib perl stuff, is reinstalling it all
2011-07-01 18204, 2011
ianmcorvidae
(it's now working, apparently it was trying to load something from there that was breaking it)
2011-07-01 18209, 2011
adhawkins joined the channel
2011-07-01 18233, 2011
ianmcorvidae
note for whoever might care: Data::Dumper::Concise and DateTime::Format::Natural should be added to Makefile.PL
2011-07-01 18255, 2011
ianmcorvidae
er, hm
2011-07-01 18201, 2011
ianmcorvidae
cpanm is missing them
2011-07-01 18202, 2011
ianmcorvidae
odd
2011-07-01 18212, 2011
ianmcorvidae
well, at least DateTime::Format::Natural
2011-07-01 18258, 2011
ianmcorvidae
anyway, yay, after a couple manual installs I'm back to having a working mb_server
2011-07-01 18244, 2011
bitmap joined the channel
2011-07-01 18248, 2011
adhawkins hopes it's quiet because everyone is trying out the new libmb4!
2011-07-01 18219, 2011
ianmcorvidae
sorry to say not with me, I'm playing with SQL
2011-07-01 18227, 2011
reosarevok
adhawkins: no, it's quiet because ianmcorvidae and warp have been talking their weird coding wizardness in #musicbrainz instead
2011-07-01 18212, 2011
ianmcorvidae
reosarevok: just wait until I show you the SQL query for how many releases a given instrument is used on :P
2011-07-01 18211, 2011
adhawkins doesn't really 'do' SQL
2011-07-01 18215, 2011
adhawkins
I know enough to get by.
2011-07-01 18228, 2011
adhawkins
As long as the word 'join' isn't involved :)
2011-07-01 18234, 2011
ianmcorvidae
I'm learning a lot at the moment; this is by far the most complicated query I've had to try to do
2011-07-01 18256, 2011
ianmcorvidae
(well, 'had to' is stretching it, I'm doing this for fun, but XD)
2011-07-01 18257, 2011
luks
that wouldn't get you too far in the musicbrainz database :)
2011-07-01 18203, 2011
reosarevok
ianmcorvidae: you could show me a haiku book and tell me it's an SQL query and I'd believe you
2011-07-01 18208, 2011
ianmcorvidae
haha
2011-07-01 18211, 2011
adhawkins
lol
2011-07-01 18211, 2011
reosarevok
(well, ok, maybe not, but I'd be close)
2011-07-01 18220, 2011
reosarevok wonders how many programming languages have been done for fun that imitate haikus
2011-07-01 18219, 2011
reosarevok_ joined the channel
2011-07-01 18238, 2011
nikki joined the channel
2011-07-01 18243, 2011
ianmcorvidae
huh, instrument can be used on one recording-release AR
2011-07-01 18224, 2011
ianmcorvidae
apparently also artist-artist, but that one I can at least just ignore
2011-07-01 18237, 2011
reosarevok
ianmcorvidae: not only it can
2011-07-01 18245, 2011
reosarevok
But I'd imagine that's as common as the other option
2011-07-01 18219, 2011
reosarevok
(as if the record says "drums: X" to add it to every track you would theoretically need to check that all have drums, and if it says "drums: X and Y" you're screwed)
2011-07-01 18219, 2011
ianmcorvidae
well, the only recording-release one is 'samples material'
2011-07-01 18200, 2011
ianmcorvidae
I figured most would be artist-recording or artist-release ARs
2011-07-01 18208, 2011
ianmcorvidae
which is I suppose true still, but
2011-07-01 18240, 2011
reosarevok
Ooh
2011-07-01 18241, 2011
reosarevok
Pfft
2011-07-01 18246, 2011
reosarevok read "artist release"
2011-07-01 18250, 2011
ianmcorvidae
ah
2011-07-01 18253, 2011
reosarevok
Yeah, the samples one
2011-07-01 18255, 2011
ianmcorvidae
yeah, that one's not surprising
2011-07-01 18200, 2011
reosarevok
Really uncommon, I imagine
2011-07-01 18205, 2011
reosarevok
But well, you're the statistics guy
2011-07-01 18209, 2011
reosarevok
:p
2011-07-01 18220, 2011
ianmcorvidae
haha
2011-07-01 18259, 2011
ianmcorvidae
151 of them that actually have an instrument set, looks like
2011-07-01 18223, 2011
reosarevok
So almost none
2011-07-01 18225, 2011
ianmcorvidae
no
2011-07-01 18226, 2011
reosarevok
And yet more than I expected
2011-07-01 18228, 2011
ianmcorvidae
got it wrong
2011-07-01 18206, 2011
reosarevok
Aww
2011-07-01 18216, 2011
reosarevok
If we can't even trust the statistics guy, what's left?
2011-07-01 18219, 2011
reosarevok
Oh, wait
2011-07-01 18226, 2011
reosarevok
:)
2011-07-01 18236, 2011
ianmcorvidae
okay
2011-07-01 18245, 2011
ianmcorvidae
looks like there are _4_ of those
2011-07-01 18246, 2011
ianmcorvidae
:P
2011-07-01 18208, 2011
reosarevok
Oooh
2011-07-01 18217, 2011
reosarevok
That's closer to the expected result
2011-07-01 18226, 2011
reosarevok thought they were breeding like dinos in Jurassic Park
nikki wonders how much work it would be to change the schema to allow multiple packaging options (even if we don't fix the interface to allow multiple ones just yet)
nikki: In the schema we'd probably remove the packaging column from the release table and add a release column to the release_packaging table.
2011-07-01 18219, 2011
ianmcorvidae
(SQL: WITH links_and_attributes AS (SELECT link_attribute_type.id AS attribute_type, link_attribute.link AS link FROM link_attribute RIGHT OUTER JOIN link_attribute_type ON link_attribute.attribute_type = link_attribute_type.id WHERE link_attribute_type.root = 14) SELECT link_attribute_type.name from links_and_attributes INNER JOIN link_attribute_type ON links_and_attributes.attribute_type = link_attribute_type.id where links_and
2011-07-01 18252, 2011
warp
nikki: it doesn't sound too invasive, but the way our querying is set up I do think quite a few perl files would have to be changed.
2011-07-01 18201, 2011
nikki
warp: release_packaging is the actual list of packaging, I guess it'd need a separate table (or rename release_packaging to packaging and then use release_packaging as you suggested)
