[Author Prev][Author Next][Thread Prev][Thread Next][Author Index][Thread Index]
Re: [tor-bugs] #10699 [Tor Weather]: Find out how many users are currently subscribed to Weather
#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
_______________________________________________
tor-bugs mailing list
tor-bugs@xxxxxxxxxxxxxxxxxxxx
https://lists.torproject.org/cgi-bin/mailman/listinfo/tor-bugs