Skip to content

Instantly share code, notes, and snippets.

lifelong learner

Knight.zhou yangboz

lifelong learner
Block or report user

Report or block yangboz

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
Kartones /
Last active Dec 15, 2019
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.