Math.Stackexchange.com welcomes its $100\,000^{\text{th}}$ user. I don't think you'll get cookies, but even better you'll get your questions answered.
-
2$\begingroup$ welcome!! @GolovachLena $\endgroup$– what'supCommented Oct 10, 2013 at 22:05
-
4$\begingroup$ Seems to me like a good addition to the milestones page. $\endgroup$– Dan RustCommented Oct 10, 2013 at 22:23
-
11$\begingroup$ Well, if there is a user with number 100000, this does not exactly mean that MSE has 100000 users. Merged accounts, deleted users, probably other things,.... (But it definitely is a close approximation.) $\endgroup$– Martin SleziakCommented Oct 11, 2013 at 6:09
-
2$\begingroup$ @Martin: Also the user number includes unregistered accounts. $\endgroup$– Asaf Karagila ModCommented Oct 15, 2013 at 22:30
-
1$\begingroup$ Over 100000 as of January 22, 2014; added to the history thread. $\endgroup$– user127096Commented Feb 25, 2014 at 3:16
3 Answers
Looking at the UserId is a serious overestimate. The query
SELECT COUNT(Id) AS NumberOfUsers FROM Users
returns 82335
, based on the data from October 13. (This includes both registered and unregistered accounts.)
Since September 1, new users are joining at the rate of about 180/day, see new users per day. If this continues, the user base will reach 100000 in about 3 months.
The most up-to-date available count of users (also including unregistered) is in the list of SE sites (link pointed out by Martin Sleziak). Mouse over the number of users to get a more precise figure.
The older version of this post used
SELECT COUNT(*) AS NumberOfUsers FROM Users
which undercounts table rows by a thousand or so, for reasons that transcend my limited knowledge of SQL.
-
5$\begingroup$ And as I type this it’s down to $81117$. $\endgroup$ Commented Oct 13, 2013 at 22:34
-
$\begingroup$ BTW number of the users is shown in the list of sites in SE network, too. (I am not sure how often it is updated.) This number says 82848 at the moment. $\endgroup$ Commented Oct 15, 2013 at 18:17
-
$\begingroup$ @MartinSleziak The site list at stackexchange.com is updated at least daily, so it may be the best approximation to the current number of users. It's at
82904
now. $\endgroup$ Commented Oct 16, 2013 at 0:06 -
$\begingroup$ @BrianM.Scott Thanks for pointing out the drop; this was certainly an SQL artifact rather than an actual drop in the number of users. I modified the query to obtain a hopefully correct count. $\endgroup$ Commented Oct 16, 2013 at 0:37
-
$\begingroup$ 98766 users as of my writing this. $\endgroup$ Commented Jan 13, 2014 at 12:48
... and closes her* post as off-topic.
This question is missing context or other details
- assuming the name is real, which I doubt.
Golovach Lena => Головач Лена => "голова члена" => "head of the penis". An old old joke.
-
3$\begingroup$ seems like reason to celebrate..... $\endgroup$ Commented Oct 11, 2013 at 1:40
-
11
-
5
-
7$\begingroup$ And every comment ends with " Golovach Lena is Love!!!"... $\endgroup$– user61527Commented Oct 11, 2013 at 3:59
-
$\begingroup$ @T.Bongers Hmm, is seems that the comments have been edited to remove the phrase. $\endgroup$– JRNCommented Oct 16, 2013 at 6:17
As others have pointed out, these kind of ID numbers (usually surrogate database keys) should not be used to count table rows, even disregarding deleted/merged accounts. Databases often produce "holes" in the sequence, (and that's considered ok) because of the need to deal with concurrency and transactions.
https://stackoverflow.com/questions/3404244/values-missing-in-postgres-serial-field/3405490#3405490