captainsafia

# Create a global gitignore for macOS
cat https://raw.githubusercontent.com/github/gitignore/master/Global/macOS.gitignore >> ~/.gitignore_global 
git config --global core.excludesfile ~/.gitignore_global

# Send screenshots to a directory that isn't the desktop
mkdir -p ~/Screenshots
defaults write com.apple.screencapture location ~/Screenshots

# Show all hidden files (like dotfiles)
defaults write com.apple.finder AppleShowAllFiles YES; killall Finder;

burntcookie90

Lots of books, here's a way to enjoy them! Just my suggestion, I found this to be a great way to get into the overall Cosmere.

Cosmere

1. Mistborn Era 1
   1. The Final Empire
   2. The Well of Ascension
   3. The Hero of Ages
2. Elantris (This is one of his first books, it has a noticabley different style, but the story is fun and has some Cosmere stuff for later)
3. The Emporer's Soul: Elantris Novella
4. Stormlight Archive #1 : The Way of Kings

gene1wood

import boto3

def role_arn_to_session(**args):
    """
    Usage :
        session = role_arn_to_session(
            RoleArn='arn:aws:iam::012345678901:role/example-role',
            RoleSessionName='ExampleSessionName')
        client = session.client('sqs')
    """

kapilt

from botocore.credentials import RefreshableCredentials
from botocore.session import get_session

from boto3 import Session


def assumed_session(role_arn, session_name, session=None):
    """STS Role assume a boto3.Session                                                                                                                                                                                                                                                                                                                 
                                                                                                                                                                                                                                                                                                                                                       
    With automatic credential renewal.                                                                                                                 

iconara

-- Table information like sortkeys, unsorted percentage
-- see http://docs.aws.amazon.com/redshift/latest/dg/r_SVV_TABLE_INFO.html
SELECT * FROM svv_table_info;

-- Table sizes in GB
SELECT t.name, COUNT(tbl) / 1000.0 AS gb
FROM (
  SELECT DISTINCT datname, id, name
  FROM stv_tbl_perm
  JOIN pg_database ON pg_database.oid = db_id

Kartones

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)

jszmajda

Data Serialization Formats

JSON, MessagePack, and Google's Protocol Buffers are all awesome. Here's how they're awesome on different client environments and how to use them on your rails env.

Some links:

• JSON: http://json.org/
• MsgPack: http://msgpack.org/
• ProtoBufs: https://code.google.com/p/protobuf/

Output from Ruby Client:

hummus

wget http://stedolan.github.io/jq/download/linux64/jq 
aws ec2 describe-instances --filters "Name=tag:Name,Values=$NAME" \
  "Name=instance-state-name,Values=running" \
  |  jq -r \
  ".Reservations[] | .Instances[] | .InstanceId" \

aws ec2 describe-volumes --filters \
  "Name=status,Values=available" \
  | jq -r ".Volumes[] | .VolumeId" \

krak3n

import io
import six

from mock import patch
from six.moves import configparser as ConfigParser

data = """
[section]
key = value
"""

iromli

# A generic, single database configuration.
[application]
config_file_name = app_conf.py

[alembic]
# path to migration scripts
script_location = foo.bar:migrations

# template used to generate migration files
# file_template = %%(rev)s_%%(slug)s