Wikitech-l April 2009

wikitech-l@lists.wikimedia.org

91 participants
75 discussions

Browser Percentages for Contributers
by Michael Dale 13 Apr '09

13 Apr '09

I am wondering if anyone has some contributer "browser-client" information handy or can point me to a some dataset that I could query to get the following information: 1) What is wikipedia client browser usage percentage distribution ( I recall that being published recently but I have misplaced the link) 2) What is the distribution of browsers for people that visit the ?action=edit pages (on en.wikipedia) 3) What is the distribution of browsers for people that submit post data to /wiki/Special:Upload on commons. (ie upload images) thanks, michael

2 1

DBMS where join+limit works?
by Tim Starling 13 Apr '09

13 Apr '09

On thistle with DB=dewiki: mysql> explain select * from recentchanges left join tag_summary on ts_rc_id=rc_id order by rc_timestamp desc limit 50\G *************************** 1. row *************************** table: recentchanges type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 1179921 Extra: Using temporary; Using filesort *************************** 2. row *************************** table: tag_summary type: ALL possible_keys: ts_rc_id key: NULL key_len: NULL ref: NULL rows: 4 Extra: 2 rows in set (0.00 sec) Whenever you do a join with a limit, MySQL gets the query plan wrong. It scans the small table and filesorts the large table. You have to use FORCE INDEX on the small table to suppress the scan. We've seen this many times. It's very difficult to detect during code review and frequently crashes the site. Does anyone know a DBMS where joining with limits actually works? Because I'm sick of this crap. -- Tim Starling

7 7

SVN commit access
by Techman224 13 Apr '09

13 Apr '09

Since now I know how to make a request for SVN access, here's my request: Key: http://toolserver.org/~techman224/sshpubkey.txt Commit name: techman224 Alternative commit name: techman I will use my commit access to help categorize some extensions that haven't been yet, and other small maintenance tasks I can handle if I see them. Thanks, Techman224

4 5

A proposal to simplify and improve geo markup in Wikipedia
by Håkon Wium Lie 11 Apr '09

11 Apr '09

I've analyzed Wikipedia's HTML code for representing geographical coordinates. The current code is verbose and does not support the Geo microformat correctly. Three alternatives, differing on functionality and code size, are suggested as replacements: http://www.princexml.com/howcome/2009/wikipedia/geo/ Alternative 1, which is comptible with Wikipedia's current syntax for personalized presentation, reduces the number of elements from 14 to 10. Alternative 2, which uses CSS generated content to achieve personalized presentations, reduces the number of elments from 14 to 5 and the code size from 798 to 248 bytes. Cheers, -h&kon Håkon Wium Lie CTO °þe®ª howcome(a)opera.com http://people.opera.com/howcome

8 12

WikiSym 2009 in Orlando: Call for Papers - deadline March 27
by phoebe ayers 09 Apr '09

09 Apr '09

Hello all, A reminder that WikiSym 2009 will be in Orlando, Florida, from October 25-27. The deadline for submitting papers, workshops and panel proposals is March 27; April 24th is the deadline for posters, demonstrations and WikiFest (practical experience) proposals. Topics of interest include: * social software for collaboration and work group processes * wiki user experiences, usability, and discourse analysis * reputation systems, quality assurance processes * scalability---social and technical * wiki technologies and implementations * translation and multilingual wiki content * educational applications * wiki for non-textual media (images, video, audio) * content dynamics and wiki evolution * wiki journalism * wiki archiving and versioning * wiki administration: dealing with abuse and resolving conflict * wiki and the semantic web, knowledge management, tacit knowledge * wiki for small audiences (departmental and family wikis) * legal issues (copyright, licensing) * visualization of wiki structure * wiki fiction For more information, see the Call for Papers: http://www.wikisym.org/ws2009/tiki-index.php?page=Call+for+Papers WikiSym is an annual conference devoted to research into all aspects of wikis, including wiki communities, wiki software and technology, and using wikis in education and organizations. Research papers about the Wikimedia projects are welcome! Papers are peer reviewed and archived in the ACM digital library (see past proceedings: http://portal.acm.org/toc.cfm?id=SERIES11299&coll=ACM&dl=ACM&type=series&id… The conference is colocated with OOPSLA 2009. For more, see: http://www.wikisym.org/ws2009/ -- Phoebe Ayers (2009 Wikimedia Liason)

2 1

how much redundant text in Wikipedia?
by jidanni＠jidanni.org 09 Apr '09

09 Apr '09

I'm curious what does SELECT COUNT(DISTINCT old_text), COUNT(*) FROM text; show on Wikipedia's database? On mine I get COUNT(DISTINCT old_text): 2913 COUNT(*): 3560 I.e., 1/7 of the rows are redundant. Currently undos, so frequent on wikis, just blindly create a duplicate row instead of checking if the old one could be reused, https://bugzilla.wikimedia.org/show_bug.cgi?id=18333 . Maybe some hardware savings could even be achieved.

13 23

Wikimania 2009 Scholarships
by Mark (Markie) 09 Apr '09

09 Apr '09

Wikimania 2009 [1], this year's global event devoted to Wikimedia [2] projects around the globe, is now accepting *applications for scholarships*to the conference. This year's conference will be handled from August 26-28 in Buenos Aires [3], Argentina [4]. The scholarship can be used to help offset the costs of travel and registration. For more information, check the official information page [5]. Please remember that the Call for Participation [6] is still open, please submit your papers! Without submissions, Wikimania would not be nearly as fun! [1] http://wikimania2009.wikimedia.org/wiki/Portal [2] http://wikimediafoundation.org/wiki/Home [3] http://en.wikipedia.org/wiki/Buenos_Aires [4] http://en.wikipedia.org/wiki/Argentina [5] http://wikimania2009.wikimedia.org/wiki/Scholarships [6] http://wikimania2009.wikimedia.org/wiki/Call_for_Participation Regards Mark

1 0

Wikimania 2009: Call for Participation reminder
by Mark (Markie) 08 Apr '09

08 Apr '09

Just to remind you all that the Call for Participation for Wikimania 2009 closes soon. You can view the Call for Participation on the following page: http://wikimania2009.wikimedia.org/wiki/Call_for_Participation with many translations available. For more information about Wikimania 2009, see http://wikimania2009.wikimedia.org/ Regards Markie

2 1

Re: [Wikitech-l] Commit access
by Chad 08 Apr '09

08 Apr '09

You could always email Brion or Tim directly...but they're both really busy... -Chad On Apr 8, 2009 9:46 AM, "Aryeh Gregor" <Simetrical+wikilist(a)gmail.com<Simetrical%2Bwikilist(a)gmail.com>> wrote: On Wed, Apr 8, 2009 at 2:50 AM, Jan Luca <jan(a)jans-seite.de> wrote: > Hello, > > when will there a a... I don't know. It's not up to me. _______________________________________________ Wikitech-l mailing list Wikitech-l(a)lists.wikimedia....

4 6

Renameuser right for administrators on Wikimedia wikis
by MZMcBride 08 Apr '09

08 Apr '09

Hello -- Given that the Renameuser extension now uses the job queue for renames involving over 10,000 edits (and thus no longer locking the site for large renames), is there any technical reason not to give administrators the renameuser right? And, if there are no technical prohibitions, is this something that would require per-project voting or would switching it across all Wikimedia wikis be acceptable? Thanks! MZMcBride public(a)mzmcbride.com

11 20

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

Wikitech-l April 2009