Wikipedia:Wikipedia Signpost/2024-07-04/Cobwebs

File:Edmund J Sullivan Illustrations to The Rubaiyat of Omar Khayyam First Version Quatrain-051 (cropped).jpg
Edmund J. Sullivan
PD
300
Cobwebs

Counting to a billion — manuscripts don't burn

We covered Wikipedia's billionth edit at News and notes in 2021 and somehow this contribution from other editors got lost in the shuffle. Here for your enjoyment is what was developed back then.
The original lead-in and story follow.

TKTK
Is it possible for a Wikipedia article to predate Wikipedia itself? Read on and find out. A clue is in this image.
The Signpost's editors calculate that English Wikipedia's billionth edit will occur on January 15 [2021], plus or minus five days. But what does this mean exactly?

A robust discussion happened in the newsroom that we wanted to share with our readers. It turns out that the history of the Wikimedia software, lost and partially restored databases from the early days, the Nupedia fork, and other Wiki-arcana – plus the international date line! – intrude when one wants to determine exactly which edit was the billionth.

Iridescent

The pedant in me is obliged to spoil the party by pointing out that Wikipedia's billionth edit has almost certainly already been and gone unnoticed and unremarked. Special:Diff/1000000000 is just going to be "the billionth edit made on the current software", since when we switched from UseModWiki to MediaWiki the counts were reset (Special:Diff/1 is completely unremarkable). Because the UseModWiki logs have been lost, we have no idea how many edits were made using it.

Smallbones

Thanks for the info. we'll have to say something like "the billionth edit since January 25, 2002". One question, the URL that results from clicking Special:Diff/1 is https://en.wikipedia.org/w/index.php?diff=1&oldid=294750 . Does the "294750" mean anything? Could about 300,000 edits have been made in the very first year?

WereSpielChequers

I thought that a lot of the early edits were recovered from an archive and reloaded. But presumably some deleted stuff was lost.

Iridescent

I doubt there are any exact answers since we know some of the early edits have been completely lost; one also needs to account that although we take 15 January 2001 as a "start date" that's just the day of the Wikipedia/Nupedia fork became separate entities. The articles on Nupedia were just ported across to Wikipedia (compare the last edit to "The Donegal Fiddle Tradition" on Nupedia with the first version of [[Donegal fiddle tradition]] on Wikipedia) but the Nupedia edit histories weren't preserved in the transfer. IIRC Graham87 has done some work to try to reconstruct the early days, but I would think too much history has been lost to ever be able to be more specific than "lots of edits". (Bear in mind also that prior to the Wikidata migration, things like changes to the interwiki language links also show up in the history as "edits", as do edits made to pages in other languages that were then transwikied for translation—for instance you (Smallbones) have officially made quite a few edits to German Wikipedia all of which go towards de-wiki's edit count, even though it doesn't appear you've ever touched that project in reality.)

WereSpielChequers

I know that there are edits on the German, Greek and perhaps other Wikipedias that are transwikied copies of edits from EN Wikipedia. Most of my edits on DE were made here and subsequently copied over when someone translated an article into German and copied all its history. But that only effects our billion edits calculation if people have imported article histories to here when they have translated articles into English, and as far as I'm aware we haven't done that (arguably for attribution we should).

Mercator style map of the world broken into time zones, with Chamorro Time Zone highlighted
Due to the International Date Line, Guam (timezone highlighted) is often a calendar day ahead of the rest of the United States.
Bri

I think all the wiki-spelunking (or is it archaeology?) above is a useful addition to a piece we write about the so-called billionth edit. Pedantic or not, newsworthy and will prove interesting to many.

Furthering the pedantry, History of Wikipedia says "The first portable MediaWiki software went live on 25 January" 2002. but Special:Diff/1 is 14:25 26 January 2002 UTC (which was also 26 January in the U.S. [except Guam where it was 27 January, take that pedants]). I wonder why?

Graham87

I think we're only out by a few hundred thousand edits, at the very most, perhaps closer to 150,000 or 200,000. We have relatively exact figures for the number of edits from 15 January to 17 August 2001 and from 20 November to 20 December, which total 88,837 edits. The 17 August 2001 database dump, which contains every edit from Wikipedia's founding until that date, contains 57,982 edits per a line count of one of the log files, rc.log (each edit is stored on its own line). The Nostalgia Wikipedia contains a snapshot of all edits up to 20 December 2001, and as far as I understand it contains a complete archive of edits between 20 November and 20 December of that year, because edits from that time weren't automatically removed. It contains 95330 edits, but that includes edits made by the conversion script in 2005 among other things. I did a quick and dirty database query to list all timestamps in the database, earliest first, and from there I found out that the Nostalgia Wikipedia contains 88,040 edits from 2001, 30,855 of which were made in the llast month of the database and therefore form a complete archive. (We can't do this on the current Wikipedia database since, as explained at Wikipedia:Usemod article histories, the final edit made to each page wasn't imported when the UseModWiki edits were added in 2002).

Another thing that would whack out the count a bit is that edits deleted before Wikipedia was upgraded to MediaWiki 1.5 lost their revision ID numbers and got new ones when they were undeleted. According to an old Bugzilla thread, there were 511,728 of those. Some of those got undeleted/re-imported, most notably at Wikipedia:Historical archive/Sandbox, which has over 20,000 revisions. There are also quite a few other revisions that have also been imported from the Nostalgia Wikipedia (I'd say 50,000 or so).

Smallbones

I agree with Bri on this. The story that is emerging here will be worth much more to many of our readers than just the date of the "billionth". That billionth-date article would after all just be a number and a date, a round number marking point with maybe a bit of nostalgia, but not much more. The emerging story however has got a lot more – an origin story, some mystery, there's even some controversy regarding the last Nupedia edit – see Talk:Donegal fiddle tradition. That article became a featured article – with very few edits after Larry Sanger wrote it on Nupedia – and it's still a good article. But it seems that Sanger was complaining that it was a copyright violation. So who wants to write it up? for December 20ish if we really want to emphasize the history, or late January if we just want to accompany the billionth-date article. Either way it would be an important part of our 20th birthday celebration.

HaeB

See also Wikipedia:Wikipedia Signpost/2010-04-19/News and notes#Briefly: On Friday, 16 April 2010 the Wikimedia projects passed a total of 1 billion edits, as measured by the edit counter.

Graham87

Re the discrepancy pointed out by Bri between the edit with ID 1 and the date given for the software upgrade, I don't exactly know the answer, but it says it was upgraded on the 25th of January at Wikipedia:Magnus Manske Day, the mailing list thread linked from there, and this mailing list thread. I seem to recall that there were some weird issues in the early days with time zones, but I thought they were about some timestamps being in Pacific Standard Time instead of UTC, which wouldn't make sense at all here. Also see more info about early timestamp bugs at User:Conversion script.

Smallbones

OK, the one billionth (since whenever) is for the English-language Wikipedia Wikipedia:Time Between Edits. The 4.5 billion from edit counter is for all WMF projects. This is getting complicated, but that should add to the mystery. It is over my head, though...