Skip to content

Instantly share code, notes, and snippets.

View kevindjacobson's full-sized avatar
🐈
I have four cats!

Kevin Jacobson kevindjacobson

🐈
I have four cats!
  • San Francisco, CA
View GitHub Profile
@kevindjacobson
kevindjacobson / wtf.sql
Created January 9, 2018 23:39
WHAT IS HAPPENING WITH THIS QUERY!!!
CACHE (0.0ms) SELECT "skills"."name" FROM "skills" WHERE (skills.name ILIKE '%java%')
(8168.3ms) SELECT COUNT(*) FROM "jobs" INNER JOIN "companies" ON "companies"."id" = "jobs"."company_id" AND "companies"."deleted_at" IS NULL INNER JOIN "places" ON "places"."id" = "jobs"."place_id" INNER JOIN "jobs_skills" ON "jobs_skills"."job_id" = "jobs"."id" INNER JOIN "skills" ON "skills"."id" = "jobs_skills"."skill_id" WHERE "jobs"."primary_role_id" = 4 AND "jobs"."status" = 'open' AND "places"."market_id" = 6 AND "skills"."name" IN ('Account Manager
Analytics
Brand Awareness
Campaign Strategies
Campaigns
Channels
Client Services
CMS
Communications
@kevindjacobson
kevindjacobson / keybase.md
Created April 6, 2017 19:44
Keybase Proof of ID

Keybase proof

I hereby claim:

  • I am losergenerated on github.
  • I am losergenerated (https://keybase.io/losergenerated) on keybase.
  • I have a public key ASCM2DWV326Bv_32XDQJ8cay_zvTKkwmX65q9ZnMTyOQxAo

To claim this, I am signing this object:

@kevindjacobson
kevindjacobson / logo.txt
Created April 6, 2017 19:38
ascii-logo
Λ
╱O╲
╱OOO╲
╱OOOOO╲
╱OOOOOOO╲
╱OOOOOOOOO╲
╱OOOOOOOOOOO╲
╱OOOOOOOOOOOOO╲
╱OOOOOOOOOOOOOOO╲ .───────────.
╱OOOOOOOOOOOOOOOOO╲ _.──'0000000000000`───.
float rand(vec3 co)
{
return fract(sin( dot(co.xyz ,vec3(12.9898,78.233,45.5432) )) * 43758.5453);
}
void mainImage( out vec4 fragColor, in vec2 fragCoord )
{
vec2 squares = vec2(80.0,60.0);
vec2 uv = fragCoord.xy / iResolution.xy;
require "midi"
require "eventmachine"
# prompt the user to select an input and output
EventMachine.run do
@input = UniMIDI::Input.gets
@output = UniMIDI::Output.gets
EventMachine.set_timer_quantum(10);
hive> SELECT COUNT(bestseller_citations) FROM bowker.bowker WHERE bestseller_citations IS NOT NULL AND length(bestseller_citations) > 0 AND NOT (bestseller_citations LIKE '%New York Times%' OR bestseller_citations LIKE '%Publishers Weekly%');
Total MapReduce jobs = 1
Launching Job 1 out of 1
Number of reduce tasks determined at compile time: 1
In order to change the average load for a reducer (in bytes):
set hive.exec.reducers.bytes.per.reducer=<number>
In order to limit the maximum number of reducers:
set hive.exec.reducers.max=<number>
In order to set a constant number of reducers:
set mapred.reduce.tasks=<number>
@kevindjacobson
kevindjacobson / 0_reuse_code.js
Created January 8, 2014 21:10
Here are some things you can do with Gists in GistBox.
// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console
@kevindjacobson
kevindjacobson / Zendesk Weirdness
Created April 25, 2013 00:18
Unusual behavior in the Zendesk Ruby Api Gem.
>> ticket.changed?
=> false
>> ticket.tags
=> ["account"]
>> ticket.tags += ['updated_by_scribd_loop'] # HERE'S WHERE I ADD THE TAG!
=> ["account", "updated_by_scribd_loop"]
>> ticket.tags
=> ["account", "updated_by_scribd_loop"]
>> ticket.changed? # YEP
=> true