that was the one I was originally looking at before we changed the date
2012-11-07 31243, 2012
nikki
(since if it'd been next week, the wednesday flight would have been a lot cheaper than the thursday one)
2012-11-07 31237, 2012
Freso
ruaok: It really does look interesting.
2012-11-07 31208, 2012
Freso
I'll have to keep it in mind if I ever set up hitchhiking down there or otherwise travel to BCN for some other occassion. :)
2012-11-07 31248, 2012
kepstin-laptop
arg, my stupid university wireless is failing again.
2012-11-07 31211, 2012
kepstin-laptop
I can use IRC, but can't reliably send emails or browse the web? it's really weird :(
2012-11-07 31251, 2012
kepstin-laptop stayed in http://www.crashpadchattanooga.com/ once - that was kind of interesting.
2012-11-07 31207, 2012
Bookle
What is the quickest way to get from a recording to it's release group? Currently I go recording->track->tracklist->medium->release->release_group but that seems pretty inefficient...
2012-11-07 31211, 2012
ijabz
bookie i think that is what you have to do
2012-11-07 31253, 2012
Bookle
hmm, well that's unfortunate. thanks
2012-11-07 31248, 2012
reoafk joined the channel
2012-11-07 31226, 2012
Bookle
I guess my real issue is that I can't determine directly from a recording what type it is I have to go to recording group type to find out if it was an interview for example
2012-11-07 31242, 2012
Bookle
release group type*
2012-11-07 31212, 2012
Bookle
which means I have to do 8 joins :/
2012-11-07 31201, 2012
warp
the release group type doesn't really tell you that either.
2012-11-07 31237, 2012
kepstin-laptop
Bookle: remember, a recording can be on multiple releases!
2012-11-07 31245, 2012
kepstin-laptop
so it could be on both an album and a single, for example
2012-11-07 31228, 2012
warp
and you can obviously have track/recording which is an interview on a release with many songs (i.e. not interviews)
2012-11-07 31233, 2012
warp
+a
2012-11-07 31259, 2012
warp
the release group type is meant to describe the release as a whole
2012-11-07 31239, 2012
Bookle
warp: yes, that's the problem - there is nothing that accuraterly describes an individual recording's type
2012-11-07 31247, 2012
ocharles
Bookle: and what is wrong with 8 joins?
2012-11-07 31200, 2012
kepstin-laptop would not be adverse to having recording types - the question is just what goes in them.
2012-11-07 31208, 2012
Bookle
ocharles: amount of time it takes to execute
2012-11-07 31228, 2012
ocharles
Bookle: i don't believe that
2012-11-07 31229, 2012
ocharles
prove it.
2012-11-07 31245, 2012
Bookle
what do you mean?
2012-11-07 31202, 2012
ocharles
I don't believe that 8 joins are inherently slow
2012-11-07 31228, 2012
ocharles
or more, that there is any reason to be alarmed at 8 joins
2012-11-07 31232, 2012
Bookle
kepstin-laptop: well to start with , identify a recording as an interview :)
2012-11-07 31216, 2012
kepstin-laptop
Bookle: I actually wanted them for karaoke recordings, but yeah :)
2012-11-07 31224, 2012
kepstin-laptop
live would also be good
2012-11-07 31209, 2012
Bookle
ocharles: give me a sec and I'll try to pastebin mething... maybe I'm going wrong elsewhere
2012-11-07 31211, 2012
kepstin-laptop
hmm. anyways, should I be bringing a sleeping bag or something with me to the summit?
2012-11-07 31246, 2012
warp
kepstin-laptop: I think a few people will have to bring their sleeping bag, but there hasn't been any coordination as to who is bringing a sleeping bag and who isn't.
2012-11-07 31258, 2012
warp
it also isn't clear to me how many people need to bring a sleeping bag :)
should get all recordings that are linked to a release group with a type of live, interview, or recording
2012-11-07 31214, 2012
kepstin-laptop
Bookle: some recordings aren't linked to any release groups at all :)
2012-11-07 31228, 2012
ocharles
kepstin-laptop: those also lack the information that bookle needs
2012-11-07 31246, 2012
Bookle
but I've had that running for 10 hours or so and no result
2012-11-07 31259, 2012
ocharles
then you should run explain on it and see what the plan is
2012-11-07 31213, 2012
Bookle
kepstin-laptop: yup that's fine
2012-11-07 31238, 2012
ocharles
but note that is going to take a bit of time because you're going to get potentially millions of results (and you haven't made it distinct on recording.id or anything)
2012-11-07 31251, 2012
Freso
kepstin-laptop: I think, if you have room for a sleeping bag, bring it.
2012-11-07 31252, 2012
Bookle
yeah I realized the bit about distinct later, maybe that's the issue
2012-11-07 31200, 2012
Freso
It's better to have one too many, than one too few.
2012-11-07 31207, 2012
ocharles
the distinct will only be slower, probably (because distinct usually means sort & filter all results)
2012-11-07 31219, 2012
ocharles
but run an explain and see what the plan is
2012-11-07 31238, 2012
Bookle
ok
2012-11-07 31227, 2012
Freso
ruaok: Where are you seated Zürich-BCN?
2012-11-07 31233, 2012
Freso is picking seats now
2012-11-07 31252, 2012
Freso
I want to make sure I'm not too close to you.
2012-11-07 31245, 2012
Freso
Nevermind. Seems like there was only one good available seat.
2012-11-07 31246, 2012
ruaok
exit row, window.
2012-11-07 31257, 2012
Freso
<- 21A
2012-11-07 31258, 2012
ruaok
I forget exactly where
2012-11-07 31207, 2012
ruaok
sounds dangerously close to me
2012-11-07 31214, 2012
Freso
Damn.
2012-11-07 31249, 2012
Freso
Looks like my CPH-ZRH will be rather empty, while ZRH-BCN is rather crowded.
2012-11-07 31257, 2012
Freso
So hopefully people won't notice.
2012-11-07 31216, 2012
ruaok sends out the important pick-pocket email
2012-11-07 31216, 2012
reoafk joined the channel
2012-11-07 31209, 2012
warp
ruaok: ah yikes. that is another good reason not to bring any expensive electronics.
