Wikipedia talk:WikiProject Database analysis

Interwiki link analysis
I've always had a hankering to perform some basic analysis of interwiki links, but never have managed to get enough disk space and processing power at ocne to do the job. In a nutshell, it should be possible to suggest interwiki links based purely on those that exist already. Some useful operations might be:


 * Interwiki links to articles that do not exist (A:X links to B:X which does not exist)
 * Interwiki links to redirect pages (A:X links to B:X which redirects to B:Y)
 * Inconsistent interwiki links (A:X links to B:X, but B:X links to A:Y)
 * Suggested reciprocal links (A:X links to B:X, should B:X link back to A:X?)
 * Pages with multiple interwiki links to one language (A:X links to B:X and B:Y)
 * Pages that are linked to from different articles in the same language (both A:X and A:Y link to B:X)
 * Potential commutations (A:X links to B:X and C:X. Should B:X should link to C:X also?)
 * Potential inductions (A:X links to B:X and B:X links to C:X. Should A:X link to C:X?)

- TB 22:33, 5 July 2007 (UTC)


 * That sounds like a great idea, and I'll look into doing such analysis in the near future. I'm just returning to rewriting my analysis scripts after an extended break, and am getting ready to process the latest en-wiki dump.  I'll extract the interwiki links from that dump first, then proceed from there.  --Sapphic 17:45, 30 July 2007 (UTC)


 * I've started playing about with this (finally was able to get a resonably reliable utf-32 system working). Results (such as they are) in WikiProject Interlanguage Links - TB 13:12, 19 August 2007 (UTC)

Handling UTF characters
Not sure if anyone else has had similar, but until recently I was having problems handling UTF characters in mysql databases. Having deduced that the problems were down to windows xp, I've moved my mysql 5.0 installation onto an old PC running Ubuntu linux. Accessed through a putty terminal from my desktop windows xp box with the Translation option set to UTF-8, extended UTF characers still don't display properly but *can* be cut and pasted into a Firefox window for saving to Wikipedia or viewing. - TB 15:52, 27 August 2007 (UTC)

Any chance of getting Most_wanted_articles back up?
Hey - I saw that this group used to maintain a list of most wanted articles, determined by what links to nonexistent pages. Is there any chance this could be maintained again? I think it would be a huge benefit to the encyclopedia - so many people would love to create articles they know are relevant. I'm happy to help out if I can.  Flying  Toaster  06:58, 4 December 2008 (UTC)

Section links
Wondering if anyone can help me; I'm trying to puzzle out how section links (ie [Some page ) are stored in the database. Can't see them in the scehma, and they don't seem to be in the pagelinks table. Anyone know ? - TB (talk) 20:24, 30 May 2009 (UTC)

Wikipedia:HighBeam
HighBeam describes a limited opportunity for Wikipedia editors to have access to HighBeam Research. —Wavelength (talk) 17:35, 5 April 2012 (UTC)

Talk page analysis
I don't know if this is the correct project, but is there any chance of getting a list of anon talk pages and talk subpages over 100KB? A certain blocked person who operates only by IP is, among other things, creating "To Do" lists which are quite large. One that I removed was over 200KB. — Arthur Rubin (talk) 20:09, 10 December 2013 (UTC)

Comment on the WikiProject X proposal
Hello there! As you may already know, most WikiProjects here on Wikipedia struggle to stay active after they've been founded. I believe there is a lot of potential for WikiProjects to facilitate collaboration across subject areas, so I have submitted a grant proposal with the Wikimedia Foundation for the "WikiProject X" project. WikiProject X will study what makes WikiProjects succeed in retaining editors and then design a prototype WikiProject system that will recruit contributors to WikiProjects and help them run effectively. Please review the proposal here and leave feedback. If you have any questions, you can ask on the proposal page or leave a message on my talk page. Thank you for your time! (Also, sorry about the posting mistake earlier. If someone already moved my message to the talk page, feel free to remove this posting.) Harej (talk) 22:47, 1 October 2014 (UTC)

WikiProject X is live!


Hello everyone!

You may have received a message from me earlier asking you to comment on my WikiProject X proposal. The good news is that WikiProject X is now live! In our first phase, we are focusing on research. At this time, we are looking for people to share their experiences with WikiProjects: good, bad, or neutral. We are also looking for WikiProjects that may be interested in trying out new tools and layouts that will make participating easier and projects easier to maintain. If you or your WikiProject are interested, check us out! Note that this is an opt-in program; no WikiProject will be required to change anything against its wishes. Please let me know if you have any questions. Thank you!

Note: To receive additional notifications about WikiProject X on this talk page, please add this page to WikiProject X/Newsletter. Otherwise, this will be the last notification sent about WikiProject X.

Harej (talk) 16:57, 14 January 2015 (UTC)