Earlier today someone suggested adding a tag cloud to ColdFusionBloggers. I'm just enough of a nerd to think that would be something fun to do Friday night. In the meantime, I whipped up a quick SQL statement and dumped the results into a structure and sorted it:

<cfquery name="cats" datasource="#application.dsn#"> select categories from entries where year(posted) = 2008 and categories != '' </cfquery>

<cfset d = {}> <cfloop query="cats"> <cfloop index="c" list="#categories#"> <cfif len(trim(c))> <cfif not structKeyExists(d, c)> <cfset d[c] = 0> </cfif> <cfset d[c]++> </cfif> </cfloop> </cfloop>

<cfoutput> #numberFormat(cats.recordcount)# entries. <p/> <table border="1" cellpadding="10" style="margin-top:0px;padding-top:0px;"> <tr> <th> </th> <th>Tag</th> <th>Count</th> </tr> </cfoutput>

<cfset sorted = structSort(d,"numeric", "desc")>

<cfloop index="x" from="1" to="#min(100,arrayLen(sorted))#"> <cfset k = sorted[x]> <cfoutput> <tr> <td>#x#</td> <td>#k#</td> <td>#numberFormat(d[k])#</td> </tr> </cfoutput> </cfloop> <cfoutput></table></cfoutput>

Not the prettiest code in the world, but it worked. All 3 of you using copies of the CFB code base are welcome to it. And now the results. I've printed out the top 100. The top ten aren't surprising, especially #2. It almost matches exactly with what my top 10 concerns of year were (except for Lost of course!). ColdBox shows up rather high in the list, well over Model-Glue and Fusebox. I'm not surprised to see Mac at #17.

Anyway, enjoy the table-y goodness (need to find a simple, scrollable table for static data) and forgive the huge page size.

11,813 entries.

 TagCount
1ColdFusion4,098
2Flex954
3General544
4Adobe483
5Air396
6conferences262
7Misc258
8Javascript242
9Ajax238
10Technology205
11ColdBox205
12Development200
13Flash199
14Code195
15cfml195
16Tools193
17Mac187
18Programming173
19Web Development160
20Java160
21SQL158
22Personal147
23Uncategorized143
24posts141
25Apple134
26Open Source132
27Linux129
28community129
29CFEclipse112
30Transfer107
31jQuery105
32business104
33MAX104
34security99
35Eclipse97
36cfunited95
37Presentations92
38ActionScript90
39Scotch on the Rocks87
40ColdSpring87
41Life85
42Jobs82
43Stuff80
44Oracle77
45Google77
46iPhone76
47Open-Source CF72
48Frameworks69
49ColdFusion 868
50Web Dev68
51Railo68
52Blogging67
53Work66
54Fun66
55AS366
56Appearances66
57AdobeMAX0865
58Microsoft63
59BlueDragon57
60RIA57
61Projects57
62Universal Mind55
63subversion54
64model-glue54
65Flex General53
66ruby52
67Windows52
68SixSigns51
69fusebox51
70BlazeDS50
71Adobe AIR50
72Apache50
73music48
74Applications47
75Video47
76database47
77events47
78WhosOnCFC46
79BlogCFC46
80mysql46
81Off Topic46
82HTML/ColdFusion46
83news46
84Databases46
85Random45
86Ubuntu45
87openbd44
88Default44
89.NET43
90Ask Ben42
91SQL Server42
92Reviews42
93mapguide41
94ANT41
95WordPress.com40
96Razuna40
97collaboration40
98Announcements40
99CFUG39
100design39