[development] Compiling Drupal statistics

[Walt Daniels]

The number of active installations is going to be really hard to get right,
at least if others behave as I do. I have 14 installs that are probably in
your count but only 7 of them are real sites with outside users. The others
are all test or build sites. They aren't even visible enough to attract
spammers. But perhaps I only get a count of one, because I have a copy of
5.7 that I ftp to a site to get it started. I don't get a new copy for each
site.

Perhaps there could be some module that is installed as part of core that
makes something visible enough to Google that you can use a count of it to
count active installs. Then ask people who install test accounts to turn off
that module. Put a message in the Status report that forces admins to at
least visit a page and given the opportunity to get it right.

-----Original Message-----
From: development-bounces at drupal.org [mailto:development-bounces at drupal.org]
On Behalf Of Angela Byron
Sent: Sunday, May 18, 2008 1:42 AM
To: development at drupal.org
Subject: [development] Compiling Drupal statistics

As tends to happen every 6 months or so, I got asked to compile some 
statistics about Drupal: number of active installations, number of users 
on drupal.org, stuff like that. Each time I try to figure this out it's 
a time-sink of hours and hours and hours. :( And I think most of us get 
asked to compile this information from time to time as well, either on 
behalf of our bosses or because we're giving a presentation somewhere, 
or whatever.

So this time, I threw all the queries I was running into a .php file @ 
tricks/drupal_org_statistics. Per killes, I did not create a new 
permanent PHP page for these statistics on drupal.org, but I did run 
this in a PHP node preview and it came up with the following:

http://cvs.drupal.org/viewvc.py/drupal/contributions/tricks/drupal_org_stats
/output-2008-05-18.html?revision=1.1&content-type=text%2Fhtml

NOTE: There's a bug in the "# of active Drupal installations" query... 
the query that's giving me the list of most used modules reports about 
486,000 active Drupal installations. Feel free to fix it if you figure 
out what the bug is.

If you want to help improve this script, grab a copy of the drupal.org 
testing installation profile 
(http://drupal.org/project/drupalorg_testing) and commit any additional 
queries that you feel would be helpful for admins to compile on a 
semi-regular basis (SELECTs only, naturally :P).

Incidentally, the module/Drupal usage stats will become publicly visible 
as soon as http://drupal.org/node/165380 has been reviewed and 
committed. Anyone who wants to become the next Drupal hero might want to 
jump on that.

-Angie