Yixin Wan erinwan

## gist:aa16709a0904fffbd4ab
button:focus {outline:0 !important;}

/* http://stackoverflow.com/questions/20340138/remove-blue-border-from-css-custom-styled-button-in-chrome */

## gist:9e0779003d728854c6bb
source venv/bin/activate

## gist:0d0cf31a146b7698f1bf
heroku pg:psql

## gist:dc19fac936f150c67c52
\?        #List all \commands that can be used in psql.
\l        #List all databases.
\d        #List all tables in current database.
\d[table] #Show schema for table with name 'table'.
\du       #List all users (roles) for this table.
\c[db]    #Change to database with name 'db'.
\h        #List SQL commands(e.g.SELECT,UPDATE...)
\q        #Quit psql; you can also use Cmd/Ctrl+d
\d+ [tablename] # PostgreSQL “DESCRIBE TABLE”
SELECT current_database(); # show current database name

## gist:b837bcf90aa1098a2bac
dropdb socialnetwork
createdb socialnetwork
createuser webapps
psql socialnetwork
GRANT ALL PRIVILEGES ON DATABASE socialnetwork TO webapps;

## gist:d1bcb2aee90212a5c011
If you using MAC OS, you can stop port.
Find PID: lsof -i :1099
Kill port: kill -9 PID_number

## gist:937b4c03a3010fd10daf
Post.objects.all().delete()

## gist:1da68f5ccebfe70bb9c5
caffeinate
http://www.maclife.com/article/columns/terminal_101_prevent_your_mac_sleeping

## gist:d6cbaab90c10ecb74891
python manage.py shell

from socialnetwork.models import *

## gist:420af63e432ebf1382b5
#import pdb; pdb.set_trace()
n: next
	button:focus {outline:0 !important;}

	/* http://stackoverflow.com/questions/20340138/remove-blue-border-from-css-custom-styled-button-in-chrome */
	\? #List all \commands that can be used in psql.
	\l #List all databases.
	\d #List all tables in current database.
	\d[table] #Show schema for table with name 'table'.
	\du #List all users (roles) for this table.
	\c[db] #Change to database with name 'db'.
	\h #List SQL commands(e.g.SELECT,UPDATE...)
	\q #Quit psql; you can also use Cmd/Ctrl+d
	\d+ [tablename] # PostgreSQL “DESCRIBE TABLE”
	SELECT current_database(); # show current database name
	dropdb socialnetwork
	createdb socialnetwork
	createuser webapps
	psql socialnetwork
	GRANT ALL PRIVILEGES ON DATABASE socialnetwork TO webapps;
	If you using MAC OS, you can stop port.
	Find PID: lsof -i :1099
	Kill port: kill -9 PID_number
	caffeinate
	http://www.maclife.com/article/columns/terminal_101_prevent_your_mac_sleeping