Collections of categorized tags

1

Please login or register to vote for this query.

(click on this box to dismiss)

Code Review

Q&A for peer programmer code reviews

/**
 * @author Phrancis (Code Review.SE)
 * @author QPaysTaxes (Code Review.SE)
 *
 * The goal of this query is to have an easy reference 
 * for users who wish to use specific sets of tags in their SEDE queries.
 * The queries below each create a temporary table that can easy be copied
 * into other queries for your convenience and enjoyment.
 */

/* ALL TAGS */

CREATE TABLE #CategorizedTags (AllTags VARCHAR(100) COLLATE SQL_Latin1_General_CP1_CS_AS);
GO
INSERT INTO #CategorizedTags (AllTags)
  SELECT DISTINCT 
    TagName
  FROM Tags;
GO


/* LANGUAGE TAGS */

ALTER TABLE #CategorizedTags 
ADD Languages VARCHAR(100) COLLATE SQL_Latin1_General_CP1_CS_AS;
GO
UPDATE #CategorizedTags 
SET Languages = AllTags
WHERE AllTags IN (
  'applescript',
  'asp.net-mvc-3',
  'bash',
  'brainfuck',
  'c',
  'c#',
  'c++',
  'c++11',
  'c++14',
  'cellular-automata',
  'cfml',
  'coffeescript',
  'css3',
  'cython',
  'dsl',
  'elixir',
  'factor',
  'hy',
  'jade',
  'java',
  'javascript',
  'jsx',
  'julia',
  'less-css',
  'lisp',
  'logo',
  'lolcode',
  'lua',
  'matlab',
  'maya',
  'objective-c',
  'ocaml',
  'php',
  'php5',
  'powershell',
  'python',
  'python3',
  'r',
  'rebol',
  'ruby',
  'rust',
  'scala',
  'scheme',
  'swift',
  'wolfram-mathematica',
  'xslt'
  );
GO

ALTER TABLE #CategorizedTags
ADD Frameworks VARCHAR(100);
GO
UPDATE #CategorizedTags
SET Frameworks = AllTags
WHERE AllTags IN (
''
);


/* LIBRARY TAGS */

ALTER TABLE #CategorizedTags 
ADD Libraries VARCHAR(100);
GO
UPDATE #CategorizedTags 
SET Libraries = AllTags
WHERE AllTags IN (
   'akka',
   'backbone.js',
   'bacon.js',
   'beautiful-soup',
   'casper.js',
   'dapper',
   'express.js',
   'grunt.js',
   'gwt',
   'jms',
   'jquery',
   'jstl',
   'knockout.js',
   'laravel',
   'libgdx',
   'linq',
   'node.js',
   'numba',
   'numpy',
   'paper.js',
   'objective-c-runtime',
   'phpunit',
   'pygame',
   'qt',
   'regex',
   'require.js',
   'ruby-on-rails',
   'sfml',
   'stl',
   'tkinter',
   'twitter-bootstrap',
   'underscore.js',
   'winapi'
   );
GO


/* 3. DEVELOPMENT STRATEGY & CONCEPT TAGS */

ALTER TABLE #CategorizedTags 
ADD Development VARCHAR(100);
GO
UPDATE #CategorizedTags 
SET Development = AllTags
WHERE AllTags IN (
  'bdd', 
  'ddd', 
  'jsf',
  'linked-list',
  'makefile', 
  'math-expression-eval',
  'mixins', 
  'monads', 
  'mvc', 
  'mvp', 
  'rc',
  'regex',
  'rhino'
  );
GO


/* 4. PROTOCOL TAGS */

ALTER TABLE #CategorizedTags 
ADD Protocols VARCHAR(100);
GO
UPDATE #CategorizedTags 
SET Protocols = AllTags
WHERE AllTags IN (
  'ldap',
  'mpi',
  'http',
  'https',
  'ftp',
  'udp'
  );
GO


/* 5. DATABASE TAGS */

ALTER TABLE #CategorizedTags 
ADD Data VARCHAR(100);
GO
UPDATE #CategorizedTags 
SET Data = AllTags
WHERE AllTags IN (
  'active-record',
  'mongodb',
  'ms-access',
  'mysql',
  'mysqli',
  'pdo',
  'nosql',
  'postgresql',
  'sql',
  'sqlite',
  'sql-server',
  'stored-procedure',
  't-sql'
  );
GO

/* 6. TECHNOLOGY & TOOLS TAGS */

ALTER TABLE #CategorizedTags 
ADD TechTools VARCHAR(100);
GO
UPDATE #CategorizedTags 
SET TechTools = AllTags
WHERE AllTags IN (
  'bluetooth',
  'gradle',
  'odoo',
  'owin'
  );
GO


/* 7. OPERATING SYSTEM (OS) TAGS */

ALTER TABLE #CategorizedTags 
ADD OS VARCHAR(100);
GO
UPDATE #CategorizedTags 
SET OS = AllTags
WHERE AllTags IN (
  'ios',
  'osx',
  'linux',
  'windows'
  );
GO


/* 8. SOFTWARE */

ALTER TABLE #CategorizedTags 
ADD Software VARCHAR(100);
GO
UPDATE #CategorizedTags 
SET Software = AllTags
WHERE AllTags IN (
  'opencv',
  'parsec',
  'propel',
  'sas',
  'sse', 
  'titanium', 
  'salesforce',
  'unity3d'
  );
GO

/* 9. Games */

ALTER TABLE #CategorizedTags 
ADD Games VARCHAR(100);
GO
UPDATE #CategorizedTags 
SET Games = AllTags
WHERE AllTags IN (
  'chess', 
  'game', 
  'minecraft',
  'role-playing-game',
  'tic-tac-toe',
  'battle-simulation',
  'adventure-game',
  'number-guessing-game'
  );
GO

/* 10. Programming challenges */

ALTER TABLE #CategorizedTags 
ADD Challenges VARCHAR(100);
GO
UPDATE #CategorizedTags 
SET Challenges = AllTags
WHERE AllTags IN (
  'programming-challenge',
  'codeigniter',
  'project-euler',
  'fizzbuzz',
  'game-of-life',
  'time-limit-exceeded'
  );
GO

/* 11. Mathematics */

ALTER TABLE #CategorizedTags 
ADD Math VARCHAR(100);
GO
UPDATE #CategorizedTags 
SET Math = AllTags
WHERE AllTags IN (
  'algorithm',
  'computational-geometry',
  'graph',
  'numerical-methods',
  'project-euler',
  'primes'
  );
GO

/* 12. Web Development */

ALTER TABLE #CategorizedTags 
ADD WebDev VARCHAR(100);
GO
UPDATE #CategorizedTags 
SET WebDev = AllTags
WHERE AllTags IN (
  'css',
  'css3',
  'html',
  'xhtml',
  'html5',
  'javascript',
  'jquery',
  'php',
  'php5',
  'authentication',
  'dom', 
  'e-commerce',
  'google-app-engine',
  'https',
  'markdown',
  'web-services'
  );
GO

/* GENERAL TAGS */

ALTER TABLE #CategorizedTags 
ADD General VARCHAR(100);
GO
UPDATE #CategorizedTags 
SET General = AllTags
WHERE AllTags IN (
  'algorithm',
  'animation',
  'api',
  'array',
  'asynchronous',
  'authentication',
  'base64',
  'beginner',
  'binary-search',
  'bitset',
  'cache',
  'category',
  'child-process',
  'circular-list',
  'classes',
  'compression',
  'computational-geometry',
  'concurrency',
  'coordinate-system',
  'cryptography',
  'data-structures',
  'depth-first-search',
  'design-patterns',
  'device-driver',
  'dictionary',
  'directory',
  'dom', 
  'dynamic-programming',
  'e-commerce',
  'email',
  'finance',
  'form',
  'framework',
  'generator',
  'generics',
  'google-app-engine',
  'graph',
  'gui',
  'heap',
  'hibernate',
  'higher-order-functions',
  'https',
  'ienumerable',
  'image',
  'inheritance',
  'integer',
  'io',
  'iterator',
  'lambda',
  'library',
  'locking',
  'macros',
  'markdown',
  'mobile',
  'mocks',
  'music',
  'networking',
  'null',
  'numerical-methods',
  'observable',
  'opengl',
  'optimization',
  'pagination',
  'parsing',
  'plugin',
  'primes',
  'processing',
  'producer-consumer',
  'random',
  'reinventing-the-wheel', 
  'serialization',
  'servlets',
  'session',
  'set',
  'signal-handling',
  'signal-processing',
  'singleton',
  'state',
  'state-machine',
  'statistics',
  'strings',
  'synchronization',
  'template',
  'template-meta-programming',
  'thread-safety',
  'timeout',
  'twitter',
  'type-safety',
  'unit-testing',
  'user-interface',
  'variant-type',
  'vectorization',
  'web-services'
  );
GO

SELECT * FROM #CategorizedTags;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results