25
$\begingroup$

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.

$\endgroup$
  • 2
    $\begingroup$ welcome!! @GolovachLena $\endgroup$ – what'sup Oct 10 '13 at 22:05
  • 4
    $\begingroup$ Seems to me like a good addition to the milestones page. $\endgroup$ – Dan Rust Oct 10 '13 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 Sleziak Oct 11 '13 at 6:09
  • 2
    $\begingroup$ @Martin: Also the user number includes unregistered accounts. $\endgroup$ – Asaf Karagila Oct 15 '13 at 22:30
  • 1
    $\begingroup$ Over 100000 as of January 22, 2014; added to the history thread. $\endgroup$ – user127096 Feb 25 '14 at 3:16
15
$\begingroup$

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.

$\endgroup$
  • 5
    $\begingroup$ And as I type this it’s down to $81117$. $\endgroup$ – Brian M. Scott Oct 13 '13 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$ – Martin Sleziak Oct 15 '13 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$ – user98130 Oct 16 '13 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$ – user98130 Oct 16 '13 at 0:37
  • $\begingroup$ 98766 users as of my writing this. $\endgroup$ – 6005 Jan 13 '14 at 12:48
29
$\begingroup$

... 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.

$\endgroup$
  • 3
    $\begingroup$ seems like reason to celebrate..... $\endgroup$ – Eleven-Eleven Oct 11 '13 at 1:40
  • 11
    $\begingroup$ Classic. ${}{} $ $\endgroup$ – The Chaz 2.0 Oct 11 '13 at 2:29
  • 5
    $\begingroup$ Very ironic.... $\endgroup$ – Prism Oct 11 '13 at 2:36
  • 7
    $\begingroup$ And every comment ends with " Golovach Lena is Love!!!"... $\endgroup$ – user61527 Oct 11 '13 at 3:59
  • $\begingroup$ @T.Bongers Hmm, is seems that the comments have been edited to remove the phrase. $\endgroup$ – Joel Reyes Noche Oct 16 '13 at 6:17
3
$\begingroup$

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

http://beyondrelational.com/modules/2/blogs/77/posts/19500/0267-sql-server-identity-columns-myths-identity-columns-cannot-have-holes-or-gaps.aspx

$\endgroup$

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .