Skip to content

Instantly share code, notes, and snippets.

@brachycera
brachycera / multipleCounting.sql
Created Sep 2, 2015
Multiple count within one query
View multipleCounting.sql
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
View countdown.js
/**
*
* 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 / karma.conf.js
Last active Oct 11, 2015
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
View karma.conf.js
(function ( module ) {
'use strict';
module.exports = function( config ) {
config.set({
basePath : '../',
urlRoot: '/base/',
@brachycera
brachycera / delete_local_indexedDB.js
Last active Oct 11, 2015
Delete all local indexedDB
View delete_local_indexedDB.js
window.indexedDB.webkitGetDatabaseNames().onsuccess = function(sender,args){
var r = sender.target.result;
for(var i in r)
{
indexedDB.deleteDatabase(r[i]);
}
};
@brachycera
brachycera / outline.css
Created Oct 23, 2015
Remove yellow outline in Android Chrome & iOS Safari Browsers
View outline.css
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 / errors_tpl.html
Last active Dec 30, 2015
Angular 1.3.x Directive to fetch minlength Value from Input Text Field and show the Value in the ng-message for minlength Errors
View errors_tpl.html
<small class="error" ng-message="minlength" validate-minlength>Please enter at least {{requiredMinLength}} characters</small>
@brachycera
brachycera / install_gettext.sh
Created Jan 20, 2016 — forked from istepanov/install_gettext.sh
Compile and install gettext.so PHP extension for Mac OS X 10.8 Mountain Lion
View install_gettext.sh
#!/usr/bin/sh
# Scipt for installing mcrypt.so extension for PHP 5.3.13 (default PHP for OS X 10.8 Mountain Lion)
mkdir /tmp/gettext
cd /tmp/gettext
curl --location --progress-bar http://us.php.net/get/php-5.3.13.tar.gz/from/nl.php.net/mirror | tar -zx
brew update
@brachycera
brachycera / Export each as SVG.js
Created Jan 26, 2016 — forked from vieron/Export each as SVG.js
Export each as SVG. Modified some lines from the original by Aaron Beall (http://fireworks.abeall.com/extensions/commands/Export/Export%20SVG.jsf) to export each selected object as a separate SVG file.
View Export each as SVG.js
// Fireworks JavaScript Command
// Exports current document state as SVG graphics format
// Install by copying to Fireworks/Configuration/Commands/
// Run via the Commands menu in Fireworks
// Aaron Beall 2010-2011
// Version
var VERSION = "0.6.1";
// Params
@brachycera
brachycera / gulpfile.js
Last active Mar 22, 2017
Zurb Inky setup with watcher, grunt and minify
View gulpfile.js
module.exports = function (grunt) {
require('matchdep').filterDev('grunt-*').forEach(grunt.loadNpmTasks);
var siphon = require('siphon-media-query');
var fs = require('fs');
var nl_css = fs.readFileSync('PATH/TO/foundation-emails.css').toString();
var mq_css = siphon(nl_css);
// Filename for created template
@brachycera
brachycera / exclude.sh
Last active Sep 26, 2017
Exclude development folders like "node_modules" or "vendor" from osX timemachine backups.
View exclude.sh
find `pwd` -type d -maxdepth 3 -name 'vendor' -o -name 'node_modules'| xargs -n 1 tmutil addexclusion