2008 @ ColdFusionBloggers.org

January 7, 2009 misc

(This post is more than 2 years old.)

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.

	Tag	Count
1	ColdFusion	4,098
2	Flex	954
3	General	544
4	Adobe	483
5	Air	396
6	conferences	262
7	Misc	258
8	Javascript	242
9	Ajax	238
10	Technology	205
11	ColdBox	205
12	Development	200
13	Flash	199
14	Code	195
15	cfml	195
16	Tools	193
17	Mac	187
18	Programming	173
19	Web Development	160
20	Java	160
21	SQL	158
22	Personal	147
23	Uncategorized	143
24	posts	141
25	Apple	134
26	Open Source	132
27	Linux	129
28	community	129
29	CFEclipse	112
30	Transfer	107
31	jQuery	105
32	business	104
33	MAX	104
34	security	99
35	Eclipse	97
36	cfunited	95
37	Presentations	92
38	ActionScript	90
39	Scotch on the Rocks	87
40	ColdSpring	87
41	Life	85
42	Jobs	82
43	Stuff	80
44	Oracle	77
45	Google	77
46	iPhone	76
47	Open-Source CF	72
48	Frameworks	69
49	ColdFusion 8	68
50	Web Dev	68
51	Railo	68
52	Blogging	67
53	Work	66
54	Fun	66
55	AS3	66
56	Appearances	66
57	AdobeMAX08	65
58	Microsoft	63
59	BlueDragon	57
60	RIA	57
61	Projects	57
62	Universal Mind	55
63	subversion	54
64	model-glue	54
65	Flex General	53
66	ruby	52
67	Windows	52
68	SixSigns	51
69	fusebox	51
70	BlazeDS	50
71	Adobe AIR	50
72	Apache	50
73	music	48
74	Applications	47
75	Video	47
76	database	47
77	events	47
78	WhosOnCFC	46
79	BlogCFC	46
80	mysql	46
81	Off Topic	46
82	HTML/ColdFusion	46
83	news	46
84	Databases	46
85	Random	45
86	Ubuntu	45
87	openbd	44
88	Default	44
89	.NET	43
90	Ask Ben	42
91	SQL Server	42
92	Reviews	42
93	mapguide	41
94	ANT	41
95	WordPress.com	40
96	Razuna	40
97	collaboration	40
98	Announcements	40
99	CFUG	39
100	design	39