====== python install ====== ===== python on windows ===== * download python 2.7.x windows installer from https://www.python.org/ * download psycopg2 windows installer from http://initd.org/psycopg/ ===== python on mac ===== * python was already installed on mac, but it was Apple's version * installed macports version of python # to change to macports python... sudo port select --set python python27 # to change back... sudo port select --set python python27-apple psycopg2 and mysql drivers were easily installed with macports using these commands: sudo port install py27-psycopg2 sudo port install py27-mysql however, for the following items, pip was used with apple python to learn how it works; each of these were available on macports and could easily be installed from there ===== pip and postgres driver ===== * install pip and psycopg2 * pip is a package manager for python * download get-pip.py from https://pip.pypa.io/en/latest/installing.html sudo python ~/Downloads/get-pip.py * ''sudo pip install psycopg2'' failed because it couldn't find pg_config * postgres was already installed with macports, so I modified the path export PATH=$PATH:/opt/local/lib/postgresql93/bin * this now worked sudo pip install psycopg2 ===== sqlite ===== * sqlite3 is installed by default with python ===== mysql ===== * mysql was already installed with macports, so I modified the path export PATH=$PATH:/opt/local/lib/mysql55/bin * this now worked sudo pip install MySQL-python ===== view installed modules ===== * ''python'' (starts an interactive python shell) * ''help('modules')''