Dries Buytaert

Mollom volume segmentation

When people sign up to protect their website against spam with Mollom, they are asked to categorize each of their sites. So far, almost 2,000 Drupal sites have been categorized. The available categories are: a company website (22%), a site built for a customer (7%), a non-profit website (27%) or a personal website (44%).

It is only one data point and a relatively small sample so I don't know if it is safe to generalize, but I figured it was an interesting nugget that could help us understand Drupal's install base.

Drupal.org country demographics

Where is the Drupal community from? Every registered user on http://drupal.org can optionally specify what country he or she is from. I've used that information to render the table below. How is your country doing?

	Current		One year ago		Two years ago
Country	Rank	%	Rank	%	Rank	%
United States	1	33.12	1	35.54	1	31.36
India	2	5.68	3	4.89	4	4.14
United Kingdom	3	5.14	2	5.8	2	5.07
Afghanistan (see comments)	4	4.64	13	1.49	13	1.12
Canada	5	4.23	4	4.79	3	4.26
Germany	6	3.03	5	2.78	6	2.32
Australia	7	2.22	7	2.47	7	2.14
China	8	1.95	6	2.59	5	2.36
Spain	9	1.91	8	2.16	8	1.91
Netherlands	10	1.84	10	1.91	10	1.66
Italy	11	1.83	9	1.95	9	1.71
France	12	1.79	12	1.53	12	1.31
Russian Federation	13	1.59	14	1.29	14	1.06
Indonesia	14	1.58	17	1.1	17	0.93
Brazil	15	1.58	11	1.69	11	1.49
Belgium	16	1.35	15	1.25	15	1.04
Hungary	17	1.03	18	0.92	19	0.78
Philippines	18	0.99	19	0.9	18	0.79
Turkey	19	0.97	16	1.12	16	0.99
Poland	20	0.91	22	0.74	23	0.63
Sweden	21	0.81	20	0.83	20	0.72
Viet Nam	22	0.77	27	0.62	26	0.54
Thailand	23	0.75	24	0.71	25	0.59
Malaysia	24	0.72	21	0.76	21	0.68
Mexico	25	0.69	23	0.71	24	0.6
South Africa	26	0.69	25	0.7	22	0.64
Czech Republic	27	0.65	29	0.59	28	0.52
Argentina	28	0.57	26	0.63	27	0.53
Romania	29	0.57	32	0.53	33	0.45
Ukraine	30	0.54	41	0.43	42	0.35
Denmark	31	0.52	33	0.52	32	0.46
Portugal	32	0.52	28	0.59	29	0.52
Switzerland	33	0.5	39	0.45	41	0.36
Israel	34	0.47	36	0.47	39	0.39
Norway	35	0.46	30	0.55	31	0.48
Iran	36	0.46	42	0.43	40	0.37
New Zealand	37	0.45	37	0.46	36	0.41
Singapore	38	0.44	31	0.54	30	0.49
Pakistan	39	0.44	44	0.4	45	0.33
Austria	40	0.43	43	0.41	43	0.34

Update: snufkin used this data to create some cool pie charts.

Drupal Association 2008 wishlist

Since we launched the Drupal Association in January 2007, roughly one year ago, we (i) improved the drupal.org infrastructure, (ii) we helped organize two international Drupal conferences, (iii) we established a relation with an accounting firm, (iv) we funded Drupal's presence at a number of events, (v) we started setting up fundraising campaigns, (vi) we entered into a relation with the Software Freedom Law Center, (vii) we are close to launching a Drupal Association membership model, etc.

In January 2008 we have to elect our second Board of Directors. We are looking for people that want to become either a Permanent Member or a member of the Board of Directors, and that can provide leadership and experience to expand the reach of the Drupal Association and its activities. If you are interested in helping to drive Drupal's explosive growth or if you want to help make a change in this world, you can submit your candidacy by following the instructions on drupal.org.

A few months ago, I asked more than 1,000 Drupal users what they think the Drupal Association should focus on. The results are provided below and might be a good source of inspiration when considering to submit your candidacy.

Drupal.org wishlist

I asked more than 1,000 existing Drupal users (not Drupal prospects) what they would like to see improved on drupal.org. A prioritized wish list is provided below.

We also created a drupal.org redesign group: if you are interested in collaborating on a drupal.org redesign or helping with the drupal.org infrastructure, you know where to start. We have work to do!

Drupal training videos

Hagen Graf, author of a German Drupal book, recently donated 700 EUR to the Drupal Association. This money comes from a German Drupal 5 training video that he made together with Video2brain. For every copy they sold, 1.25 EUR was set aside for the Drupal Association, and over the course of six months, this added up to a 700 EUR donation.

If you do the math, it is easy enough to figure out that they sold 600 copies in 6 months. So not only did they contribute 700 EUR to the Drupal Assocation, they also helped 600 Germans to get started with Drupal. A double hit!

Assuming that the above is correct and given that the DVD sells for 39,95 EUR a copy, it means that this German training video generated roughly 24,000 EUR in revenue. I don't know how much of that is left after they extract all the expenses, discounts and donations, but it does make me wonder about the potential of a Drupal training video recorded in English ...

Drupal community skills

I asked more than 1,000 Drupal users what they are good at and what skills they'd like to invest in. The results are provided below, and might be of interest for upcoming Drupal book authors, the Drupal documentation team, or those of us who want to flatten the Drupal learning curve.

We are good at

1. HTML
2. Administering Drupal
3. CSS
4. PHP
5. System administration

We suck at

1. Flash/Flex
2. Module development
3. Performance, scalability, high-availability
4. Marketing/evangelizing
5. Javascript/JQuery

We want to get better at

1. Module development
2. Theme development
3. Javascript/JQuery
4. PHP
5. Performance, scalability, high-availability

CMS code base comparison

Drupal

Joomla!

Wordpress

Plone

(These graphs depict statistics for the core of each project, and do not include contributed modules, extensions or third-party plugins.)

Conclusions

• All projects have been growing in size. No exceptions.
• Drupal has, by far, the smallest code base. It's lean and mean. Joomla!'s code base is about 8 times bigger than Drupal's. Even Wordpress's code base is larger than Drupal's.
• Of all tools, the Wordpress code has the fewest code comments. Drupal and Joomla!, on the other hand, have the best documented code.