If you share why kind of query you'd like to run, people on this list might even write you an example Quarry :) See also: https://www.mediawiki.org/wiki/Talk:Quarry People post query requests that and others help them draft the right query for their needs.
On Wed, Mar 27, 2019 at 11:28 AM James Hare <[email protected]> wrote: > I will also note that Quarry <https://quarry.wmflabs.org/> is good for > querying database replicas – no Toolforge account required. > > > -- > *James Hare* (he/him) > Associate Product Manager > Wikimedia Foundation <https://wikimediafoundation.org/> > > > On Wed, Mar 27, 2019 at 9:30 AM Morten Wang <[email protected]> wrote: > > > Hi Haifeng, > > > > In my experience, this depends on how many users you're looking to get > > information about. Is it a few hundred? A few thousand? A million+? > > > > If you are getting the edit history for a limited number of users (say a > > few hundred to a few thousand), then using the API can work well. One > thing > > to keep in mind when using the API is that your requests might be > throttled > > and/or there might be database lag. Are you using a software library to > > access the API? If not, I'd consider using one so that throttling/lag > > doesn't become an issue, it's one of the reasons why I use Pywikibot > > <https://www.mediawiki.org/wiki/Manual:Pywikibot> for API requests. > > > > If you're interested in querying a large number of users (say tens of > > thousands or more), then getting an account on Toolforge > > <https://tools.wmflabs.org> so you can run SQL queries against the > > replicated MediaWiki databases would make sense. I've frequently used > that > > approach for data gathering for research purposes. > > > > Hope that helps! And if not, don't hesitate to ask questions :) > > > > > > Cheers, > > Morten > > > > On Wed, 27 Mar 2019 at 07:22, Haifeng Zhang <[email protected]> > > wrote: > > > > > Dear folks, > > > > > > Is there a good way to query a user's edit history, e.g., edit count > > > during a period? > > > > > > My current solution is using usercontribs API ( > > > https://www.mediawiki.org/wiki/API:Usercontribs). > > > > > > But, the process has been stalled maybe due to some query limit. > > > > > > > > > Thanks, > > > > > > Haifeng Zhang > > > _______________________________________________ > > > Wiki-research-l mailing list > > > [email protected] > > > https://lists.wikimedia.org/mailman/listinfo/wiki-research-l > > > > > _______________________________________________ > > Wiki-research-l mailing list > > [email protected] > > https://lists.wikimedia.org/mailman/listinfo/wiki-research-l > > > _______________________________________________ > Wiki-research-l mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/wiki-research-l > _______________________________________________ Wiki-research-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wiki-research-l
