#metabrainz

/

      • LordSputnik has quit
      • 2015-10-31 30405, 2015

      • LordSputnik joined the channel
      • 2015-10-31 30450, 2015

      • alastairp
        hi. I might wander in after lunch
      • 2015-10-31 30411, 2015

      • diana_olhovik joined the channel
      • 2015-10-31 30408, 2015

      • ruaok has quit
      • 2015-10-31 30438, 2015

      • ruaok joined the channel
      • 2015-10-31 30432, 2015

      • jcazevedo has quit
      • 2015-10-31 30424, 2015

      • LordSputnik
      • 2015-10-31 30434, 2015

      • LordSputnik
        ^ we could do that in MB
      • 2015-10-31 30417, 2015

      • Freso
        Gentlecat: ^
      • 2015-10-31 30423, 2015

      • Freso
        Use that instead. :p
      • 2015-10-31 30449, 2015

      • chirlu`
        SELECT type, COUNT(*) FROM edit WHERE status = 1 GROUP BY type ORDER BY COUNT(*) DESC;
      • 2015-10-31 30454, 2015

      • chirlu`
        bitmap ^
      • 2015-10-31 30412, 2015

      • Gentlecat
        Freso: what do you mean?
      • 2015-10-31 30441, 2015

      • Leftmost
      • 2015-10-31 30427, 2015

      • bitmap
        https://pastee.org/954ue ^ chirlu`'s query
      • 2015-10-31 30440, 2015

      • Freso
        Gentlecat: That link allows you to edit the document directly, doesn't it?
      • 2015-10-31 30400, 2015

      • Gentlecat
        only allows me to suggest
      • 2015-10-31 30410, 2015

      • Freso
        Huh.
      • 2015-10-31 30452, 2015

      • Gentlecat
        Freso: works now, thanks
      • 2015-10-31 30427, 2015

      • bitmap
        reosarevok: 90 is $EDIT_RELATIONSHIP_CREATE
      • 2015-10-31 30402, 2015

      • chirlu`
        314 is Add cover art.
      • 2015-10-31 30428, 2015

      • chirlu`
        The next are Add release, Add release label.
      • 2015-10-31 30401, 2015

      • LordSputnik has quit
      • 2015-10-31 30438, 2015

      • LordSputnik joined the channel
      • 2015-10-31 30446, 2015

      • zas-mb has quit
      • 2015-10-31 30446, 2015

      • LordSputnik
      • 2015-10-31 30448, 2015

      • LordSputnik
        :P another issue BB has got sorted
      • 2015-10-31 30453, 2015

      • LordSputnik
        (metrics)
      • 2015-10-31 30422, 2015

      • Freso
        What are 31 and 34?
      • 2015-10-31 30430, 2015

      • Freso
        That'd be all the ones >1000.
      • 2015-10-31 30459, 2015

      • Freso
        With 32 and 53, it'd be all the ones >500.
      • 2015-10-31 30421, 2015

      • Freso
        (And the entire top 10.)
      • 2015-10-31 30434, 2015

      • Freso
        Eh, no. Just the first 10 lines. My bad.
      • 2015-10-31 30412, 2015

      • LordSputnik
        could check if the cover art is already in CAA maybe?
      • 2015-10-31 30410, 2015

      • Freso
        /query Leftmost
      • 2015-10-31 30412, 2015

      • Freso
        ...
      • 2015-10-31 30454, 2015

      • chirlu`
        SELECT extract_path_value(edit.data, 'link_type/id') AS rt, link_type.link_phrase, edit.status, COUNT(*) FROM edit, link_type WHERE edit.type = 90 AND extract_path_value(edit.data, 'link_type/id')::int = link_type.id AND edit.id BETWEEN 33000000 AND 34000000 GROUP BY rt, link_type.link_phrase, edit.status;
      • 2015-10-31 30408, 2015

      • chirlu`
        bitmap ^ (untested, but compiles)
      • 2015-10-31 30433, 2015

      • regagain joined the channel
      • 2015-10-31 30448, 2015

      • chirlu`
        bitmap, new attempt with a CTE and a smaller sample: WITH foo AS (SELECT extract_path_value(edit.data, 'link_type/id')::int AS rt, edit.status FROM edit WHERE edit.type = 90 AND edit.id BETWEEN 33900000 AND 34000000) SELECT foo.rt, link_type.link_phrase, foo.status, COUNT(*) FROM foo, link_type WHERE foo.rt = link_type.id GROUP BY foo.rt, link_type.link_phrase, foo.status ORDER BY COUNT(*) DESC;
      • 2015-10-31 30414, 2015

      • bitmap
        let's see
      • 2015-10-31 30416, 2015

      • bitmap
      • 2015-10-31 30417, 2015

      • CatQuest
        uhm
      • 2015-10-31 30431, 2015

      • CatQuest
        I got a ping here but I can't see who/where
      • 2015-10-31 30443, 2015

      • chirlu`
        So, in summary: 31756 edits were applied, 17 were voted down, 108 got cancelled.
      • 2015-10-31 30444, 2015

      • chirlu`
        2 failed for technical reasons.
      • 2015-10-31 30425, 2015

      • chirlu`
        That’s 0.05% of the add-relationship edits voted down, 0.34% cancelled.
      • 2015-10-31 30449, 2015

      • chirlu`
        0.006% failed.
      • 2015-10-31 30454, 2015

      • chirlu`
        bitmap, without autoedits and a larger sample: WITH foo AS (SELECT extract_path_value(edit.data, 'link_type/id')::int AS rt, edit.status FROM edit WHERE edit.type = 90 AND edit.autoedit = 1 AND edit.id BETWEEN 33000000 AND 34000000) SELECT foo.rt, link_type.link_phrase, foo.status, COUNT(*) FROM foo, link_type WHERE foo.rt = link_type.id GROUP BY foo.rt, link_type.link_phrase, foo.status ORDER BY link_type.link_phrase, COUNT(*) DE
      • 2015-10-31 30454, 2015

      • chirlu`
        SC;
      • 2015-10-31 30423, 2015

      • chirlu`
        bitmap: Oops, autoedit = 0, not = 1.
      • 2015-10-31 30457, 2015

      • bitmap
      • 2015-10-31 30446, 2015

      • diana_olhovik has quit
      • 2015-10-31 30412, 2015

      • chirlu`
        So, excluding autoedits we have 257 edits voted down and 1314 cancelled vs. 199388 accepted.
      • 2015-10-31 30450, 2015

      • chirlu`
        i.e. 0.78% of all edits were either voted down or cancelled.
      • 2015-10-31 30457, 2015

      • chirlu`
        *all add-relationship
      • 2015-10-31 30425, 2015

      • reosarevok
        LordSputnik: do you actually have a problem with the ticket or was it 100% trolling? :p
      • 2015-10-31 30438, 2015

      • regagain has quit
      • 2015-10-31 30422, 2015

      • Freso
        legoktm: Ping?
      • 2015-10-31 30425, 2015

      • Gentlecat
      • 2015-10-31 30452, 2015

      • Gentlecat
      • 2015-10-31 30450, 2015

      • LordSputnik
        Why not store DB-specific info in a table in individual projects, with editor ID (from MeB) as the key?
      • 2015-10-31 30446, 2015

      • LordSputnik
        Then when the user logs in via MeB, we somehow get the user ID, and the specific site gets the specific info?
      • 2015-10-31 30405, 2015

      • chirlu`
        LordSputnik: But how are the specific sites notified about removals? The user will never log in again.
      • 2015-10-31 30406, 2015

      • Gentlecat
        does that mean that we actually don't have to use oauth2 internally?
      • 2015-10-31 30454, 2015

      • Gentlecat
        chirlu`: can check the same table
      • 2015-10-31 30410, 2015

      • chirlu`
        Gentlecat: What table?
      • 2015-10-31 30447, 2015

      • Gentlecat
        user table in MeB database
      • 2015-10-31 30458, 2015

      • Gentlecat
        maybe LordSputnik meant something else
      • 2015-10-31 30401, 2015

      • LordSputnik
        OAuth could be avoided internally if you can access the MeB user table directly in all internal projects
      • 2015-10-31 30436, 2015

      • LordSputnik
        But I think we might as well stick with OAuth
      • 2015-10-31 30414, 2015

      • LordSputnik
        The benefit of storing site-specific data with the sites is that it's potentially less work to implement that than a way of storing and accessing that data on MeB
      • 2015-10-31 30409, 2015

      • alastairp
        LordSputnik: we basically do already
      • 2015-10-31 30449, 2015

      • LordSputnik has quit
      • 2015-10-31 30401, 2015

      • Freso
        Other people are more than welcome to assist in adding to the notes too. Just let me know your Google id thingies.
      • 2015-10-31 30413, 2015

      • Freso
      • 2015-10-31 30410, 2015

      • LordSputnik joined the channel
      • 2015-10-31 30404, 2015

      • CallerNo6
        come on you people, https://twitter.com/hashtag/mbsummit15?src=hash is looking like a ghost town.
      • 2015-10-31 30432, 2015

      • Freso
      • 2015-10-31 30441, 2015

      • Freso
        alastairp: ^ :D
      • 2015-10-31 30403, 2015

      • alastairp
        hah, only once we actually have search by recording
      • 2015-10-31 30412, 2015

      • alastairp
        what do you think we are? competent?
      • 2015-10-31 30424, 2015

      • Freso
        I don't expect it to be done anytime soon.
      • 2015-10-31 30431, 2015

      • alastairp
        also, discussions at the conference regarding messybrainz is making me re-think some stuff
      • 2015-10-31 30435, 2015

      • alastairp
        especially around merging ids
      • 2015-10-31 30435, 2015

      • Freso
        Gentlecat has far too many things to do now that he's been employed.
      • 2015-10-31 30439, 2015

      • LordSputnik
        zas: I've fixed http://tickets.musicbrainz.org/browse/PICARD-770 - now need to work out how to integrate it with Picard
      • 2015-10-31 30459, 2015

      • LordSputnik
        Leftmost: relationship/identifier system planning later? Can also work out a rough design for the relationship editor
      • 2015-10-31 30416, 2015

      • Leftmost
        LordSputnik, sure.
      • 2015-10-31 30434, 2015

      • Freso
        Actually, please help with the summit notes. I'm losing track too often.
      • 2015-10-31 30407, 2015

      • LordSputnik
        me?
      • 2015-10-31 30407, 2015

      • LordSputnik
        Freso: where are they?
      • 2015-10-31 30431, 2015

      • Freso
      • 2015-10-31 30403, 2015

      • LordSputnik
        reosarevok: nah I don't have a problem, I deleted the comment ;)
      • 2015-10-31 30420, 2015

      • Freso
        LordSputnik: Credentials?
      • 2015-10-31 30446, 2015

      • Freso
        "If you are here by mistake, click your browser's back button."
      • 2015-10-31 30450, 2015

      • Freso
        That's really profound.
      • 2015-10-31 30438, 2015

      • CallerNo6 didn't ask to be born!
      • 2015-10-31 30413, 2015

      • Freso
        ruaok: http://tickets.musicbrainz.org/browse/OTHER-208 - reply to last comment?
      • 2015-10-31 30413, 2015

      • Freso
        "Alastairp: Gentlecat did work and his work kind of worked and then it was heavily tested and it kind of didn’t work anymore."
      • 2015-10-31 30425, 2015

      • alastairp
        sounds accurate
      • 2015-10-31 30436, 2015

      • regagain joined the channel
      • 2015-10-31 30409, 2015

      • Freso
        ruchiranga
      • 2015-10-31 30423, 2015

      • Freso
        Oh, hi ruchiranga :)
      • 2015-10-31 30439, 2015

      • Freso
        We're just talking about your GSoC project.
      • 2015-10-31 30449, 2015

      • Freso
        Do you still have a sandbox/test server up?
      • 2015-10-31 30418, 2015

      • ruaok has quit
      • 2015-10-31 30447, 2015

      • Freso
        If anyone has ideas for good, small-ish and/or easy-ish things for newbies to pick up on, please add them to https://wiki.musicbrainz.org/User:Freso/Google_Co…
      • 2015-10-31 30407, 2015

      • Leftmost
        Pagination!
      • 2015-10-31 30446, 2015

      • RustyB has quit
      • 2015-10-31 30446, 2015

      • russss has quit
      • 2015-10-31 30426, 2015

      • Tecfan has quit
      • 2015-10-31 30428, 2015

      • kurros has quit
      • 2015-10-31 30451, 2015

      • kurros joined the channel
      • 2015-10-31 30411, 2015

      • LordSputnik has quit
      • 2015-10-31 30450, 2015

      • Tecfan joined the channel
      • 2015-10-31 30417, 2015

      • RustyB joined the channel
      • 2015-10-31 30417, 2015

      • russss joined the channel
      • 2015-10-31 30402, 2015

      • regagain has quit
      • 2015-10-31 30424, 2015

      • ruchiranga has quit
      • 2015-10-31 30453, 2015

      • Nyanko-sensei has quit
      • 2015-10-31 30421, 2015

      • Nyanko-sensei joined the channel
      • 2015-10-31 30447, 2015

      • Nyanko-sensei has quit
      • 2015-10-31 30404, 2015

      • Nyanko-sensei joined the channel
      • 2015-10-31 30451, 2015

      • LordSputnik joined the channel
      • 2015-10-31 30407, 2015

      • bitmap
      • 2015-10-31 30430, 2015

      • bitmap
      • 2015-10-31 30431, 2015

      • JesseW joined the channel
      • 2015-10-31 30447, 2015

      • legoktm
        Freso: pong
      • 2015-10-31 30418, 2015

      • JonnyJD has quit
      • 2015-10-31 30453, 2015

      • alastairp
        legoktm: we're out at dinner. We had a question about wikimedia SSO
      • 2015-10-31 30435, 2015

      • regagain joined the channel
      • 2015-10-31 30430, 2015

      • reosarevok has quit
      • 2015-10-31 30437, 2015

      • adamcik joined the channel
      • 2015-10-31 30457, 2015

      • domme has quit
      • 2015-10-31 30421, 2015

      • regagain has quit
      • 2015-10-31 30440, 2015

      • JesseW has quit
      • 2015-10-31 30448, 2015

      • ruaok joined the channel
      • 2015-10-31 30446, 2015

      • ruaok has quit
      • 2015-10-31 30444, 2015

      • legoktm
        alastairp: what's the question? :)
      • 2015-10-31 30413, 2015

      • reosarevok joined the channel
      • 2015-10-31 30406, 2015

      • reosarevok
        legoktm: we wanted to know how you dealt with users removing their account
      • 2015-10-31 30409, 2015

      • reosarevok
        At wikimedia
      • 2015-10-31 30413, 2015

      • reosarevok
        Now that you have single sign on
      • 2015-10-31 30443, 2015

      • legoktm
        We don't allow people to delete their accounts
      • 2015-10-31 30413, 2015

      • legoktm
        Some legal reason or something.
      • 2015-10-31 30425, 2015

      • legoktm
        We do rename accounts to gibberish if people want to leave
      • 2015-10-31 30426, 2015

      • Leftmost
        How do you deal with communication between projects for login and preferences storage?
      • 2015-10-31 30454, 2015

      • Gentlecat
        oh, right. I remember something about that