Phew, here we go, this blog post has been long time coming! A few months ago I started toying around with the idea of analyzing the PlanetMySQL public blog feed. It doesn’t take long to extract the data and prepare it for analysis but between lots of work and procrastination this blog post was left unfinished.
It was partly out of pure curiosity and partly the fact that it seemed to me there were less posts than previous years that I decided to trend out the number of posts over the past years and here we go.
The blue line shows the blog posts per month over the past six years and the black line is a polynomial trend line. There are a few points of interest which are visible and I’ll be listing here (to all their understanding):
1. The first thing which struck me negatively is that there is a decrease in posts unfortunately.
2. When sun bought mysql and oracle bought sun there is a major increase in blog posts (some political, some not) lasting months.
3. Every April there is a spike in blog posts (guess what … spot on, it’s the User Conference fever :) which will soon start again for 2011 ;)).
Now for a deeper analysis, I then separated the groups on their own, community, employees, teams and employee teams:
*** Please note that when a MySQL, Sun, Oracle employee changes status, any blog posts by that person will shift to a new group.
The same trend continues obviously, community and employees have somewhat reduced their blogging and teams and employee teams have slightly increased or kept on blogging (keep it up guys).
The community does need to move it and start blogging again, so I hope this serves a bit of a wakeup call.
More of these analysis will follow. I want to extract the list of most active bloggers in the past 6 years as well as those most active in 2010 and give thanks where is due!
Because Sharing is Caring
MySQL community blogging – PlanetMySQL,