http://drupalcontribstatus.com/ shows the top 61 as of whenever I started working on this site. Of course, the current http://drupal.org/project/usage page is slightly different towards the tail end. Admin role (yes), Mime mail (no), and Mollom (yes), and something else are out, and now LoginToboggan (yes), Tagadelic (no), Admin (no), and Location (no) are in.

This is obviously going to make that progress bar bounce around all over the place, which is going to be annoying when trying to feel a sense of accomplishment. :P

Ideas? Should we freeze it in time? Update once a month?

CommentFileSizeAuthor
#3 usage-0.csv_.txt2.01 KBwebchick
#2 usage-0.csv_.txt1.67 KBwebchick
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

effulgentsia’s picture

I wonder if there would be less volatility if http://drupal.org/project/usage could be sorted by D6 usage only. As D7 adoption grows, top 50 total becomes a mix of what was popular in D6 and what's available in D7, which doesn't seem as useful for what this site is intending to make visible.

webchick’s picture

FileSize
1.67 KB

That's a good suggestion.

I executed the following query, which limits the overview to only Drupal 6.x (tid 87):

SELECT n.nid, n.title, pp.uri AS week3 FROM node n INNER JOIN project_projects pp ON n.nid = pp.nid LEFT JOIN project_usage_week_project p0 ON n.nid = p0.nid AND p0.timestamp = 1311465600 AND p0.tid = 87  LEFT JOIN project_usage_week_project p1 ON n.nid = p1.nid AND p1.timestamp = 1310860800 AND p1.tid = 87  LEFT JOIN project_usage_week_project p2 ON n.nid = p2.nid AND p2.timestamp = 1310256000 AND p2.tid = 87  LEFT JOIN project_usage_week_project p3 ON n.nid = p3.nid AND p3.timestamp = 1309651200 AND p3.tid = 87 WHERE n.nid IN (SELECT nid FROM project_usage_week_project) AND n.status = 1 GROUP BY n.nid, n.title ORDER BY SUM(DISTINCT p0.count) DESC LIMIT 50

...and changed SUM(DISTINCT p0.count) to p1.count and so on. Then diffed them.

Most changes were minor shifting up or down in the list. The actual deltas were:

Between week 0 and week 1, we lost site_map and gained auto_nodetitle.
Between week 1 and week 2, we lost auto_nodetitle and gained site_map.
Between week 2 and week 3, we lost content_profile and gained contemplate.

So indeed, it seems like for the most part this is canceling each other out, so is probably a good list to use.

Here's a CSV file of the latest data.

webchick’s picture

FileSize
2.01 KB

Oops. I forgot it's top 60, not top 50.

Between week 0 and week 1, we lost admin and gained location.
Between week 1 and week 2, we lost fivestar and gained admin.
Between week 2 and week 3, we lost adminrole and gained simplenews.

So, similar. Only one module change per week. Here's the updated top 60 based on this week's data.