Chris Duong chrisduong

Introduction

An introduction to curl using GitHub's API.

The Basics

Makes a basic GET request to the specifed URI

curl https://api.github.com/users/caspyin

Branches

Delete remote branch forcefully

git delete origin --delete <remote branch name>

Create branch from a tag

PostgreSQL schema Explorer commands

Count number of rows inside a table:

SELECT count(*) FROM myschema.mytable;

PostgreSQL administrative commands

Show active connections

SELECT *
FROM pg_stat_activity;

/* ---------
List current sessions from the "clients" database

List all roles

\du

List all access privileges within a database

\dp or \z

Branches

Delete the remote branch:

git push origin --delete v0

Postgres Cheatsheet

This is a collection of the most common commands I run while administering Postgres databases. The variables shown between the open and closed tags, "<" and ">", should be replaced with a name you choose. Postgres has multiple shortcut functions, starting with a forward slash, "". Any SQL command that is not a shortcut, must end with a semicolon, ";". You can use the keyboard UP and DOWN keys to scroll the history of previous commands you've run.

Setup

installation, Ubuntu

http://www.postgresql.org/download/linux/ubuntu/ https://help.ubuntu.com/community/PostgreSQL

Tabs and Windows

Function	Shortcut
Previous Tab	`⌘`+ `Left Arrow`
Next Tab	`⌘`+ `Right Arrow`
Go to Tab	`⌘` + `Number`
Go to Window	`⌘` + `Option` + `Number`
Go to Split Pane by Direction	`⌘` + `Option` + `Arrow`
Go to Split Pane by Order of Use	`⌘` + `]` , `⌘` + `[`

	#!/bin/bash
	# my git difftool, calls FileMerge with project as -merge target
	# better than using opendiff
	#
	# cd to your project dir and and run difftool like this:
	# git difftool -d -x gdiff

	# find top level of git project
	dir=$PWD
	until [ -e "$dir/.git" ]; do

	// Use Gists to store code you would like to remember later on
	console.log(window); // log the "window" object to the console

Chris Duong chrisduong

Introduction

The Basics

Branches

PostgreSQL schema Explorer commands

PostgreSQL administrative commands

Branches

Tags

Postgres Cheatsheet

Setup

installation, Ubuntu

Tabs and Windows