dkaufman

These are the Kickstarter Engineering and Data role definitions for both teams.

Technical	Data	People
Junior Software Engineer
Software Engineer	Data Analyst
Senior Software Engineer	Data Scientist	Engineering Manager
Staff Engineer	VP of Data	Engineering Director
Principal Engineer		CTO

dkaufman

dkaufman

First you need to install god on your server.
gem install god

Then, create your god configuration file with the extension .god. For the simplest configuration, write a god watch block for each of your services like below:

God.watch do |w|
  w.name = "redis"
  w.start = "redis-server /usr/local/etc/redis.conf"
  w.keepalive
end

dkaufman

God.watch do |w|
  w.name = "nginx"
  w.start = "sudo service nginx start"
  w.keep_alive
end

God.watch do |w|
  w.name = "varnish"
  w.start = "sudo varnishd -f /etc/varnish/default.vcl -s malloc,100M -T 127.0.0.1:2000"
  w.keep_alive

dkaufman

SELECT merchants.name, SUM(quantity) FROM invoice_items
INNER JOIN invoices ON invoice_items.invoice_id = invoices.id
INNER JOIN merchants ON invoices.merchant_id = merchants.id
WHERE invoice_items.invoice_id IN
     (SELECT invoices.id FROM invoices
      INNER JOIN transactions ON invoices.id = transactions.invoice_id
      AND transactions.result LIKE 'success')
GROUP BY merchants.id
ORDER BY SUM(quantity) DESC

dkaufman

SELECT SUM(invoice_items.quantity*invoice_items.unit_price) FROM invoices
INNER JOIN invoice_items ON invoices.id = invoice_items.invoice_id
INNER JOIN transactions ON invoices.id = transactions.invoice_id
WHERE transactions.result LIKE 'success' AND Date(invoices.created_date) = Date('2012-03-20')