Schema talk:MobileWikiAppToCInteraction

From Meta, a Wikimedia project coordination wiki
Jump to navigation Jump to search
J Train (1973-1979).svg
Maintainer:Mikhail Popov & Chelsy Xie
Team:Mobile Apps
Project:Mobile Apps
Status:active
Purge:Auto-purge pageId, sectionName and eventCapsule PII after 90 days, keep the rest indefinitely

[[Category:Schemas (Mobile Apps team)]]

Tables corresponding to this schema, and the app versions that use them[edit]

There are currently four different tables on stat1003 corresponding to this schema. Here's a table to record their differences, namely how they correspond to different versions of the app:

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
2.1.134-beta-2015-11-12
2.1.134-fdroid
2.1.134-r-2015-11-12
2.1.135-beta-2015-12-03
2.1.135-fdroid
2.1.136-amazon-2015-12-09
2.1.136-beta-2015-12-09
2.1.136-fdroid
2.1.136-r-2015-12-09
2.1.136-releasesprod-2015-12-09
2.1.137-beta-2016-01-11
2.1.137-fdroid
2.1.137-r-2016-01-11
2.1.137-releasesprod-2016-01-11
2.1.138-amazon-2016-01-21
2.1.138-beta-2016-01-21
2.1.138-r-2016-01-21
2.1.139-beta-2016-01-22
2.1.139-fdroid
2.1.139-r-2016-01-22
2.1.139-releasesprod-2016-01-22
2.1.140-beta-2016-02-04
2.1.140-fdroid
2.1.141-amazon-2016-02-10
2.1.141-beta-2016-02-10
2.1.141-fdroid
2.1.141-r-2016-02-10
2.1.141-releasesprod-2016-02-10
2.1.142-beta-2016-03-07
2.1.143-beta-2016-03-16
2.1.143-r-2016-03-16
2.1.241-beta-2016-03-03

(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
2.0-beta-2015-01-28
2.0-alpha-2015-02-13
2.0-beta-2015-02-19
2.0-beta-2015-02-27
2.0-alpha-2015-03-05
2.0-beta-2015-03-05
2.0-alpha-2015-03-07
2.0-beta-2015-03-09
2.0-alpha-2015-03-11
2.0-beta-2015-03-23
2.0-r-2015-03-23
2.0-beta-2015-04-03
2.0-beta-2015-04-10
2.0-releasesprod-2015-03-23
2.0-beta-2015-04-23
2.0-r-2015-04-23
2.0-alpha-2015-04-29
2.0-dev-2015-05-06
2.0-amazon-2015-04-23
2.0.101-dev-2015-05-09
2.0.101-dev-2015-05-11
2.0.102-beta-2015-05-14
2.0-releasesprod-2015-04-23
2.0.102-r-2015-05-14
2.0.101-alpha-2015-05-27
2.0.103-beta-2015-06-11
2.0-tmy-2015-04-23
2.0.103-dev-2015-06-23
2.0.102-beta-2015-06-08
2.0.103-dev-2015-06-24
2.0.103-dev-2015-06-25
2.0.104-beta-2015-06-25
2.0.104-dev-2015-06-26
2.0.105-beta-2015-06-30
2.0.105-r-2015-06-30
2.0.105-amazon-2015-06-30
2.0.102-releasesprod-2015-05-14
2.0.106-beta-2015-07-20
2.0.106-beta-2015-07-30
2.0.107-beta-2015-08-03
2.0.108-beta-2015-08-04
2.0.108-r-2015-08-04
2.0.108-amazon-2015-08-04
2.0.108-r-2015-08-18
2.0.109-beta-2015-08-21
2.0.109-fdroid
2.0.104-beta-2015-06-27
2.0.110-beta-2015-08-31
2.0.110-r-2015-08-31
2.0.107-releasesprod-2015-08-03
2.0.110-amazon-2015-08-31
2.0.110-fdroid
2.0.111-beta-2015-09-16
2.0.111-r-2015-09-16
2.0.111-releasesprod-2015-09-16
2.1.131-beta-2015-09-28
2.0.111-amazon-2015-09-16
2.1.131-fdroid
2.1.132-beta-2015-10-23
2.1.133-beta-2015-10-26
2.1.132-fdroid
2.1.133-r-2015-10-26
2.1.133-fdroid
2.1.133-amazon-2015-10-26
2.0.104-beta-2015-06-26
2.0-releasesprod-2015-03-17

(updated 2016-01-01)

MobileWikiAppToCInteraction_10375484 20141031
...

2.0-dev-2014-10-30
2.0-alpha-2014-11-03
2.0-dev-2014-11-03
2.0-beta-2014-11-03
2.0-r-2014-11-03
2.0-alpha-2014-11-04
2.0-dev-2014-11-04
2.0-releasesprod-2014-11-03
2.0-alpha-2014-11-05
2.0-dev-2014-11-05
2.0-alpha-2014-11-06
2.0-dev-2014-11-06
2.0-alpha-2014-11-07
2.0-beta-2014-11-07
2.0-dev-2014-11-07
2.0-dev-2014-11-08
2.0-alpha-2014-11-09
2.0-dev-2014-11-10
2.0-alpha-2014-11-10
2.0-dev-2014-11-11
2.0-alpha-2014-11-12
2.0-dev-2014-11-12
2.0-alpha-2014-11-13
2.0-beta-2014-11-12
2.0-dev-2014-11-13
2.0-alpha-2014-11-14
2.0-dev-2014-11-15
2.0-alpha-2014-11-15
2.0-beta-2014-11-15
2.0-beta-2014-11-17
2.0-alpha-2014-11-17
2.0-beta-2014-11-18
2.0-alpha-2014-11-18
2.0-alpha-2014-11-19
2.0-dev-2014-11-19
2.0-beta-2014-11-20
2.0-alpha-2014-11-20
2.0-dev-2014-11-20
2.0-beta-2014-11-21
2.0-alpha-2014-11-21
2.0-dcg-2014-11-21
2.0-beta-2014-11-22
2.0-beta-2014-11-24
2.0-alpha-2014-11-24
2.0-alpha-2014-11-25
2.0-beta-2014-11-25
2.0-r-2014-11-26
2.0-beta-2014-11-26
2.0-alpha-2014-11-26
2.0-beta-2014-11-27
2.0-dev-2014-11-22
2.0-beta-2014-12-01
2.0-alpha-2014-12-01
2.0-r-2014-12-01
2.0-beta-2014-12-02
2.0-releasesprod-2014-12-01
2.0-alpha-2014-12-02
2.0-beta-2014-12-03
2.0-alpha-2014-12-03
2.0-beta-2014-12-04
2.0-alpha-2014-12-04
2.0-dev-2014-12-04
2.0-r-2014-12-05
2.0-alpha-2014-12-05
2.0-beta-2014-12-05
2.0-alpha-2014-12-06
2.0-r-2014-12-07
2.0-beta-2014-12-08
2.0-alpha-2014-12-08
2.0-alpha-2014-12-07
2.0-dev-2014-12-08
2.0-alpha-2014-12-09
2.0-beta-2014-12-09
2.0-dev-2014-12-09
2.0-alpha-2014-12-10
2.0-beta-2014-12-10
2.0-beta-2014-12-11
2.0-alpha-2014-12-11
2.0-r-2014-12-11
2.0-alpha-2014-12-12
2.0-alpha-2014-12-14
2.0-dev-2014-12-14
2.0-alpha-2014-12-15
2.0-alpha-2014-12-16
2.0-beta-2014-12-16
2.0-alpha-2014-12-17
2.0-beta-2014-12-17
2.0-alpha-2014-12-18
2.0-alpha-2014-12-19
2.0-beta-2014-12-19
2.0-alpha-2014-12-20
2.0-alpha-2014-12-21
2.0-alpha-2014-12-22
2.0-alpha-2014-12-23
2.0-alpha-2014-12-24
2.0-alpha-2014-12-27
2.0-alpha-2014-12-29
2.0-alpha-2014-12-30
2.0-alpha-2014-12-31
2.0-alpha-2015-01-02
2.0-alpha-2015-01-04
2.0-alpha-2015-01-05
2.0-alpha-2015-01-07
2.0-alpha-2015-01-08
2.0-alpha-2015-01-09
2.0-alpha-2015-01-10
2.0-alpha-2015-01-11
2.0-alpha-2015-01-12
2.0-alpha-2015-01-13
2.0-r-2015-01-13
2.0-beta-2015-01-13
2.0-alpha-2015-01-14
2.0-alpha-2015-01-15
1.0
2.0-r-2015-01-15
2.0-releasesprod-2015-01-15
2.0-r-2015-01-16
2.0-alpha-2015-01-16
2.0-amazon-2015-01-15
2.0-alpha-2015-01-17
2.0-dev-2015-01-16
2.0-alpha-2015-01-19
2.0-r-2015-01-20
2.0-alpha-2015-01-20
2.0-alpha-2015-01-21
2.0-alpha-2015-01-22
2.0-alpha-2015-01-23
2.0-alpha-2015-01-24
2.0-alpha-2015-01-25
2.0-alpha-2015-01-26
2.0-alpha-2015-01-27
2.0-alpha-2015-01-29
2.0-dev-2015-01-20
2.0-alpha-2015-02-05
2.0-tmy-2015-02-10
2.0-alpha-2015-02-10
2.0-releasesprod-2015-01-27
2.0-alpha-2015-02-28
2.0-alpha-2015-04-06
2.0-alpha-2015-04-10
2.0-alpha-2015-04-17
2.0-dev-2015-05-20

(updated November 2015)

MobileWikiAppToCInteraction_8461467 20140510
...

2.0-alpha-2014-05-09
2.0-alpha-2014-05-10
2.0-alpha-2014-05-14
2.0-alpha-2014-05-19
2.0-alpha-2014-05-20
2.0-alpha-2014-05-22
2.0-alpha-2014-05-25
2.0-alpha-2014-05-30
2.0-alpha-2014-06-03
2.0-beta1
2.0-beta2
2.0-alpha-2014-06-04
2.0-beta3
2.0-alpha-2014-06-05
2.0-beta4
2.0-alpha-2014-06-06
2.0-beta5
2.0-beta6
2.0-alpha-2014-06-09
2.0-beta-2014-06-12
2.0-alpha-2014-06-12
2.0-alpha-2014-06-16
2.0-beta-2014-06-17
2.0-alpha-2014-06-17
2.0-beta-2014-06-18
2.0-alpha-2014-06-18
2.0-beta-2014-06-19
2.0-beta-2014-06-23
2.0-alpha-2014-06-23
2.0-beta-2014-06-24
2.0-beta-2014-06-25
2.0-alpha-2014-06-25
2.0
2.0-alpha-2014-07-02
2.0-alpha-2014-07-10
2.0-alpha-2014-07-11
2.0-beta-2014-07-16
2.0-beta-2014-07-18
1.0
2.0-r-2014-07-23
2.0-cc-2014-07-28
2.0-beta-2014-08-04
dev
2.0-r-2014-08-07
2.0-beta-2014-08-07
2.0-qbp-2014-08-12
2.0-beta-2014-08-13
2.0-r-2014-08-13
2.0-amazon-2014-08-13
2.0-releasesprod-2014-08-13
2.0-qbp-2014-08-13
2.0-beta-2014-08-20
2.0-qcn-2014-09-04
2.0-beta-2014-09-07
2.0-beta-2014-08-26
null
2.0-beta-2014-09-09
2.0-dev-2014-09-10
2.0-dev-2014-09-11
2.0-dev-2014-09-12
2.0-beta-2014-09-12
2.0-dev-2014-09-15
2.0-dev-2014-09-16
2.0-beta-2014-09-16
2.0-dev-2014-09-17
2.0-alpha-2014-09-17
2.0-beta-2014-09-11
2.0-beta-2014-09-17
2.0-beta-2014-09-18
2.0-alpha-2014-09-18
2.0-dev-2014-09-18
2.0-beta-2014-09-19
2.0-beta-2014-09-22
2.0-beta-2014-09-23
2.0-dev-2014-09-23
2.0-dev-2014-09-24
2.0-dev-2014-09-25
2.0-dev-2014-09-26
2.0-dev-2014-09-27
2.0-alpha-2014-09-27
2.0-alpha-2014-09-28
2.0-alpha-2014-09-29
2.0-dev-2014-09-29
2.0-alpha-2014-09-30
2.0-alpha-2014-10-02
2.0-alpha-2014-10-03
2.0-dev-2014-10-06
2.0-alpha-2014-10-06
2.0-alpha-2014-09-12
2.0-alpha-2014-10-07
2.0-beta-2014-10-07
2.0-dev-2014-10-07
2.0-beta-2014-10-08
2.0-r-2014-10-08
2.0-alpha-2014-10-08
2.0-dev-2014-10-08
2.0-alpha-2014-10-09
2.0-dev-2014-10-09
2.0-alpha-2014-10-10
2.0-dev-2014-10-10
2.0-dev-2014-10-11
2.0-alpha-2014-10-11
2.0-dev-2014-10-12
2.0-alpha-2014-10-13
2.0-dev-2014-10-13
2.0-dev-2014-10-14
2.0-alpha-2014-10-14
2.0-r-2014-10-14
2.0-beta-2014-10-14
2.0-dev-2014-10-15
2.0-releasesprod-2014-10-14
2.0-alpha-2014-10-15
2.0-alpha-2014-10-16
2.0-dev-2014-10-16
2.0-amazon-2014-10-14
2.0-alpha-2014-10-17
2.0-dev-2014-10-17
2.0-beta-2014-10-18
2.0-dev-2014-10-18
2.0-alpha-2014-10-18
2.0-alpha-2014-10-20
2.0-dev-2014-10-19
2.0-r-2014-10-20
2.0-beta-2014-10-20
2.0-dev-2014-10-20
2.0-alpha-2014-10-21
2.0-dev-2014-10-21
2.0-alpha-2014-10-22
2.0-r-2014-10-22
2.0-dev-2014-10-22
2.0-alpha-2014-10-23
2.0-dev-2014-10-23
2.0-alpha-2014-10-24
2.0-alpha-2014-10-25
2.0-alpha-2014-10-26
2.0-alpha-2014-10-27
2.0-dev-2014-10-27
2.0-alpha-2014-10-28
2.0-dev-2014-10-28
2.0-qpb-2014-10-28
2.0-alpha-2014-10-29
2.0-dev-2014-10-29
2.0-beta-2014-10-29
2.0-r-2014-10-29
2.0-r-2014-10-30
2.0-dev-2014-10-30
2.0-beta-2014-10-30
2.0-releasesprod-2014-10-30
2.0-alpha-2014-10-31
2.0-alc-2014-10-31
2.0-blu-2014-10-31
2.0-mul-2014-10-31
2.0-dev-2014-10-31
2.0-alpha-2014-10-30
2.0-alpha-2014-11-01
2.0-dev-2014-11-01
2.0-dev-2014-11-02
2.0-dev-2014-11-03
2.0-beta-2014-10-31
2.0-alpha-2014-11-03
2.0-beta-2014-10-15
2.0-r-2014-12-01
H_1018.2
2.0-alpha-2014-06-24
2.0-beta-2015-03-25
2.0-beta-2015-04-12

(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)

Update: Looked at this with Dmitry 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)