Current area: HOME -> Blogs -> pheaven's Blog -> Read Post

Google Trends of Programming Languages

Posted on Tuesday, February 26, 2008 at 3:23 PM
Google Trends allows you to compare the popularity of various search terms. A friend pointed me at this, having put Java into it and noted a "dropping trend". I played around with it for a while, sticking in various language names, and came away with more questions than answers.

How to write stupid conclusions

The obvious but stupid way to write a blog post based upon Google trends would be to look at the graph for Java, look at the graph for Lua (a recent scripting language suited to embedding) and spurt out things like, "OMGWTFBBQ LOOK! Java is getting less popular and Lua is getting more popular!". Let's look more carefully at this, though.

The giveaway that we have a bogus conclusion here can be found by taking a look at the list of related news stories to the right. For Java, most of them - all but one at the time of writing - are not about the Java programming language, but instead about an unfortunately disaster-prone Indonesian island. Looking at the ones for Lua are even more telling - none of them are about the programming language, but instead about a football player. Also, spot the correlation of the main graph with the rise in news stories. This makes our analysis of the Lua language becoming hugely more popular based upon this graph bogus. It may be gaining popularity, but we aren't going to learn that from Google Trends.

Finally, plotting them on the same graph shows that the scales of the two previous graphs were completely different, and that the increase in searches for Lua, even if it they were to be about the programming language, is barely visible once you put the two on the same scale.

Why would people search by language name anyway?

I think the two main reasons people would search for a programming language are:
  • They are considering using it or learning it and are looking for resources to help with this
  • They are already using it and want help solving a problem or want to learn more
The first of these is indicative of growing interest in a language, and an increasing number of searches may point at that. The second may not be such a good indicator of usage, however. Once you have a number of experienced users, and if the language ships with good documentation, it is possible to have high usage with a relatively low number of people going to search results to find resources. There may well be good resource sites that a lot of developers go to rather than Googling it.

Therefore, it's not completely unreasonable to suggest that a declining number of searches may indicate that a language is retaining its current userbase, but attracting less new users. Therefore its userbase may be remaining relatively constant. Of course, this may not be the case too.

You can make arguments like this all day, but the point I'm trying to make is that you can't necessarily map number of searches onto size of user base and expect to come to correct conclusions.

Disappearing Programmers?

Let's assume that searches tell us something about take-up of a language, even if not overall usage. I did a plot of the big four dynamic languages (Perl, PHP, Python and Ruby). This showed the Perl and PHP were both being searched for less. However, despite the fanfare about Ruby, with the Rails framework, there is no sign of a proportional increase in searches for Ruby. So where are those that were using Perl and PHP going, if they are declining? Not Java, it would appear, since that would also appear to be getting less searches. C# or .Net? Nope, one is steady and the other shows a slight drop.

In fact, I'm finding it near impossible to find any programming language on Google Trends with a rising trend. Clearly, programmers must be a dying breed, or they are doing less searches, anyway. So what does that mean? If we don't want to believe that less programming is happening overall and just that searches are happening less, then it would suggest that those with declining trends are not declining so steeply, and that those with steady trends are actually rising in usage. There still seems to be something of a gap between the falling and rising. Then, I Am Not A Statistician.

Conclusions

So after an hour of playing with Google Trends, I'm left feeling like the most interesting thing I've learned is that you're more likely to be taking the weekend off if you're a C# programmer rather than a C++ one. So there's one reason for me to be happy I'm using C#, anyway. But in all seriousness, I'm very much left with the feeling that the Google Trends data is probably not especially useful for trying to get an idea of relative programming language usage. Now, is it the weekend yet?

Comments
Very interesting - Posted on Wednesday, February 27, 2008 at 9:05 AM by Eloc Jcg
Wow, that's a useful tool. I like the fact that you can even order it by country and then by region.
Try something else - Posted on Monday, March 03, 2008 at 10:28 AM by stjepano
Try something else like Java programming, Lua programming or C# tutorials, Java tutorials...
Disambiguating searches for metrics is hard - Posted on Thursday, May 01, 2008 at 7:17 AM by arbingersys
I have created a site, LUI - Language Usage Indicators, which gives a list of different metrics for comparison.

It includes web search metrics, but also aggregates data from programming project sites and discussion groups. I don't think any one metric is going to be enough, so I added as many as I could. You can also inspect the way the data was calculated by downloading the crawler that generates the numbers.
http://vredit.wikidot.com/free-credit-report - Posted on Monday, May 12, 2008 at 4:24 PM by http://vredit.wikido
http://vredit.wikidot.com/free-credit-report
http://vredit.wikidot.com/free-annual-credit-report
http://vredit.wikidot.com/free-credit-report-com
http://vredit.wikidot.com/free-online-credit-report
http://vredit.wikidot.com/my-free-credit-report
http://vredit.wikidot.com/free-credit-report-on-line
http://vredit.wikidot.com/free-credit-report-and-score
http://vredit.wikidot.com/free-credit-report-government
http://vredit.wikidot.com/free-credit-score-report
http://vredit.wikidot.com/free-anual-credit-report
http://vredit.wikidot.com/get-a-free-credit-report
http://vredit.wikidot.com/www-free-credit-report-com
http://vredit.wikidot.com/get-free-credit-report
http://vredit.wikidot.com/free-yearly-credit-report
http://vredit.wikidot.com/free-credit-reports
http://vredit.wikidot.com/credit-report-for-free
http://vredit.wikidot.com/experian-free-credit-report
http://vredit.wikidot.com/free-annual-credit-report-com
http://vredit.wikidot.com/free-credit-report-no-credit-card
http://vredit.wikidot.com/free-credit-report-gov
http://vredit.wikidot.com/free-copy-of-credit-report
http://vredit.wikidot.com/free-instant-credit-report
http://vredit.wikidot.com/free-credit-report-no-credit-card-required
http://vredit.wikidot.com/totally-free-credit-report
http://vredit.wikidot.com/free-annual-credit-reports
http://vredit.wikidot.com/free-credit-reports-online
http://vredit.wikidot.com/how-to-get-a-free-credit-report
http://vredit.wikidot.com/my-free-credit-report-com
http://vredit.wikidot.com/your-free-credit-report
dfg - Posted on Sunday, May 18, 2008 at 11:16 PM by dfg
http://mortage.wikidot.com/mortgage-calculator
http://mortage.wikidot.com/flash-mortgage-calculator
http://mortage.wikidot.com/mortgage-calculator-plus
http://mortage.wikidot.com/complete-mortgage-calculator
http://mortage.wikidot.com/mortgage-calculator-com
http://mortage.wikidot.com/www-mortgage-calculator
http://mortage.wikidot.com/mortgage-calculator-for-website
http://mortage.wikidot.com/mortgage-calculator-software
http://mortage.wikidot.com/free-mortgage-calculator
http://mortage.wikidot.com/c-mortgage-calculator
http://mortage.wikidot.com/business-mortgage-calculator
http://mortage.wikidot.com/mortgage-calculator-download
http://mortage.wikidot.com/mortgage-calculators
http://mortage.wikidot.com/free-mortgage-calculators
http://mortage.wikidot.com/aol-mortgage-calculator
http://mortage.wikidot.com/quick-mortgage-calculator
http://mortage.wikidot.com/calc-mortgage
http://mortage.wikidot.com/mortgage-calculator-html
http://mortage.wikidot.com/calculate-your-mortgage
http://mortage.wikidot.com/financial-mortgage-calculator
http://mortage.wikidot.com/mortgage-calculator-new-york
http://mortage.wikidot.com/easy-mortgage-calculator
http://mortage.wikidot.com/mortgage-rates-calculator
http://mortage.wikidot.com/calculator-for-mortgage
http://mortage.wikidot.com/detailed-mortgage-calculator
http://mortage.wikidot.com/canadian-mortgage-calculator
http://mortage.wikidot.com/mortgage-finance-calculator
http://mortage.wikidot.com/california-mortgage-calculator
http://mortage.wikidot.com/mortgage-calculator-table
http://mortage.wikidot.com/bi-weekly-mortgage-calculators

http://allrecipes.wikidot.com/recipe
http://allrecipes.wikidot.com/chicken-recipe
http://allrecipes.wikidot.com/salmon-recipe
http://allrecipes.wikidot.com/recipes
http://allrecipes.wikidot.com/chicken-recipes
http://allrecipes.wikidot.com/all-recipes
http://allrecipes.wikidot.com/cake-recipes
http://allrecipes.wikidot.com/cheesecake-recipe
http://allrecipes.wikidot.com/cookie-recipe
http://allrecipes.wikidot.com/cake-recipe
http://allrecipes.wikidot.com/smoothie-recipe
http://allrecipes.wikidot.com/salad-recipes
http://allrecipes.wikidot.com/food-recipes
http://allrecipes.wikidot.com/drink-recipes
http://allrecipes.wikidot.com/recipes-com
http://allrecipes.wikidot.com/a-recipe
http://allrecipes.wikidot.com/food-recipe
http://allrecipes.wikidot.com/cookie-recipes
http://allrecipes.wikidot.com/dessert-recipes
http://allrecipes.wikidot.com/salsa-recipe
http://allrecipes.wikidot.com/healthy-recipes
http://allrecipes.wikidot.com/easy-recipes
http://allrecipes.wikidot.com/pancake-recipe
http://allrecipes.wikidot.com/cocktail-recipe
http://allrecipes.wikidot.com/soup-recipes
http://allrecipes.wikidot.com/salmon-recipes
http://allrecipes.wikidot.com/chili-recipe
http://allrecipes.wikidot.com/crock-pot-recipes
http://allrecipes.wikidot.com/dinner-recipes
http://allrecipes.wikidot.com/bread-recipes ers


Sponsored links

Localize software in three simple steps
Localize .Net, C/C++ & Delphi apps visually. HTML, HTML Help, XML & databases. Try Sisulizer now!
Localize Delphi software in three simple steps
Localize Delphi VCL & .Net apps visually. Plus HTML, HTML Help, XML & databases. Try Sisulizer now!
Web based bug tracking - AdminiTrack.com
AdminiTrack offers an effective web-based bug tracking system designed for professional software development teams.
Computer Professionals: Are you owed Overtime?
Federal and State Laws may allow computer professionals to collect overtime. Our law firm is experienced, and has initiated class action lawsuits against some of the largest computer companies to collect back pay and overtime. Strictly Confidential.
CSTSOFT Instrumentation .NET & ActiveX Components
A collection of 13 instrumentation .NET/ActiveX/VCL components including Gauge,Knob,LED,Trend etc.


Newsletter | Submit Content | About | Advertising | Awards | Contact Us | Link to us |
© 1996-2008 Community Networks Ltd All rights reserved. Reproduction in whole or in part, in any form or medium without express written permission is prohibited. Violators of this policy may be subject to legal action. Please read Terms Of Use and Privacy Statement for more information. Development by Synchron Data - .NET development.