Horacio Degiorgi horaciod

PSQL Cheatsheet

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)

	#add 'node_modules' to .gitignore file

	git rm -r --cached node_modules
	git commit -m 'Remove the now ignored directory node_modules'
	git push origin <branch-name>

	#!/bin/bash
	#
	# This script configures WordPress file permissions based on recommendations
	# from http://codex.wordpress.org/Hardening_WordPress#File_permissions
	#
	# Author: Michael Conigliaro
	#
	WP_OWNER=changeme # <-- wordpress owner
	WP_GROUP=changeme # <-- wordpress group
	WP_ROOT=/home/changeme # <-- wordpress root directory

	#!/usr/bin/env python
	########################
	#
	# @TODO: Location field in current Solr index has both libRecord and mapRecord -
	# should there be both or just libRecord?
	#
	########################

	from lxml import etree
	import sys

	<?php

	/**
	* Recursively implodes an array with optional key inclusion
	*
	* Example of $include_keys output: key, value, key, value, key, value
	*
	* @access public
	* @param array $array multi-dimensional array to recursively implode
	* @param string $glue value that glues elements together

	Edit mc’s ini file (either ~/.mc/ini or ~/.config/mc/ini) and look for the line [Colors]. Then, change the line base_color to this:

	[Colors]
	base_color=linux:normal=white,black:marked=yellow,black:input=,green:menu=black:menusel=white:menuhot=red,:menuhotsel=black,red:dfocus=white,black:dhotnormal=white,black:dhotfocus=white,black:executable=,black:directory=white,black:link=white,black:device=white,black:special=white,black:core=,black:stalelink=red,black:editnormal=white,black