dump.md

Install Homebrew

• xcode-select --install
• /usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"

Install PostgreSQL + PostGIS

• brew update
• brew install postgres
• brew install postgis
• brew services start postgres
• createdb paperstorm
• psql
  Inside psql:
• create extension postgis;
• \q (to quit psql)

Import database

Unzip 'paperstorm.dump.zip'

• psql < /path/to/paperstorm.dump

Connect to database

• psql paperstorm (or \c paperstorm from psql)
• \d (show tables)
• select * from leaflets limit 10;
• select st_x(coordinates) as longitude, st_y(coordinates) as latitude, created_at from leaflets limit 10;

Connect from app

Database URL: 127.0.0.1:5432/paperstorm