Hi, I had taken a back up of the Wikipedia data and have a range / set of pageids.
How do I find out the range of pageids that are currently in use in wikipedia? Do pageids always remain constant? Can a certain pageid cease to exist?
Please let me know
thanks
On Thu, Dec 11, 2014 at 5:11 AM, practikal mind practikalmind@gmail.com wrote:
How do I find out the range of pageids that are currently in use in wikipedia?
I don't know of any straightforward way to do this via the API. But if you get an account on Tool Labs,[1] it's a simple SQL query: SELECT MIN(page_id), MAX(page_id) FROM page.
[1]: https://tools.wmflabs.org/
Do pageids always remain constant?
If a page is deleted and then undeleted, the page id might change.
Can a certain pageid cease to exist?
If the page is deleted, yes. Special:MergeHistory will probably eliminate one of the involved page ids too.
thanks Brad, I created an account in Tools Lab and a public SSH key. How long will it take to approve my request before I can submit queries?
On Thu, Dec 11, 2014 at 6:45 AM, Brad Jorsch (Anomie) <bjorsch@wikimedia.org
wrote:
On Thu, Dec 11, 2014 at 5:11 AM, practikal mind practikalmind@gmail.com wrote:
How do I find out the range of pageids that are currently in use in wikipedia?
I don't know of any straightforward way to do this via the API. But if you get an account on Tool Labs,[1] it's a simple SQL query: SELECT MIN(page_id), MAX(page_id) FROM page.
Do pageids always remain constant?
If a page is deleted and then undeleted, the page id might change.
Can a certain pageid cease to exist?
If the page is deleted, yes. Special:MergeHistory will probably eliminate one of the involved page ids too.
-- Brad Jorsch (Anomie) Software Engineer Wikimedia Foundation
Mediawiki-api mailing list Mediawiki-api@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-api
Here's the quickest way to answer your question. You don't need to go through the trouble of a Tool Labs account to run a query.
http://quarry.wmflabs.org/query/1181
On Thu, Dec 11, 2014 at 10:46 AM, practikal mind practikalmind@gmail.com wrote:
thanks Brad, I created an account in Tools Lab and a public SSH key. How long will it take to approve my request before I can submit queries?
On Thu, Dec 11, 2014 at 6:45 AM, Brad Jorsch (Anomie) < bjorsch@wikimedia.org> wrote:
On Thu, Dec 11, 2014 at 5:11 AM, practikal mind practikalmind@gmail.com wrote:
How do I find out the range of pageids that are currently in use in wikipedia?
I don't know of any straightforward way to do this via the API. But if you get an account on Tool Labs,[1] it's a simple SQL query: SELECT MIN(page_id), MAX(page_id) FROM page.
Do pageids always remain constant?
If a page is deleted and then undeleted, the page id might change.
Can a certain pageid cease to exist?
If the page is deleted, yes. Special:MergeHistory will probably eliminate one of the involved page ids too.
-- Brad Jorsch (Anomie) Software Engineer Wikimedia Foundation
Mediawiki-api mailing list Mediawiki-api@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-api
Mediawiki-api mailing list Mediawiki-api@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-api
thanks, I tried editing the query to submit a new one. It is readonly.
On Thu, Dec 11, 2014 at 10:59 AM, Aaron Halfaker ahalfaker@wikimedia.org wrote:
Here's the quickest way to answer your question. You don't need to go through the trouble of a Tool Labs account to run a query.
http://quarry.wmflabs.org/query/1181
On Thu, Dec 11, 2014 at 10:46 AM, practikal mind practikalmind@gmail.com wrote:
thanks Brad, I created an account in Tools Lab and a public SSH key. How long will it take to approve my request before I can submit queries?
On Thu, Dec 11, 2014 at 6:45 AM, Brad Jorsch (Anomie) < bjorsch@wikimedia.org> wrote:
On Thu, Dec 11, 2014 at 5:11 AM, practikal mind <practikalmind@gmail.com
wrote:
How do I find out the range of pageids that are currently in use in wikipedia?
I don't know of any straightforward way to do this via the API. But if you get an account on Tool Labs,[1] it's a simple SQL query: SELECT MIN(page_id), MAX(page_id) FROM page.
Do pageids always remain constant?
If a page is deleted and then undeleted, the page id might change.
Can a certain pageid cease to exist?
If the page is deleted, yes. Special:MergeHistory will probably eliminate one of the involved page ids too.
-- Brad Jorsch (Anomie) Software Engineer Wikimedia Foundation
Mediawiki-api mailing list Mediawiki-api@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-api
Mediawiki-api mailing list Mediawiki-api@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-api
Mediawiki-api mailing list Mediawiki-api@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-api
You can log in and submit your own queries. Click the big "Login with Wikimedia" button.
On Thu, Dec 11, 2014 at 11:07 AM, practikal mind practikalmind@gmail.com wrote:
thanks, I tried editing the query to submit a new one. It is readonly.
On Thu, Dec 11, 2014 at 10:59 AM, Aaron Halfaker ahalfaker@wikimedia.org wrote:
Here's the quickest way to answer your question. You don't need to go through the trouble of a Tool Labs account to run a query.
http://quarry.wmflabs.org/query/1181
On Thu, Dec 11, 2014 at 10:46 AM, practikal mind <practikalmind@gmail.com
wrote:
thanks Brad, I created an account in Tools Lab and a public SSH key. How long will it take to approve my request before I can submit queries?
On Thu, Dec 11, 2014 at 6:45 AM, Brad Jorsch (Anomie) < bjorsch@wikimedia.org> wrote:
On Thu, Dec 11, 2014 at 5:11 AM, practikal mind < practikalmind@gmail.com> wrote:
How do I find out the range of pageids that are currently in use in wikipedia?
I don't know of any straightforward way to do this via the API. But if you get an account on Tool Labs,[1] it's a simple SQL query: SELECT MIN(page_id), MAX(page_id) FROM page.
Do pageids always remain constant?
If a page is deleted and then undeleted, the page id might change.
Can a certain pageid cease to exist?
If the page is deleted, yes. Special:MergeHistory will probably eliminate one of the involved page ids too.
-- Brad Jorsch (Anomie) Software Engineer Wikimedia Foundation
Mediawiki-api mailing list Mediawiki-api@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-api
Mediawiki-api mailing list Mediawiki-api@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-api
Mediawiki-api mailing list Mediawiki-api@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-api
Mediawiki-api mailing list Mediawiki-api@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-api
Woops. Looks like that big button is only on the homepage. See: http://quarry.wmflabs.org
On Thu, Dec 11, 2014 at 11:14 AM, Aaron Halfaker ahalfaker@wikimedia.org wrote:
You can log in and submit your own queries. Click the big "Login with Wikimedia" button.
On Thu, Dec 11, 2014 at 11:07 AM, practikal mind practikalmind@gmail.com wrote:
thanks, I tried editing the query to submit a new one. It is readonly.
On Thu, Dec 11, 2014 at 10:59 AM, Aaron Halfaker <ahalfaker@wikimedia.org
wrote:
Here's the quickest way to answer your question. You don't need to go through the trouble of a Tool Labs account to run a query.
http://quarry.wmflabs.org/query/1181
On Thu, Dec 11, 2014 at 10:46 AM, practikal mind < practikalmind@gmail.com> wrote:
thanks Brad, I created an account in Tools Lab and a public SSH key. How long will it take to approve my request before I can submit queries?
On Thu, Dec 11, 2014 at 6:45 AM, Brad Jorsch (Anomie) < bjorsch@wikimedia.org> wrote:
On Thu, Dec 11, 2014 at 5:11 AM, practikal mind < practikalmind@gmail.com> wrote:
How do I find out the range of pageids that are currently in use in wikipedia?
I don't know of any straightforward way to do this via the API. But if you get an account on Tool Labs,[1] it's a simple SQL query: SELECT MIN(page_id), MAX(page_id) FROM page.
Do pageids always remain constant?
If a page is deleted and then undeleted, the page id might change.
Can a certain pageid cease to exist?
If the page is deleted, yes. Special:MergeHistory will probably eliminate one of the involved page ids too.
-- Brad Jorsch (Anomie) Software Engineer Wikimedia Foundation
Mediawiki-api mailing list Mediawiki-api@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-api
Mediawiki-api mailing list Mediawiki-api@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-api
Mediawiki-api mailing list Mediawiki-api@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-api
Mediawiki-api mailing list Mediawiki-api@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-api
Thanks for all the help. On Dec 11, 2014 11:15 AM, "Aaron Halfaker" ahalfaker@wikimedia.org wrote:
Woops. Looks like that big button is only on the homepage. See: http://quarry.wmflabs.org
On Thu, Dec 11, 2014 at 11:14 AM, Aaron Halfaker ahalfaker@wikimedia.org wrote:
You can log in and submit your own queries. Click the big "Login with Wikimedia" button.
On Thu, Dec 11, 2014 at 11:07 AM, practikal mind <practikalmind@gmail.com
wrote:
thanks, I tried editing the query to submit a new one. It is readonly.
On Thu, Dec 11, 2014 at 10:59 AM, Aaron Halfaker < ahalfaker@wikimedia.org> wrote:
Here's the quickest way to answer your question. You don't need to go through the trouble of a Tool Labs account to run a query.
http://quarry.wmflabs.org/query/1181
On Thu, Dec 11, 2014 at 10:46 AM, practikal mind < practikalmind@gmail.com> wrote:
thanks Brad, I created an account in Tools Lab and a public SSH key. How long will it take to approve my request before I can submit queries?
On Thu, Dec 11, 2014 at 6:45 AM, Brad Jorsch (Anomie) < bjorsch@wikimedia.org> wrote:
On Thu, Dec 11, 2014 at 5:11 AM, practikal mind < practikalmind@gmail.com> wrote:
> How do I find out the range of pageids that are currently in use in > wikipedia? >
I don't know of any straightforward way to do this via the API. But if you get an account on Tool Labs,[1] it's a simple SQL query: SELECT MIN(page_id), MAX(page_id) FROM page.
> Do pageids always remain constant? >
If a page is deleted and then undeleted, the page id might change.
> Can a certain pageid cease to exist? >
If the page is deleted, yes. Special:MergeHistory will probably eliminate one of the involved page ids too.
-- Brad Jorsch (Anomie) Software Engineer Wikimedia Foundation
Mediawiki-api mailing list Mediawiki-api@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-api
Mediawiki-api mailing list Mediawiki-api@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-api
Mediawiki-api mailing list Mediawiki-api@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-api
Mediawiki-api mailing list Mediawiki-api@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-api
Mediawiki-api mailing list Mediawiki-api@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-api
mediawiki-api@lists.wikimedia.org