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.
$ brew update
https://gist.github.com/juniorz/1081907
$ brew update
{ | |
// 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 |
$ psql postgres://user:pass@localhost:1337/dbname -o 'file.csv' -F , --no-align -c 'SELECT * FROM column ORDER BY created_at ASC;'
UPDATE "Jobs" SET "subscribers" = array_replace("subscribers", 'corbanb+plan@gmail.com', 'corbanb+plan2@gmail.com') WHERE "deletedAt" IS NULL AND 'corbanb+plan@gmail.com' = ANY ("subscribers")
$ heroku domains:add secure.mysite.com
$ heroku addons:add ssl
<!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]--> |
var db = require('./db'), | |
TwitterController = require('./controllers/twitter'), | |
kue = require('kue'), | |
url = require('url'); | |
var redisUrl = url.parse(process.env.REDISTOGO_URL); | |
var tc = new TwitterController(); | |