Skip to content

Instantly share code, notes, and snippets.

select tag.*, count(*) as count from tag
LEFT OUTER JOIN category_tag ON tag.name_encoded = category_tag.name_encoded
WHERE category_tag.name_encoded IS NULL
GROUP BY tag.name_encoded
ORDER BY count DESC
LIMIT 1;
SELECT tag.*, count(*) as count FROM category_tag.name_encoded
JOIN tag ON tag.name_encoded = category_tag.name_encoded
WHERE category_tag.name_encoded IS NULL
Show.create(
title: “Breaking Style Rules”,
description: “A through-the-ages take on dressing for yourself” ,
clips: [
Clip.create(
url: “https://www.youtube.com/watch?v=2ObB-qRkbfc”,
title: "Rookie Style”,
description: “Packing for New York Fashion Week with Tavi Gevinson”
),
@mhkt
mhkt / gist:4241460
Created December 8, 2012 19:11
500s on Blitline, no add'l data
# This job:
blitline.add_job_via_hash(
application_id: ENV['BLITLINE_APP_ID'],
src: flickr_url,
functions: [
{
name: 'scale',
params: {'scale_factor' => 1.5},
functions: [
{
<?
/*
PHP is UNIX - Simple preforking echo server in PHP
**************************************************
The code here is related to:
http://tomayko.com/writings/unicorn-is-unix
http://jacobian.org/writing/python-is-unix/
http://plasmasturm.org/log/547/ - perl is unix
#!/bin/bash -xe
EBS_DEVICE='/dev/sdh'
INSTANCE_ID=$1
AKI=${2:-'aki-5f15f636'}
ARI=${3:-'ari-0915f660'}
ARCH=${4:-'i386'}
SIZE=${5:-10}
AZ=${6:-'us-east-1d'}
NAME=${7:-"ami-from-$INSTANCE_ID"}

Keybase proof

I hereby claim:

  • I am mhkt on github.
  • I am mhkt (https://keybase.io/mhkt) on keybase.
  • I have a public key whose fingerprint is 846B E2FB 666D 4311 8C65 4C77 C257 AD1A 3EAD C203

To claim this, I am signing this object:

@mhkt
mhkt / gist:3c41c4f65c08c2abad8e
Created February 6, 2015 21:17
Return zoom animation in Framer photo thingy
zoomInAnimationFunc = (layerName) ->
zoomIn = new Animation
layer: layerName
properties:
x: 0
y: 325
height: 640
width: Screen.width
time: 0.2
curve: "spring(300,23,0)"