Leftmost is still waiting on the async/await proposal to get to stage 4. :-P
2016-07-02 18405, 2016
LordSputnik
QuoraUK: yeah sure, let's talk achievements :)
2016-07-02 18407, 2016
navap joined the channel
2016-07-02 18413, 2016
QuoraUK
with the merge from title hover to creation time?
2016-07-02 18415, 2016
LordSputnik
Leftmost: everything will be better in ES<X>
2016-07-02 18442, 2016
QuoraUK
OK, the simpler one: for explorer, would an extra field on a profile for viewed entities work?
2016-07-02 18447, 2016
LordSputnik
QuoraUK: oh are they in separate branches? I just looked at the creation time branch and saw the title commits so I thought you'd done them on the same one
2016-07-02 18418, 2016
QuoraUK
they are, I merge title hover into creation time though, that was probably a mistake
2016-07-02 18453, 2016
LordSputnik
Maybe not - sometimes it's necessary to do that
2016-07-02 18432, 2016
QuoraUK
ahh ok fair enough
2016-07-02 18459, 2016
LordSputnik
Hmm, explorer is difficult
2016-07-02 18420, 2016
LordSputnik
You'd probably need another table
2016-07-02 18435, 2016
LordSputnik
editor_entity_visits or something similar
2016-07-02 18436, 2016
QuoraUK
for an entire history of every entity viewed?
2016-07-02 18450, 2016
LordSputnik
And that would store pairs of editor, entity bbid values
2016-07-02 18418, 2016
LordSputnik
Then you'd want to get a count of the number of rows for each editor, and that'd give you the info you need
2016-07-02 18457, 2016
QuoraUK
ok, that sounds pretty simple
2016-07-02 18409, 2016
LordSputnik
I'd say put an underscore in front of that table name though, since unlike all the other tables in the schema, it's something that's only really useful internally, and not really part of the data we're aiming to store
2016-07-02 18420, 2016
QuoraUK
alright, will do
2016-07-02 18427, 2016
LordSputnik
Then we can also leave the table out of dumps
2016-07-02 18432, 2016
LordSputnik
(maybe)
2016-07-02 18439, 2016
QuoraUK
I'd perhaps recommend that
2016-07-02 18405, 2016
QuoraUK
user history isn't something i'd recommend distributing :P
2016-07-02 18445, 2016
LordSputnik
We can also delete all the rows in the table for each editor once they reach each level of the achievement
2016-07-02 18409, 2016
LordSputnik
Then they need 90 in the table and I to get to II, and 900 in the table and II to get III
2016-07-02 18420, 2016
LordSputnik
That'll help keep the table small
2016-07-02 18441, 2016
QuoraUK
Possibly, It would require a different award method than the one that im using for everything else, but its worth a shot
2016-07-02 18449, 2016
QuoraUK
limits the amound of data we would need to keep
2016-07-02 18414, 2016
QuoraUK
ok, so recruiter
2016-07-02 18449, 2016
QuoraUK
I mentioned it before, and ZaphodBeeblebrox referred to it as old school sharing(TM) I believe :P
2016-07-02 18411, 2016
QuoraUK
I was thinking an elasticsearch of names, you could select someone who referred you if you want
2016-07-02 18419, 2016
ZaphodBeeblebrox
:D
2016-07-02 18450, 2016
Freso|koume doesn't much like the idea of referrals, but can't substantiate it
2016-07-02 18432, 2016
LordSputnik
I'd prefer using a URL code method
2016-07-02 18444, 2016
LordSputnik
Get people to sign up using a link with your username or editor ID in it
2016-07-02 18456, 2016
QuoraUK
That was what I was planning for Marketer,
2016-07-02 18456, 2016
LordSputnik
Then there's no need for them to do any selecting
2016-07-02 18400, 2016
QuoraUK
I could use a similar method
2016-07-02 18418, 2016
LordSputnik
Yeah, so we can use the same method for both, the different being one is page views, the other is users
2016-07-02 18436, 2016
QuoraUK
perhaps if they end up on the website with your link, keep the id with them, if they register, also award the achievement
2016-07-02 18445, 2016
ZaphodBeeblebrox
one gets a refferal link and thats the one one usesto link peopel to it :) that's how it used ot be anyway
2016-07-02 18410, 2016
Leftmost
What exactly is Marketer?
2016-07-02 18421, 2016
LordSputnik
Leftmost: get X people to visit the site
2016-07-02 18421, 2016
QuoraUK
Have someone use your link to a BB entity
2016-07-02 18435, 2016
QuoraUK
it has potential to be skeezy
2016-07-02 18448, 2016
QuoraUK
thats probably the most spooky one
2016-07-02 18448, 2016
ZaphodBeeblebrox
spammy
2016-07-02 18417, 2016
LordSputnik
OK, so maybe we could do that with sessions
2016-07-02 18432, 2016
Leftmost
I'm not sure I like the notion of passing around URLs to data on a data-oriented site with gamification bits in it, but it's less of an issue for referral links since that's administrative.
2016-07-02 18437, 2016
LordSputnik
If there's a referrer ID in the initial URL, increment the referrals count for the user and store it in the session. When the user registers, check the session for a referrer ID, or check the URL for it, and apply that to the recruiter achievement too
2016-07-02 18457, 2016
LordSputnik
On a side note: we should add a cookie warning somewhere out of the way
2016-07-02 18407, 2016
ZaphodBeeblebrox
ugh why?
2016-07-02 18417, 2016
QuoraUK
I believe its the law
2016-07-02 18425, 2016
QuoraUK
in the EU perhaps
2016-07-02 18450, 2016
QuoraUK
Leftmost: yeah, I see your point
2016-07-02 18455, 2016
ZaphodBeeblebrox
as longas it's in the footer like "this site uses cookies" and no need for an affirmative vutton click
2016-07-02 18408, 2016
ZaphodBeeblebrox
does mb even have that?
2016-07-02 18420, 2016
LordSputnik
ZaphodBeeblebrox: something like that - implicit agreement through use of the site
2016-07-02 18436, 2016
LordSputnik
But you'll need to close the warning if you want it to go away, to ensure that there's no chance of missing it
2016-07-02 18441, 2016
QuoraUK
I believe you need consent
2016-07-02 18446, 2016
QuoraUK
yeah
2016-07-02 18450, 2016
ZaphodBeeblebrox
<LordSputnik> how about no
2016-07-02 18457, 2016
ZaphodBeeblebrox
seriously
2016-07-02 18458, 2016
ZaphodBeeblebrox
no
2016-07-02 18407, 2016
ZaphodBeeblebrox
I only block those
2016-07-02 18422, 2016
ZaphodBeeblebrox
agiak mb doesn't have one of those
2016-07-02 18423, 2016
LordSputnik
ZaphodBeeblebrox: it's illegal not to
2016-07-02 18427, 2016
LordSputnik
MB should have one of those
2016-07-02 18437, 2016
ZaphodBeeblebrox
nobody cares abotu cookies
2016-07-02 18447, 2016
ZaphodBeeblebrox
saying the site uses thme is fien (andi agree)
2016-07-02 18407, 2016
ZaphodBeeblebrox
but having a "contiue using this lah blah cookies" blah is Soooooooooooooooooooooooooooooooooooooooooooooooooooooo
2016-07-02 18407, 2016
ZaphodBeeblebrox
oooooooooooooooooooo annoying
2016-07-02 18414, 2016
LordSputnik
The law is that sites that target EU audiences must notify users that they use cookies and obtain consent from the user
2016-07-02 18416, 2016
ZaphodBeeblebrox
ugh
2016-07-02 18433, 2016
ZaphodBeeblebrox
wait. i'm not in the eu
2016-07-02 18441, 2016
Freso|koume
I am.
2016-07-02 18447, 2016
Freso|koume
LordSputnik is (still).
2016-07-02 18452, 2016
ZaphodBeeblebrox
and theier is the uk now. so.. don't explicitly target any non-englsih countries?? :d
2016-07-02 18452, 2016
ZaphodBeeblebrox
ok ok i kid i kid
2016-07-02 18459, 2016
ZaphodBeeblebrox
but i stil lthink it's hella dumb :/ sih
2016-07-02 18401, 2016
QuoraUK
I am :P
2016-07-02 18415, 2016
Freso|koume
QuoraUK again: still. :)
2016-07-02 18416, 2016
LordSputnik
It's a stupid law, for sure
2016-07-02 18416, 2016
Leftmost
Given that MB was previously hosted in the US, it wasn't legally required, but if it's going to be hosted in the EU it likely will be.
2016-07-02 18436, 2016
ZaphodBeeblebrox
lame
2016-07-02 18436, 2016
Freso|koume
I don't think anyone in here disagrees with it being a stupid law.
2016-07-02 18443, 2016
LordSputnik
Leftmost: according to what I just read, it's not solely about hosting
2016-07-02 18445, 2016
ZaphodBeeblebrox
atleast make it funny and ironic
2016-07-02 18403, 2016
ZaphodBeeblebrox
like "ugh we know this is dumb, but it's the law, jsut click her eand you'll never see tihs again" :P
2016-07-02 18404, 2016
Leftmost
LordSputnik, it'd be unenforceable for a non-EU hosted site.
2016-07-02 18422, 2016
JesseW has quit
2016-07-02 18427, 2016
Leftmost
(I was still wrong in that case, but oh well.)
2016-07-02 18439, 2016
LordSputnik
Hmm, but apparently you don't need to obtain consent for some cookies
I didn't know about those exceptions, I guess it mainly targets tracking cookies
2016-07-02 18413, 2016
Leftmost
I think a MeB-wide policy is in order, and we can just comply with that (and the styling).
2016-07-02 18436, 2016
LordSputnik
Yup
2016-07-02 18447, 2016
TOPIC: MetaBrainz Community and Development channel | MusicBrainz non-development: #musicbrainz | MeB meeting agenda: Reviews, EU cookies (Freso/BB team)
2016-07-02 18414, 2016
LordSputnik
OK, QuoraUK, we've covered Explorer and Recruiter now, I think, what's next?
2016-07-02 18419, 2016
QuoraUK
ok, so should I leave marketer to another week?
2016-07-02 18432, 2016
Freso|koume
But I think there's a difference between storing a session-id for logged in users and storing a referrer id.
2016-07-02 18447, 2016
ZaphodBeeblebrox
I'd love to have a siteup where I can look at and test these.. do you have an eta on that is?
2016-07-02 18456, 2016
ZaphodBeeblebrox
also badges, thei mage illustration?
2016-07-02 18422, 2016
QuoraUK
hmm, I could potentailly run in on my server, But it would take me a while to set up
2016-07-02 18441, 2016
ZaphodBeeblebrox
ah, don't midn it if it's a hassle
2016-07-02 18443, 2016
Leftmost
Marketer may be impractical without horning in on data collection's territory.
2016-07-02 18445, 2016
LordSputnik
ZaphodBeeblebrox: if rika were around ,we could :/
