1

Please login or register to vote for this query.

(click on this box to dismiss)

For starters, just compare libraries... woah, jQuery by a landslide Of course thats just questions, which indicates both popularity AND potentially the amount of confusion ;-) (I added a few new libraries to the set)

Q&A for programmers

-- JavaScript Library Analysis
-- For starters, just compare libraries... woah, jQuery by a landslide
-- Of course thats just questions, which indicates both popularity AND
-- potentially the amount of confusion ;-)

-- I'm throwing GWT and ASP.Net-AJAX in the mix, (knowing) thats a bit of an
-- Apples to Oranges comparison

SELECT  TagName AS [Library Tag],
        cnt AS [Questions Tagged],
        ROUND(100.0 * cnt / SUM(cnt) OVER (), 2) AS [Ratio, %]
FROM    Tags t
CROSS APPLY
        (
        SELECT  COUNT(*) AS cnt
        FROM    PostTags pt
        WHERE   pt.TagId = t.id
        ) q
WHERE   t.TagName IN (
                      'archetype',
                      'asp.net-ajax',
                      'bbc-glow',
                      'dojo',
                      'dwr',
                      'extjs',
                      'fbjs',
                      'google-closure',
                      'gwt',
                      'javascriptmvc',
                      'jquery',
                      'june',
                      'midori',
                      'mochikit',
                      'mootools',
                      'prototype',
                      'qooxdoo',
                      'raphael',
                      'rialto',
                      'rico',
                      'scriptaculous',
                      'sencha',
                      'sencha-touch',
                      'sproutcore',
                      'spry',
                      'yui',
                      'zepto'
                     )
ORDER BY
        cnt DESC

fork query

created dec 14 10 scunliffe