StevenBlack

#!/bin/sh
#
# The MIT License
#
# Copyright 2014-2017 Jakub Jirutka <jakub@jirutka.cz>.
#
# Permission is hereby granted, free of charge, to any person obtaining a copy
# of this software and associated documentation files (the "Software"), to deal
# in the Software without restriction, including without limitation the rights
# to use, copy, modify, merge, publish, distribute, sublicense, and/or sell

StevenBlack

-- show running queries (pre 9.2)
SELECT procpid, age(query_start, clock_timestamp()), 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(query_start, clock_timestamp()), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

StevenBlack

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h):

• -E: will describe the underlaying queries of the \ commands (cool for learning!)
• -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

StevenBlack

04d4dbb7d597566748e73f79c76aff1b58ac727b35c6feaea0d90b21b115783525007b5224e46e08dadfaa52b9c76dd9fbbc47278482880b7c82b0a54b54b643e2

StevenBlack

Standups: 
2-3 times per night 
post issues to Slack
designate scrum master and rotate who the master will be
scrum master gives everyone a turn to speak

Conflicts: 
Write down your conflict
Spend 15 minutes tops to resolve the conflict and move on.
We are all on the same team with the same goal

StevenBlack

• This phone had its original cracked screen replaced at an iService frachise.
• The current screen worked for awhile, then gradually failed
• The current screen doesn't work at all, and the phone is disabled.

Please replace the screen, then ship to the address on the work order.

StevenBlack

- [ ] Install ITerm2 app – https://www.iterm2.com/
- [ ] Install Sublime Text app – https://www.sublimetext.com/ and the `subl` command line tool
- [ ] Install MacDown app – http://macdown.uranusjr.com/
- [ ] Update Chrome to latest
- [ ] Install Chrome extension: Web Developer Toolbar
- [ ] Install Ruby Version Manager (RVM) – https://rvm.io/
- [ ] Install Ruby latest
- [ ] Install Jekyll (ruby Gem) – http://jekyllrb.com
- [ ] Create an account at https://github.com
- [ ] Install git

StevenBlack

// Node.js CheatSheet.
// Download the Node.js source code or a pre-built installer for your platform, and start developing today.
// Download: http://nodejs.org/download/
// More: http://nodejs.org/api/all.html


// 0. Synopsis.
// http://nodejs.org/api/synopsis.html

StevenBlack

Better local require() paths for Node.js

Problem

When the directory structure of your Node.js application (not library!) has some depth, you end up with a lot of annoying relative paths in your require calls like:

var Article = require('../../../models/article');

Those suck for maintenance and they're ugly.

Possible solutions

StevenBlack

CREATE EXTENSION tablefunc;

CREATE TABLE sales(year int, month int, qty int);
INSERT INTO sales VALUES(2007, 1, 1000);
INSERT INTO sales VALUES(2007, 2, 1500);
INSERT INTO sales VALUES(2007, 7, 500);
INSERT INTO sales VALUES(2007, 11, 1500);
INSERT INTO sales VALUES(2007, 12, 2000);
INSERT INTO sales VALUES(2008, 1, 1000);
INSERT INTO sales VALUES(2009, 5, 2500);