the thing that was a massive game changer re BigQuery was that public data sets are hosted FOR FREE
2015-11-09 31317, 2015
ruaok_
querying the data costs, but everyone gets 5TB/month free.
2015-11-09 31333, 2015
ruaok_
for size of our "small potatoes" data, that could be a decent amount
2015-11-09 31348, 2015
ruaok_
but the best part of that we dont have to setep our own hadoop cluster.
2015-11-09 31307, 2015
ruaok_
and with maybe 20 lines of python we can stream LB data straight to bigquery.
2015-11-09 31324, 2015
ruaok_
and then everyone and anyone can start writing queries and use google scale stuff.
2015-11-09 31331, 2015
ruaok_
this is super exciting, really.
2015-11-09 31353, 2015
ruaok_
because it allows us to grow out "small potatoes big data" projects faster than having to install our own stuff.
2015-11-09 31300, 2015
ruaok_
*our
2015-11-09 31316, 2015
ruaok_
so, super excited.
2015-11-09 31332, 2015
ruaok_
also way over socialized and I have nothing but socializing to do for the next 3 days.
2015-11-09 31337, 2015
ruaok_
what could go wrong. :)
2015-11-09 31340, 2015
ruaok_
fin!
2015-11-09 31352, 2015
Freso
Neat.
2015-11-09 31358, 2015
Freso
Leftmost, go.
2015-11-09 31307, 2015
Leftmost
I've been working on sorting out the edit search speed stuff and doing due diligence on partitioning.
2015-11-09 31313, 2015
Freso
(bitmap didn't clock in yet, right?)
2015-11-09 31339, 2015
Leftmost
Sadly, it looks like partitioning won't get us much benefit, as we can't guarantee that any given query will only be looking at some subset of partitions, which is where the biggest performance benefits come in.
2015-11-09 31351, 2015
ruaok_ hasn't heard from bitmap to day
2015-11-09 31359, 2015
regagain has quit
2015-11-09 31331, 2015
Leftmost
There's something small to be gained in terms of physical proximity, but that doesn't seem to be applicable, since everything is stored in roughly the same order it's created.
2015-11-09 31304, 2015
Leftmost
From talking to #postgresql, though, physical proximity is our issue, just not one I have an immediate solution for.
2015-11-09 31345, 2015
Freso
And neither do they?
2015-11-09 31312, 2015
Leftmost
No, but I'm keeping an ongoing dialogue with them to try to get it worked out.
2015-11-09 31333, 2015
Freso
Cool.
2015-11-09 31341, 2015
Leftmost
I've been able to get some improvement in query speed for collection edits, but it's going to be a process.
2015-11-09 31343, 2015
Leftmost
That's it for me.
2015-11-09 31315, 2015
Freso
alastairp? bitmap? LordSputnik? Anyone else?
2015-11-09 31348, 2015
Freso
Guess not then.
2015-11-09 31350, 2015
Freso
Onwards!
2015-11-09 31355, 2015
Freso
reosarevok!
2015-11-09 31305, 2015
Freso
Enough with the house cleaning, you're in a meeting.
2015-11-09 31309, 2015
reosarevok
:p
2015-11-09 31316, 2015
Freso
The mess will still be there afterwards.
2015-11-09 31327, 2015
reosarevok
(they're showing the house tomorrow morning hence making sure it's showable! :p)
2015-11-09 31327, 2015
reosarevok
So
2015-11-09 31335, 2015
TOPIC: MetaBrainz Community and Development channel | MusicBrainz non-development: #musicbrainz | MeB meeting agenda: CAA-84 requirements (reo), data quality icons (reo)
And I was like "huh yeah I should find out if we can work on that or not"
2015-11-09 31308, 2015
reosarevok
(that is, whether we need IA time or just MB time)
2015-11-09 31324, 2015
reosarevok
ruaok_ mentioned earlier that it could just be MB time, depending on how we want to do it
2015-11-09 31310, 2015
reosarevok
So we should think about what we want from this
2015-11-09 31313, 2015
reosarevok
"<ruaok> If we make it another type in case, then cake."
2015-11-09 31325, 2015
reosarevok
Can it fit inside CAA or does it need to be a different project?
2015-11-09 31332, 2015
zas
Leftmost: 64MB
2015-11-09 31353, 2015
Leftmost
Thanks.
2015-11-09 31355, 2015
reosarevok
CallerNo6 mentioned that posters and the like are more likely to be something designers complain about than cover art, since they are sold separately sometimes
2015-11-09 31322, 2015
reosarevok
So we should make sure with the IA they're also fine with us throwing that at them
2015-11-09 31345, 2015
reosarevok
But apart from that, does "add event to the CAA" seem reasonable as a way to do this?
2015-11-09 31356, 2015
Freso
I feel like they should be their own project. Maybe ping the IA and hear how long a wait that would likely entail?
2015-11-09 31356, 2015
reosarevok
Or do people think we need to do something fancier?
2015-11-09 31316, 2015
Freso
I think it's fine to bundle it with CAA, but maybe not go to the same image repository?
2015-11-09 31319, 2015
Freso
I don't know.
2015-11-09 31342, 2015
reosarevok
Ok, so get in touch with the IA and check on the idea first. Seems reasonable
2015-11-09 31306, 2015
Freso
!next?
2015-11-09 31315, 2015
reosarevok
Since I kinda have the contacts (even though I haven't talked to anyone there in a year or so, hope they're still on that skype chat...) I guess I can add that to my list of tasks
2015-11-09 31319, 2015
reosarevok
I guess next!
2015-11-09 31324, 2015
Freso
!next
2015-11-09 31326, 2015
Freso
reosarevok!
2015-11-09 31332, 2015
Freso
Enough with the house cleaning, you're in a meeting.
2015-11-09 31338, 2015
Freso
:U
2015-11-09 31355, 2015
TOPIC: MetaBrainz Community and Development channel | MusicBrainz non-development: #musicbrainz | MeB meeting agenda: data quality icons (reo)
2015-11-09 31301, 2015
reosarevok
:D
2015-11-09 31305, 2015
reosarevok slaps Freso with a carrot
2015-11-09 31312, 2015
reosarevok
Anyway
2015-11-09 31331, 2015
reosarevok
I was thinking I really want a way to see what I have properly cleaned up and what I still need to fix when looking at a composer
2015-11-09 31342, 2015
reosarevok
That takes me back to data quality (which, I know, nobody is using right now)
2015-11-09 31318, 2015
reosarevok
I was thinking: if I could look at a release list and see a small happy face (or something) by the ones that have been fixed properly, and maybe a sad face (or something else) by the ones which we know suck ass, that'd make it easier
2015-11-09 31336, 2015
reosarevok
(and data quality actually showing somewhere useful might even make other people use it)
2015-11-09 31348, 2015
reosarevok
Then I heard that someone wanted things teenagers could do
2015-11-09 31303, 2015
reosarevok
So I thought maybe teenagers could design us some icons and then we could show them like that :p
2015-11-09 31319, 2015
reosarevok
Does that sound like annoying clutter to others?
2015-11-09 31323, 2015
Freso
GCI task?
2015-11-09 31329, 2015
reosarevok
Or like something that might make sense?
2015-11-09 31345, 2015
reosarevok
Yes I didn't mean just random teenagers off the street, Freso :p
2015-11-09 31351, 2015
reosarevok
Sorry, I'll be more obvious next time :p
2015-11-09 31357, 2015
Freso
That'd've been fun though.
2015-11-09 31315, 2015
reosarevok
Twitch Designs MusicBrainz Logos
2015-11-09 31319, 2015
reosarevok
(no)
2015-11-09 31336, 2015
reosarevok
Anyway. Basically my main question is "will anyone shout if we show more icons?"
2015-11-09 31348, 2015
reosarevok
(I guess "if yes, can we make it a preference and still add icons?" :p
2015-11-09 31349, 2015
reosarevok
)
2015-11-09 31352, 2015
Freso won't, but someone probably will
2015-11-09 31321, 2015
reosarevok
When checking if there was a ticket for this I found several other icon-related tickets that might fit GCI, btw
2015-11-09 31332, 2015
CallerNo6
you can always turn them off in css, can't you?
2015-11-09 31335, 2015
reosarevok
We can take a quick look after the meeting
2015-11-09 31352, 2015
reosarevok
CallerNo6: probably but I'd rather have a real option if more than one or two people hate them :)
2015-11-09 31341, 2015
CallerNo6
sure. so maybe something like an MBUI userscript?
2015-11-09 31307, 2015
reosarevok
You mean to show them or to not show them?
2015-11-09 31347, 2015
CallerNo6 will shut up now and try to think it through
2015-11-09 31326, 2015
reosarevok
Ok. I'll add a ticket for it, but you can comment on it and be like NOPE. if you hate it :p
2015-11-09 31328, 2015
ruaok_
oh, quick OT: The birth certificate I requested for Taio Cruz was not found. which suggests that the birth certificate sent to us was a fake.
2015-11-09 31339, 2015
reosarevok
:D
2015-11-09 31342, 2015
reosarevok
Really?
2015-11-09 31344, 2015
CallerNo6
lol
2015-11-09 31309, 2015
ruaok_
I provided the details as given on the birth cert to her majesty's gubmint and asked for a copy.
2015-11-09 31311, 2015
ruaok_
404
2015-11-09 31325, 2015
ruaok_
so, *something* is wrong with that.
2015-11-09 31338, 2015
Freso
So next step?
2015-11-09 31347, 2015
Freso
Sending it to the popo?
2015-11-09 31353, 2015
ruaok_
blog post. comment on wikipedia talk page.
2015-11-09 31358, 2015
ruaok_
send to met police.
2015-11-09 31303, 2015
Freso
Nice.
2015-11-09 31315, 2015
CallerNo6
haha. don't mess with archivists.
2015-11-09 31316, 2015
Freso
(Better the met police than the meth police, I guess.)
2015-11-09 31325, 2015
ruaok_
lol to both. :)
2015-11-09 31329, 2015
zas
;)
2015-11-09 31331, 2015
ruaok_
CallerNo6: seriously, this pisses me off.
2015-11-09 31339, 2015
ruaok_
ok, time to run.
2015-11-09 31344, 2015
ruaok_
will still be available on mobile
2015-11-09 31348, 2015
ruaok_ has quit
2015-11-09 31304, 2015
Freso
Adeus!
2015-11-09 31316, 2015
chirlu` wonders who Taio Cruz is or pretends to be.
2015-11-09 31327, 2015
Freso
Also, I think that about wraps up the meeting.
2015-11-09 31335, 2015
Freso
Thanks for not throwing too many carrots around!
2015-11-09 31341, 2015
Freso
</BANG>
2015-11-09 31351, 2015
Leftmost throws a parsnip at Freso.
2015-11-09 31355, 2015
Gentlecat
💥
2015-11-09 31308, 2015
TOPIC: MetaBrainz Community and Development channel | MusicBrainz non-development: #musicbrainz | MeB meeting agenda: Reviews
2015-11-09 31316, 2015
CallerNo6
oh, so reosarevok: I'm going to make a ticket about "user edited" cover art. file it under style or caa?
2015-11-09 31334, 2015
reosarevok
New types? Style
2015-11-09 31346, 2015
Leftmost
I'm with chirlu`. What's this whole Taio Cruz thingymajig?
2015-11-09 31335, 2015
reosarevok
Someone who writes like a fancypants lawyer wrote to us
ruaok: You really should just go and request getting your WP username changed to RobKaye, ruaok, Mayhem(BCN), or whatever...
2015-11-09 31323, 2015
ruaok
Yeah, will do before following up.
2015-11-09 31347, 2015
ruaok
Will also talk to wm people about this taio biz.
2015-11-09 31328, 2015
regagain joined the channel
2015-11-09 31317, 2015
reosarevok
Freso: I'm adding some icon-related MBS tickets to your page
2015-11-09 31327, 2015
reosarevok
Please take a look afterwards and see if you agree they could fit
2015-11-09 31331, 2015
Leftmost
People get into arguments over the weirdest things.
2015-11-09 31333, 2015
ruaok
Oh! I forgot.
2015-11-09 31344, 2015
ruaok
We can skip using layer.
2015-11-09 31300, 2015
ruaok
Xmpp will do all we need. Fully open source.
2015-11-09 31314, 2015
ruaok
And arc Riley, and xmpp fan is helping us.
2015-11-09 31321, 2015
ruaok
*an
2015-11-09 31334, 2015
Leftmost
Ooh, XMPP.
2015-11-09 31301, 2015
ruaok
Gentlecat: so, we need to review the tickets related to mbs-1801
2015-11-09 31311, 2015
chirlu`
Leftmost: I donÂ’t think the edit search performance issue in the general case can be solved as long as the planner does dumb things, such as assign a selectivity of 0.5 to IN clauses, and wonÂ’t take hints.
2015-11-09 31325, 2015
Gentlecat
ruaok: ok
2015-11-09 31337, 2015
chirlu`
(Hints to override the default selectivity.)
2015-11-09 31301, 2015
Gentlecat
how is this going to work?
2015-11-09 31315, 2015
Freso
XMPP = <3
2015-11-09 31317, 2015
Freso has been touting XMPP for in-site messaging a couple of times now - not disappointed it it becomes so :)