[Wikitech-l] SQL

hi, I want to find something in wikidb. But I don't exectly know how to use the select statement write in WIKI. For ecample . DatabaseBase::select ($ table, $ vars, $ conds = '', $ fname = 'Database::select', $ options = array(), $ join_conds = array() ) How can I use this to rewrit

[Wikitech-l] JS2

JS2 has been demerged out of trunk and into the js2-work branch, so that we can start making some progress again towards the release of 1.16, and the deployment of the current trunk to Wikimedia. The relevant code is not ready for beta testing, the problems with it are plain to see on code review.

Re: [Wikitech-l] SQL

李琴 wrote: > hi, > > I want to find something in wikidb. But I don't exectly know how to use the > select statement write in WIKI. > > For ecample . > DatabaseBase::select ($ table, > $ vars, > $ conds = '', > $ fname = 'Database::select', > $ options = array(), > $ join_conds = array()

Re: [Wikitech-l] SQL

2009/11/26 Tim Starling : > Don't use subselects, they're not supported by MySQL 4.0 which is what > we target. > > $dbr = wfGetDB( DB_SLAVE ); > > $max = $dbr->selectField( >        'recentchanges', >        'max(rc_id)', >        false, >        __METHOD__, >        array( 'GROUP BY' => 'rc_title

[Wikitech-l] Single-revision deletion expansion to administrators

There are a few bugs open on granting single-revision deletion rights to administrators on English () and German () Wikipedias, as well as all Wikimedia sites (

Re: [Wikitech-l] Size of DB/table of enwiki after import into MySQL

On Thu, Nov 26, 2009 at 12:23 AM, Greg Sabino Mullane wrote: > Frankly, the choice of using PHP as the language for MediaWiki has > probably caused more problems over the years than the choice of database > backend. :) > so what are your suggestion? use Java? ___

Re: [Wikitech-l] SQL

hi.sorry to borther again I want to ask how to rewrite those statement ,too. Like '>,<,LIMIT '. And when I use 'order by ' how to change the order of 'ASC,DESC'? Thanks very much. vanessa lee -Original Message- From: Roan Kattouw To: Wikimedia developers Date: Thu, 26 Nov 200

Re: [Wikitech-l] SQL

2009/11/26 李琴 : >  hi.sorry to borther again > > I want to ask how to rewrite those  statement ,too. > > Like '>,<,LIMIT '. > > And when I use 'order by '  how to change the order of 'ASC,DESC'? > LIMIT and ORDER BY are similar to GROUP BY, which Tim already demonstrated. ASC and DESC can just be a

Re: [Wikitech-l] Size of DB/table of enwiki after import into MySQL

On Thu, Nov 26, 2009 at 8:29 AM, Ryan Chan wrote: > so what are your suggestion? > > use Java? Python! ___ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l

Re: [Wikitech-l] JS2

I wrote: > JS2 has been demerged out of trunk and into the js2-work branch, so > that we can start making some progress again towards the release of > 1.16, and the deployment of the current trunk to Wikimedia. > > The relevant code is not ready for beta testing, the problems with it > are plain t

Re: [Wikitech-l] Single-revision deletion expansion to administrators

Andrew Garrett wrote: > There are a few bugs open on granting single-revision deletion > rights to administrators on English > () and German > () > Wikipedias, as well as all Wikimedia sites