Page MenuHomePhabricator

Kubina (Jeff)
User

Projects

User does not belong to any projects.

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Monday

  • Clear sailing ahead.

User Details

User Since
Apr 22 2015, 2:29 PM (299 w, 2 d)
Availability
Available
LDAP User
Unknown
MediaWiki User
Kubina [ Global Accounts ]

Recent Activity

Apr 23 2015

Kubina added a comment to T93396: Decide on format options for HTML and possibly other dumps.

@GWicke While 4,857,103 includes redirects sorting by the titles shows the last title of an article in the database is Sam_Tung_Uk_Museum and querying for the title "Water" or "U2" does not return anything. I think all the articles after Sam_Tung_Uk_Museum are missing.

$ sqlite3 en.wikipedia.org.articles.ns0.sqlite3 
SQLite version 3.6.20
sqlite> select count(title) from data where (title="Water");
0
sqlite> select count(title) from data where (title="U2");
0
sqlite> select count(title) from data where (title="Sam_Tung_Uk_Museum");
1
Apr 23 2015, 7:59 PM · Services (blocked), Dumps-Generation, RESTBase
Kubina added a comment to T93396: Decide on format options for HTML and possibly other dumps.

@GWicke Great work but I think en.wikipedia.org.articles.ns0.sqlite3 is incomplete, the current article count is 4,857,103:

Apr 23 2015, 6:42 PM · Services (blocked), Dumps-Generation, RESTBase