Skip to content

Instantly share code, notes, and snippets.

I didn't read your email closely the first time around -- I actually blazed through most of it, only really picking up on your asking for a code sample (which I was fine sending as I already had something handy). I don't know who Jimmy Kittyachavatil is nor do I particularly care. The truth is, you received my resume via some automation software I wrote; if I'd seen your ad myself, I would have ignored it. I've earned a computer science degree from a tier 1 school and you think you're justified in asking me to waste my time, proving I can solve problems (I guess that's what you think you're doing) by asking me to solve some trivial little toy problem so I can be granted an audience with your VP of Engineering? Thanks. But I'd just as soon pass.
@derwiki
derwiki / load.sh
Created June 4, 2012 22:31
Bulk loading 500m rows into MySQL
for month_table in action*.txt; do
echo "$(date) splitting $month_table..."
split -l 1000000 $month_table curmonth_
for segment in curmonth_*; do
echo "On segment $segment"
time mysql -hlocalhost action_credit_silo <<-SQL
SET FOREIGN_KEY_CHECKS = 0;
SET UNIQUE_CHECKS = 0;
SET SESSION tx_iso
=> {:suppress_urgent_oops_exceptions=>["FacebookUser::MogliExtension::MogliRuntimeException"], :rate_monitored_exceptions=>{:simple_opengraph_request=>{:interval=>600, :threshold=>100}}}
>> newconfig = config
=> {:suppress_urgent_oops_exceptions=>["FacebookUser::MogliExtension::MogliRuntimeException"], :rate_monitored_exceptions=>{:simple_opengraph_request=>{:interval=>600, :threshold=>100}}}
>> newconfig = config[:suppress_urgent_oops_exceptions]
=> ["FacebookUser::MogliExtension::MogliRuntimeException"]
>> newconfig = config[:rate_monitored_exceptions]
=> {:simple_opengraph_request=>{:interval=>600, :threshold=>100}}
>>
Delivered-To: derewecki@gmail.com
Received: by 10.231.28.36 with SMTP id k36cs65105ibc;
Mon, 6 Feb 2012 11:13:02 -0800 (PST)
Received: by 10.236.191.35 with SMTP id f23mr26582784yhn.29.1328555582482;
Mon, 06 Feb 2012 11:13:02 -0800 (PST)
Return-Path: <bounces-708-1846396@causesmail.com>
Received: from outbound37.causesmail.com (outbound37.causesmail.com. [74.116.69.237])
by mx.google.com with ESMTP id v42si17300696yhl.53.2012.02.06.11.13.02;
Mon, 06 Feb 2012 11:13:02 -0800 (PST)
mainframe:~/causes[master %]$ cat perf.rb
#!/usr/bin/ruby
PASSENGER_LOG_REGEX = /(\w+)\s(\d+)\s(\d+).*Completed in (\d+\.\d+).*Rendering: (\d+\.\d+)/
File.open('jan-17-action-render-samples.log').each do |line|
PASSENGER_LOG_REGEX =~ line
puts {
:month => $1,
:day => $2,
:hour => $3,
A D A M D E R E W E C K I
1456 Jones St. Apt 32, San Francisco, CA 94109 740-502-3073
derewecki@gmail.com @derwiki
linkedin.com/in/derewecki derwiki.tumblr.com
news.ycombinator.com/user?id=derwiki github.com/derwiki
== P R O F E S S I O N A L E X P E R I E N C E ==
Causes, Hacker (3/2011 - Present)
* Web Development
@derwiki
derwiki / .gitconfig
Created November 22, 2011 06:35
Fancy .gitconfig you can grow into
[log]
decorate = short
[color]
ui = auto
[pager]
status = true
show-branch = true
[rebase]
autosquash = true
Spinning up 8 worker processes...
pid id a length good matches time elapsed (s)
Process filename: suggestions-segfault.csv.0 , FILE*: 132b5070
Process filename: suggestions-segfault.csv.1 , FILE*: 132b5070
Process filename: suggestions-segfault.csv.2 , FILE*: 132b5070
Process filename: suggestions-segfault.csv.4 , FILE*: 132b5070
Process filename: suggestions-segfault.csv.5 , FILE*: 132b5070
Process filename: suggestions-segfault.csv.6 , FILE*: 132b5070
Process filename: suggestions-segfault.csv.7 , FILE*: 132b5070
Process filename: suggestions-segfault.csv.3 , FILE*: 132b5070
def openfile(path):
with open(path) as fh:
return fh
import: unable to open X server `' @ import.c/ImportImageCommand/367.
import: unable to open X server `' @ import.c/ImportImageCommand/367.
./jsontransform.py: line 5: syntax error near unexpected token `sys.stdout.write'
./jsontransform.py: line 5: ` sys.stdout.write( '\t'.join(json.loads(line)[key] for key in ('email', 'anonymous_id')) )'