Skip to content

Instantly share code, notes, and snippets.

lifelong learner

yangbo.zhou yangboz

lifelong learner
View GitHub Profile
Kartones /
Last active Jul 6, 2020
PostgreSQL command line cheatsheet


Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

  • -E: will describe the underlaying queries of the \ commands (cool for learning!)
  • -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)
mt3 /
Created Sep 8, 2012 — forked from nicolashery/
Deploy Python app using Pandas on Heroku

Deploy Python app using Pandas on Heroku


This document explains how to deploy a Python app that uses the Pandas library on Heroku.

Heroku builds Numpy (one of Pandas' requirements) fine. However, when trying to deploy an app with both numpy and pandas in its requirements.txt file (or even just pandas), for some reason it fails

You can’t perform that action at this time.