Ray Chen garudareiga

Connect to a Database

To report the name of the current database

db

To display the list of databases

 show dbs

Git Branches

We have two types of branches: local branches and remote-tracking branches. The names of tracking branches are make up of the name of a "remote" followd by "/" and then the name of a branch in that remote repository.

$ git branch
$ git branch -r

These branches are stored locally:

.git/refs/heads (for local branches)
.git/refs/remotes/ (for remote-tracking branches)

PostgreSQL .psqlrc Tips

List of tips:

Show date on startup
Be verbose about feeback
Set all null fields to NULL
Turn off the pager so that results keep scrolling by, rather than stopping
Set the command history files for each host and database
Set the number of commands to store in the command history

INIT FILE

sqlite3 reads a configuration file ~/.sqliterc for the interactive command line. It generally only contain meta-commands such as

.headers ON
.mode column
.nullvalue NULL

Heroku Apps

Create a Heroku app from a git repo and verify the remote in your git configuration

$ heroku create
$ git remote -v

Add an existing Heroku app to a git repo

	import logging

	logger = logging.getLogger(__name__)
	logger.setLevel(logging.DEBUG)

	formatter = logging.Formatter('[%(levelname)s] %(message)s')

	handler_stream = logging.StreamHandler()
	handler_stream.setFormatter(formatter)
	handler_stream.setLevel(logging.INFO)

	import logging

	logger = logging.getLogger(__name__)

	formatter = logging.Formatter('%(name)s - %(levelname)s - %(message)s')
	handler_stream = logging.StreamHandler()
	handler_stream.setFormatter(formatter)

	logger.addHandler(handler_stream)

	import logging

	logger = logging.getLogger(__name__)

	def foo():
	logger.debug('Dump debug message')
	logger.info('Dump info message')
	logger.warn('Dump warn message')
	logger.error('Dump error message')
	logger.critical('Dump critical message')

	{
	"version": 1,
	"disable_existing_loggers": false,
	"formatters": {
	"simple": {
	"format": "%(name)s - %(levelname)s - %(message)s"
	}
	},

	"handlers": {