tomchapin

-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query 
FROM pg_stat_activity 
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

tomchapin

What I Wish I'd Known About Equity Before Joining A Unicorn

Disclaimer: This piece is written anonymously. The names of a few particular companies are mentioned, but as common examples only.

This is a short write-up on things that I wish I'd known and considered before joining a private company (aka startup, aka unicorn in some cases). I'm not trying to make the case that you should never join a private company, but the power imbalance between founder and employee is extreme, and that potential candidates would

tomchapin

Git Cheat Sheet

Commands

Getting Started

git init

or

git clone url

tomchapin

WITH RECURSIVE
    x(i) AS ( VALUES (0)
              UNION ALL SELECT i + 1
                        FROM x
                        WHERE i < 101),
    Z(Ix, Iy, Cx, Cy, X, Y, I) AS (
    SELECT
      Ix,
      Iy,
      X :: FLOAT,

tomchapin

--database=postgresql
--skip-test-unit
--skip-bundle
--template=https://gist.github.com/jwaldrip/5538342/raw/rails-template.rb

tomchapin

--database=postgresql
--skip-test-unit
--skip-bundle
--template=https://gist.github.com/tomchapin/5541218/raw/rails-template.rb