nisitc

#!/bin/bash
# Add to instance metadata with `gcloud compute instances add-metadata \
#   instance-name --metadata-from-file startup-script=idle-shutdown.sh` and reboot
# NOTE: requires `bc`, eg, sudo apt-get install bc
# Modified from https://stackoverflow.com/questions/30556920/how-can-i-automatically-kill-idle-gce-instances-based-on-cpu-usage
threshold=0.1

count=0
wait_minutes=60
while true

nisitc

Commands

• git checkout -b __newbranch__ : get a new branch and switch to it
• git checkout -b __branchname__ / __branchname__ : get a local copy of a remote existing branch
• git checkout __branchname__ : switch branch
• git checkout --orphan __branchname__ : create branch without full history
• git log -n X -p : show X last commits with diffs
• git log __branchA__ ^__branchB__ : commits in branch A that aren't in branch B
• git log --pretty=oneline --stat --all __foldername__ : modified files under a given folder
• git fetch

nisitc

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

• -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)

nisitc

nisitc

nisitc

nisitc

nisitc

nisitc

nisitc