From Meta, a Wikimedia project coordination wiki
[[Category:Schemas (Mobile Apps team)]]
Table name on stat1003 (linking to schema version)
LEFT(MIN(timestamp),8)
Android app versions that feed this table SELECT DISTINCT MID(LEFT(userAgent,INSTR(userAgent," ")-1),INSTR(userAgent,"/")+1) AS app_version FROM ... WHERE userAgent LIKE '%Android%' ORDER BY app_version;
MobileWikiAppToCInteraction_14585319 20151113
2.1.134-2.1.143 (r, releasesprod, beta, amazon, fdroid), 2.1.241 beta [sic]
2.1.134-amazon-2015-11-12
(updated 2016-03-24)
MobileWikiAppToCInteraction_11014396 20150120
2.0 from 2015-03-23 on, and 2.0.101-2.1.133 (r, releasesprod, amazon, fdroid, beta, dev, tmy)
2.0-alpha-2015-01-20
(updated 2016-01-01)
MobileWikiAppToCInteraction_10375484 20141031
...
2.0-dev-2014-10-30
(updated November 2015)
MobileWikiAppToCInteraction_8461467 20140510
...
2.0-alpha-2014-05-09
(updated November 2015)
(All four tables are still recording data, i.e. contain rows with timestamp as of today.)
Android team, can you check the app version information in the rightmost column above, and help consolidate it by relating it to code changes in the app? E.g. in the last row, we might be able to say "All alpha versions from 2.0-alpha-2014-05-09 until 2.0-alpha-2014-11-03" instead of the query output that is listing all them separately. (Just as an example; for the analysis we are planning it's more important to get the production releases in the two most recent versions of the schema right.)
Regards, Tbayer (WMF) (talk ) 21:36, 25 November 2015 (UTC) [ reply ]
on IRC and he confirmed that the latest version of the schema only corresponds to 2.1.134 (and later), and that the next-to-latest version corresponds to production releases as early as 2015-03-23. I have consolidated the table above accordingly. He was also going to send the exact git revisions marking the introduction of each new schema version, but for now this might already be enough - I will leave phab:T119664 open for a bit longer until we know that no more information is needed for the current analysis. Regards, Tbayer (WMF) (talk ) 17:50, 2 January 2016 (UTC) [ reply ] 
.svg)