Will Hainguyen1210

tmux shortcuts & cheatsheet

start new:

tmux

start new with session name:

tmux new -s myname

Neo4j Tutorial

Fundamentals

Store any kind of data using the following graph concepts:

Node: Graph data records
Relationship: Connect nodes (has direction and a type)
Property: Stores data in key-value pair in nodes and relationships
Label: Groups nodes and relationships (optional)

Multiple MySQL Versions for Development

Options included below:

Using Docker docker-compose
Using Homebrew brew

Using Docker (recommended)

This gist was originally created for Homebrew before the rise of Docker, yet it may be best to avoid installing mysql via brew any longer. Instead consider adding a barebones docker-compose.yml for each project and run docker-compose up to start each project's mysql service.

AWS CLI Cheatsheet

http://docs.aws.amazon.com/IAM/latest/UserGuide/best-practices.html https://www.youtube.com/watch?v=_wiGpBQGCjU

Setup

RESTful API know-how

Motivation

I place my learning process in this document with 2 motives:

To have a quick guide whenever I lost the track of knowledge.
To share the knowledge with anyone wants to learn RESTful APIs

	#!/usr/bin/env python3

	import boto3
	import requests
	import tqdm
	from urllib.parse import urlparse

	def stream_to_s3(
	source_url,
	target_url,

	[alias]
	recent = "!git for-each-ref --sort=-committerdate refs/heads/ --format='%(committerdate:short) %(refname:short)' \| head -n 10"
	co = checkout
	cob = checkout -b
	coo = !git fetch && git checkout
	br = branch
	brd = branch -d
	brD = branch -D
	merged = branch --merged
	st = status

	#!/usr/bin/env bash

	# Source: https://gist.github.com/jordan-brough/48e2803c0ffa6dc2e0bd
	# See also: https://stackoverflow.com/a/25095062/58876

	# Download this script as "git-recent" (no extension), chmod it to be executable and put it in your
	# path somewhere (e.g. /usr/bin). You can then use it via `git recent` from inside any git repo.

	# Examples:

	-- 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%'


	git log --author="Linus Torvalds" --date=iso \| perl -nalE 'if (/^Date:\s+[\d-]{10}\s(\d{2})/) { say $1+0 }' \| sort \| uniq -c\|perl -MList::Util=max -nalE '$h{$F[1]} = $F[0]; }{ $m = max values %h; foreach (0..23) { $h{$_} = 0 if not exists $h{$_} } foreach (sort {$a <=> $b } keys %h) { say sprintf "%02d - %4d %s", $_, $h{$_}, ""x ($h{$_} / $m 50); }'