I keep this on my desktop.
brew install postgresql initdb /usr/local/var/postgres -E utf8 gem install lunchy ### Start postgres with lunchy mkdir -p ~/Library/LaunchAgents cp /usr/local/Cellar/postgresql/9.3.3/homebrew.mxcl.postgresql.plist ~/Library/LaunchAgents/
Setup DB from SQL file:
### Setup DB lunchy start postgres created $DBNAME psql -d $DBNAME -f '/path/to/file.sql' lunchy stop postgres
Starting and Stopping PostgreSQL
lunchy start postgres lunchy stop postgres
may run into trouble with local socket… try this:
Connecting with R
# make sure lunch start postgres in terminal first) require(dplyr) db <- src_postgres(dbname=$DBNAME)
Inspired by seeing this post and thought I should toss out what I do.
When I was in high school, I piggy-backed on a friend’s website to host a page for my band. We could post pictures, show locations and dates, lyrics, and pretend like we produced music people cared about. It was mostly a fun way for me to ...
It has been said a thousand times before, but I feel the need to say it again. So much of what Star Wars got right was creating a fully realized, fascinating world. As much as stunning visual effects that have largely stood the test of time were a part of ...
A few thoughts:
Because of the primacy of equity as a goal in school finance system design, the formulas disproportionately benefit less wealthy districts and those with high concentrations of needier students. … because of the universal impact on communities, school finance legislation requires broad political buy-in.
I think it is worth contrasting the ...