corban baxter corbanb

Postgres Meta Info

Source - Here

List Tables

Here's the query that will return the names of the tables defined in the current database:

https://gist.github.com/juniorz/1081907

I borrowed heavily from http://blog.shupp.org/2012/08/12/local-timezone-lookups-by-coordinates-with-postgis/ to make # this gist which is geared towards mac users like myself.

Step 1: Prepare to Install Postgresql & Postgis + dependencies using brew

$ brew update

NOTE: if it fails, try this

psql commands

Export to CSV

$ psql postgres://user:pass@localhost:1337/dbname -o 'file.csv' -F , --no-align -c 'SELECT * FROM column ORDER BY created_at ASC;'

Arrays

UPDATE "Jobs" SET "subscribers" = array_replace("subscribers", '[email protected]', '[email protected]') WHERE "deletedAt" IS NULL AND '[email protected]' = ANY ("subscribers")

Setup SSL on Heroku from GoDaddy.com

Heroku Start

$ heroku domains:add secure.mysite.com
$ heroku addons:add ssl

	{
	// JSHint Default Configuration File (as on JSHint website)
	// See http://jshint.com/docs/ for more details

	"maxerr" : 50, // {int} Maximum error before stopping

	// Enforcing
	"bitwise" : true, // true: Prohibit bitwise operators (&, \|, ^, etc.)
	"camelcase" : false, // true: Identifiers must be in camelCase
	"curly" : false, // true: Require {} for every new block or scope

	Steps to install and run PostgreSQL 9.2 using Homebrew (Mac OS X)
	(if you aren't using version 9.1.5, change line 6 with the correct version)

	1. launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist
	2. mv /usr/local/var/postgres /usr/local/var/postgres91
	3. brew update
	4. brew upgrade postgresql
	5. initdb /usr/local/var/postgres -E utf8
	6. pg_upgrade -b /usr/local/Cellar/postgresql/9.1.5/bin -B /usr/local/Cellar/postgresql/9.2.0/bin -d /usr/local/var/postgres91 -D /usr/local/var/postgres
	7. cp /usr/local/Cellar/postgresql/9.2.0/homebrew.mxcl.postgresql.plist ~/Library/LaunchAgents/

	4r5e
	5h1t
	5hit
	God
	God damn
	Goddamn
	a55
	a_s_s
	about
	account

	<!DOCTYPE html>
	<html>
	<head>
	<meta charset="utf-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
	<title></title>
	<link rel="stylesheet" href="">
	</head>
	<body>

	// Sublime Text - Build System for Javascript
	{
	"cmd": ["node", "$file"],
	"selector": "source.js"
	}

	<!--[if lt IE 9]>
	<script src="https://oss.maxcdn.com/libs/respond.js/1.3.0/respond.min.js"></script>
	<![endif]-->

corban baxter corbanb

Postgres Meta Info

List Tables

I borrowed heavily from http://blog.shupp.org/2012/08/12/local-timezone-lookups-by-coordinates-with-postgis/ to make # this gist which is geared towards mac users like myself.

Step 1: Prepare to Install Postgresql & Postgis + dependencies using brew

NOTE: if it fails, try this

psql commands

Export to CSV

Arrays

Setup SSL on Heroku from GoDaddy.com

Heroku Start

Create CSR - https://devcenter.heroku.com/articles/csr