Skip to content

Instantly share code, notes, and snippets.

@Eunoia

Eunoia/details.md

Last active February 8, 2018 19:30
Show Gist options
  • Save Eunoia/e4a441d3196b0b2ad1938201bb39ed97 to your computer and use it in GitHub Desktop.
Save Eunoia/e4a441d3196b0b2ad1938201bb39ed97 to your computer and use it in GitHub Desktop.
Download ZIP
Pre planning
Raw
details.md

Howdy!

We're going to look at some data in Postgresql. To get started, you might want to get some useful tools first.

The good GUI client

https://macpostgresclient.com/

To install postgresql locally

brew install postgresql

The data

SQL File

https://gist.github.com/Eunoia/b0154a5427d12b22d1c11405be6e2932

Premade database

postgres://zruiigrkjnbmtu:ec6a6548859ba51bdec586f802ae00a6b34beee8c5fe561994b3cb023928ea63@ec2-107-21-95-70.compute-1.amazonaws.com:5432/d92i9sgremv43k

  • user_name: zruiigrkjnbmtu
  • password: ec6a6548859ba51bdec586f802ae00a6b34beee8c5fe561994b3cb023928ea63
  • host: ec2-107-21-95-70.compute-1.amazonaws.com
  • database: d92i9sgremv43k

Raw listings

https://gist.githubusercontent.com/Eunoia/5449e606b746165b38ac8a6341ace3be/raw/06af2dcec707e80acd26fa2beb45fe19f5de27b9/listings.csv

Raw Calendar Data

https://gist.githubusercontent.com/Eunoia/ee25b8ef7c3b3a57206938f5485c02a9/raw/480f86569ae25931aaf59ee54084da32549bef56/calendar.csv

Loading the database into your local database

psql postgres < ~/Downloads/airbnb2.sql

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment