Skip to content

Instantly share code, notes, and snippets.

@brachycera
brachycera / outline.css
Created October 23, 2015 17:20
Remove yellow outline in Android Chrome & iOS Safari Browsers
html, body, div, span, applet, object, iframe,
h1, h2, h3, h4, h5, h6, p, blockquote, pre,
a, abbr, acronym, address, big, cite, code,
del, dfn, em, img, ins, kbd, q, s, samp,
small, strike, strong, sub, sup, tt, var,
b, u, i, center,
dl, dt, dd, ol, ul, li,
fieldset, form, label, legend,
table, caption, tbody, tfoot, thead, tr, th, td,
article, aside, canvas, details, embed,
@brachycera
brachycera / delete_local_indexedDB.js
Last active October 11, 2015 22:33
Delete all local indexedDB
window.indexedDB.webkitGetDatabaseNames().onsuccess = function(sender,args){
var r = sender.target.result;
for(var i in r)
{
indexedDB.deleteDatabase(r[i]);
}
};
@brachycera
brachycera / karma.conf.js
Last active October 11, 2015 22:27
Karma configuration File to run with gulp-karma - This setup is for an AMD project with Angular and RequireJS. The essential part to get Karma working, was to load Angular and requireJS test.config.js files before the project files. Plugins: karma-requireJS, karma-spec-reporter, karma-jasmine, karma-phantomjs-launcher
(function ( module ) {
'use strict';
module.exports = function( config ) {
config.set({
basePath : '../',
urlRoot: '/base/',
/**
*
* Simple Countdown Function
* @param {num} duration - in Milliseconds
* @param {string} elemID - DOM Object ID to show the Countdown
*
*/
function countdown(duration, elemID) {
var start = Date.now( );
@brachycera
brachycera / multipleCounting.sql
Created September 2, 2015 17:51
Multiple count within one query
SELECT
SUM(CASE WHEN foo = '0' THEN 1 ELSE 0 END) AS bar_count,
SUM(CASE WHEN foo = '1' OR foo = '2' THEN 1 ELSE 0 END) AS baz_count
FROM
database
WHERE
baz = qux
GROUP BY baz