For the Sunday morning install party at NICAR14 in Baltimore NICAR15 in Atlanta
###MySQL -- a free, open source database manager. Download here: http://dev.mysql.com/downloads/mysql/
Guide here: https://docs.google.com/a/ire.org/document/d/1w2k5MLjD23FNqBgKaCTLEqZbjb8HZuDVff71RKIKTF0/edit
###SQLYog (PC only) -- a GUI for MySQL
Download 'SQLYog Community Edition' here: https://code.google.com/p/sqlyog/wiki/Downloads
###SequelPro (Mac only) -- a GUI for MySQL
Download here: http://www.sequelpro.com/download
###Navicat Lite (free) -- a GUI for multiple database managers
###PostgreSQL -- another free, open source database manager. Windows download: http://www.postgresql.org/download/windows/
OSX download: http://www.postgresql.org/download/macosx/
###Tabula -- liberate data tables trapped in PDF files. Download here: http://tabula.technology/
###CSVkit -- a suite of utilities for converting to and working with CSV. Requires use of the command line
Download here: http://csvkit.readthedocs.org/en/latest/
###Open Refine -- an amazing web-based tool for cleaning data. Download here: http://openrefine.org/ After you have it installed, get up to speed with this tutorial from Tom Meagher.
###Python -- an general-purpose, object-oriented programming language. Recommended version: 2.7.6
Download here: http://www.python.org/download/
If you're a Windows 8.1 user, try Anthony DeBarros's tutorial on installing Python.
Once you have Python installed, you can play with his class on "Getting Started with Python" or dive into the PyCAR class.
###NPR Visuals Team's guide to setting up your Mac Specific to Mac + Python development, the folks on the NPR Visuals team have set up a nice guide to some basics.
Includes:
- OS X Command Line Tools
- Homebrew
- pip
- virtualenv
- Node
- NumPy
- postgres
- postGIS
Also with tips on setting up your Bash profile, terminal and text editing apps.