Installing Postgres 9.5 On OSX

02 Aug 2015

Edit 12/25/2020: I’d recommend using: https://postgresapp.com/

Ended up being surprisingly easy:

brew uninstall postgresql brew install postgresql-9.5 brew link -f postgresql-9.5 mv /usr/local/var/postgres /usr/local/var/postgres.old initdb -D /usr/local/var/postgres # restore old database? # pg_upgrade -b /usr/local/Cellar/postgresql/9.0.4/bin -B /usr/local/Cellar/postgresql/9.1.2/bin -d /usr/local/var/postgres.old -D /usr/local/var/postgres # start postgres pg_ctl -D /usr/local/var/postgres -l logfile start

New Macbook Pro Setup

26 Jul 2015

I’m finally switching to a Macbook Pro as my personal computer after a few months of using one at work. Local development on OSX is a lot easier and bug-free than on a Windows computer.

I started a gist with what I did for setup:

Important tips: * to open applications quickly, command + space and type the application name * mac doesn't have an address bar in finder, you need to use command + shift + g to type a directory path * mac doesn't have "snap window to screen" like windows does, you need to install moom for this * activity monitor = task manager * brew install = apt get install (you'll need to install brew) * use command + tilde to switch between windows for the same application Setup: * Upgrade to El Capitan through the app store if you haven't already * Install chrome (https://www.google.com/chrome/browser/desktop/) * Install chrome plugins (adblock, etc) * Install brew * /usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)" * Install iterm2 (https://www.iterm2.com/) * Fix alt + left/right arrow in iterm: http://apple.stackexchange.com/a/136931 * open up iterm with command + space and type "brew install git" * Install xcode and agree to terms of service (it's required by some things) * Install sequelpro (http://www.sequelpro.com/download) * Install sublime text * Install sublime package manager and plugins (like anaconda) * restore sublime text settings from other computer * Security hardening (especially turn off bluetooth): http://docs.hardentheworld.org/OS/OSX_10.11_El_Capitan/index.html * Open dock settings and check "Automatically hide and show dock" * Open trackpad settings and enable "Tap to Click" * Open keyboard settings and set "key repeat" to "Fast" and "delay until repeat" to "Short" * Install dropbox

In Order to Configure TCP/IP, You Must Install and Enable a Network Adapter Card

12 Jul 2015 If you get this error message, you need to disable and uninstall your network adapter. Once you've done that, you can reinstall the driver to fix it.

Cygwin - Python Compiled Without SSL Support

11 Jul 2015 Download error on https://pypi.python.org/simple/pip/: unknown url type:
https -- Some packages may not be found!

ImportError: cannot import name HTTPSHandler

I was trying to install pip in cygwin when this happened. Searches say openssl-devel needed to be installed, but it already was. Apparently python was compiled without ssl support.

My solution was to install cygwin-x86 instead of the 64x one.

md5sum: standard input: no properly formatted MD5 checksum lines found

11 Jul 2015 If you see this error when you're using apt-cyg, it means you need to update apt-cyg.

You need to run the following commands:

lynx -source rawgit.com/transcode-open/apt-cyg/master/apt-cyg > apt-cyg
install apt-cyg /bin

Automatically Remove Long-Running Docker Containers

28 Jun 2015

The following can be used in cron or run with & at the end of the command:

I found this didn’t work: http://www.ahtik.com/blog/removing-detached-docker-containers-automatically/

Docker Run In Crontab

03 Jun 2015 "0 5 * * 1 docker run --rm --name=mycontainer ubuntu:13.10 /opt/bin/job"
The above command is an example of how "docker run" would be used in crontab to run once every week at 5am.

--rm will delete the container once the job is finished running
--name will name the container and prevent duplicate jobs from running
You don't need to use "&" at the end, because crons already run in the background.

MySQL Batch Updates Not Working

08 May 2015 Looking at "SHOW PROCESSLIST" and it looks like your queries are running individually instead of in batches like you sent?

This happens because MySQL runs each update statement individually, but you should still be able to see the batches when the queries are in the "init" state.

Use this query to see the batched queries:
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST where state="init";

New Flask Template

23 Mar 2015 https://github.com/xen/flask-project-template/

It's also an interesting example of using docker for a flask project.

"Error response from daemon: 404 page not found" - Docker

13 Feb 2015 This required setting the following in my /etc/environment:

no_proxy=/var/run/docker.sock

Older Newer