On 11/5/11 11:36 AM, MZMcBride wrote: > MZMcBride wrote: >> In a lot of ways, a lot of people have already followed my advice. The >> people who are contributing primarily nowadays are doing so for a paycheck, >> aren't they? :-) That's how broken the process is. The only incentive >> people have to deal with it is the in form of a paycheck. > > I very briefly looked at the last 5000 revisions to the MediaWiki > repository, grouped by author. I added a column to mark whether the author > is working for or has worked for Wikimedia. I don't really have the time or > patience to do a lot of analysis on this. I can say that, assuming the third > column is correct, 41 of the 101 listed authors worked for or work for > Wikimedia. That's actually a bit less than I expected. The contribution > totals are completely skewed, though, rather unsurprisingly. Of the last > 5000 revisions, 3737 came from people with a mark in column 3 (74.74%). So > 74.74% of contributions made by 40.59% of the authors. > > On average, "paid authors" made 91.15 contributions; "unpaid authors" made > 21.05 contributions. > > These numbers, taken alone, aren't particularly surprising. I think when you > factor in the number of potential contributors (people with a basic > understanding of SVN + PHP + FOSS), it looks a lot more bleak. > > It'd be interesting to get a breakdown on number of reviewed vs. unreviewed > revisions for each author or even time between commit and resolution of the > revision, but the sun is shining, so I think I'm going to go outside. :-) > > mysql> select > -> cr_author, > -> count(*) > -> from code_rev > -> where cr_repo_id = 1 > -> and cr_id> 97108 > -> group by cr_author; > +----------------+----------+---+ > | cr_author | count(*) | ? | > +----------------+----------+---+ > | aaron | 371 | + | > | akshay | 2 | | > | amire80 | 28 | + | > | ariel | 34 | + | > | asher | 24 | + | > | ashley | 35 | | > | awjrichards | 122 | + | > | bachsau | 1 | | > | bawolff | 18 | | > | ben | 9 | + | > | bharris | 5 | + | > | bkaempgen | 5 | | > | blobaugh | 6 | | > | brion | 100 | + | > | btongminh | 21 | | > | catrope | 323 | + | > | cervidae | 29 | | > | churchofemacs | 1 | | > | ckepper | 2 | | > | cryptocoryne | 9 | | > | dale | 3 | | > | danny_b | 5 | | > | dantman | 39 | | > | danwe | 13 | | > | dasch | 19 | | > | demon | 65 | + | > | diederik | 2 | | > | erik | 13 | + | > | ezachte | 14 | + | > | faurethomas | 2 | | > | flohack | 1 | | > | foxtrott | 40 | | > | fptc | 5 | | > | freakolowsky | 2 | | > | gicode | 1 | | > | greg | 1 | | > | gregchiasson | 1 | | > | gwicke | 12 | + | > | halfak | 1 | + | > | happy-melon | 14 | | > | hartman | 14 | | > | hashar | 78 | + | > | ialex | 159 | | > | inez | 94 | + | > | j | 4 | + | > | jamesur | 6 | + | > | jeroendedauw | 360 | + | > | jhsoby | 6 | + | > | johnduhart | 71 | | > | jpostlethwaite | 161 | + | > | junaidpv | 22 | | > | kaldari | 130 | + | > | khorn | 104 | + | > | kipcool | 7 | | > | krinkle | 90 | + | > | kwisatz | 8 | | > | laner | 28 | + | > | liangent | 19 | | > | mah | 53 | + | > | malvineous | 1 | | > | maxsem | 29 | | > | mglaser | 4 | | > | midom | 2 | | > | mkroetzsch | 29 | | > | nad | 1 | | > | neilk | 51 | + | > | nelson | 13 | + | > | nikerabbit | 181 | + | > | nimishg | 1 | + | > | ning | 8 | | > | overlordq | 6 | | > | petrb | 90 | | > | pgehres | 48 | + | > | philip | 10 | | > | platonides | 80 | | > | preilly | 224 | + | > | py | 3 | + | > | questpc | 23 | | > | raindrift | 23 | + | > | raymond | 177 | | > | reedy | 503 | + | > | robin | 32 | | > | rotem | 5 | | > | samuellampa | 3 | | > | santhosh | 52 | + | > | saper | 3 | | > | sean_colombo | 14 | | > | shizhao | 3 | | > | siebrand | 110 | + | > | smoke3723 | 5 | | > | sumanah | 1 | + | > | thenub314 | 1 | | > | tparscal | 215 | + | > | tstarling | 39 | + | > | vasilievvv | 3 | | > | vitalif | 6 | | > | vyznev | 1 | | > | werdna | 38 | + | > | wikinaut | 26 | | > | yaron | 123 | | > | yonishostak | 1 | | > +----------------+----------+---+ > 101 rows in set (27.56 sec) > > MZMcBride > > > > _______________________________________________ > Wikitech-l mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/wikitech-l
-- Neil Kandalgaonkar |) <[email protected]> _______________________________________________ Wikitech-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikitech-l
