[tor-bugs] #10699 [Tor Weather]: Find out how many users are currently subscribed to Weather

Tor Bug Tracker & Wiki blackhole at torproject.org
Mon Jan 27 09:54:07 UTC 2014


#10699: Find out how many users are currently subscribed to Weather
-----------------------------+-----------------------------
     Reporter:  karsten      |      Owner:  karsten
         Type:  task         |     Status:  closed
     Priority:  normal       |  Milestone:
    Component:  Tor Weather  |    Version:
   Resolution:  fixed        |   Keywords:  weather-rewrite
Actual Points:               |  Parent ID:
       Points:               |
-----------------------------+-----------------------------
Changes (by karsten):

 * status:  new => closed
 * resolution:   => fixed


Comment:

 Here's a quick analysis of Weather's database:

 1. How many subscriptions are there in the database?  1 subscription means
 1 human subscribing to 1 router.

 {{{
 sqlite> SELECT COUNT(*) FROM weatherapp_subscriber;
 2394
 }}}

 2. How many distinct email addresses have subscribed to notifications,
 that is, how many different humans are using Weather?

 {{{
 sqlite> SELECT COUNT(*) FROM (SELECT email FROM weatherapp_subscriber
 GROUP by email);
 1846
 }}}

 3. How many subscriptions have been added per month?  Are these all just
 old subscriptions, or are new subscriptions coming in on a stable basis?

 {{{
 sqlite> SELECT strftime('%Y-%m', sub_date), COUNT(*) FROM
 weatherapp_subscriber GROUP BY strftime('%Y-%m', sub_date);
 2010-10|2
 2010-12|1
 2011-01|20
 2011-02|25
 2011-03|14
 2011-04|5
 2011-05|14
 2011-06|11
 2011-07|15
 2011-08|9
 2011-09|6
 2011-10|7
 2011-11|15
 2011-12|10
 2012-01|20
 2012-02|31
 2012-03|19
 2012-04|25
 2012-05|25
 2012-06|5
 2012-07|29
 2012-08|30
 2012-09|17
 2012-10|27
 2012-11|31
 2012-12|49
 2013-01|92
 2013-02|83
 2013-03|108
 2013-04|89
 2013-05|104
 2013-06|129
 2013-07|133
 2013-08|207
 2013-09|189
 2013-10|182
 2013-11|170
 2013-12|182
 2014-01|264
 }}}

 4. How many notification types are in the database?  There can be more
 than 1 notification type per subscription: node is down, version is not
 recommended, bandwidth is too low, qualifies for t-shirt.

 {{{
 sqlite> SELECT COUNT(*) FROM weatherapp_nodedownsub;
 2336
 sqlite> SELECT COUNT(*) FROM weatherapp_versionsub;
 2157
 sqlite> SELECT COUNT(*) FROM weatherapp_bandwidthsub;
 1211
 sqlite> SELECT COUNT(*) FROM weatherapp_tshirtsub;
 2122
 }}}

 In summary, I think Weather has a fairly stable number of users.  We
 shouldn't take away the service from them if we can avoid it.

 I'm closing this ticket, because we have the numbers we need.  We can
 still continue the discussions whether numbers are high enough for the
 effort to fix Weather.  But let's discuss that outside of this ticket.

--
Ticket URL: <https://trac.torproject.org/projects/tor/ticket/10699#comment:3>
Tor Bug Tracker & Wiki <https://trac.torproject.org/>
The Tor Project: anonymity online


More information about the tor-bugs mailing list