Ryan Richards rrichards

Apps

Postico client for mac
pgcli - Postgres CLI with autocompletion and syntax highlighting
pghero - Server and query performance dashboard

Tools

PEV - Query planning / Explain analyze visualisation
PostgreSQL's explain analyze made readable

An attempt to show all the many confusing pages google has for various account activities. Feel free to fork and add more.

Disabling History Tracking

https://www.google.com/settings/accounthistory To the right of each setting is a blue circle or grey circle. (Its supposed to represent a toggle switch) Make them ALL GREY. Each time a window will pop up, hit the 'Pause' on the bottom.

The introduction to Reactive Programming you've been missing

(by @andrestaltz)

This tutorial as a series of videos

If you prefer to watch video tutorials with live-coding, then check out this series I recorded with the same contents as in this article: Egghead.io - Introduction to Reactive Programming.

Leanstack.io list of cloud services

Analytics

Moved to git repository: https://github.com/denji/nginx-tuning

NGINX Tuning For Best Performance

For this configuration you can use web server you like, i decided, because i work mostly with it to use nginx.

Generally, properly configured nginx can handle up to 400K to 500K requests per second (clustered), most what i saw is 50K to 80K (non-clustered) requests per second and 30% CPU load, course, this was 2 x Intel Xeon with HyperThreading enabled, but it can work without problem on slower machines.

You must understand that this config is used in testing environment and not in production so you will need to find a way to implement most of those features best possible for your servers.

This is a little trick I use to spin up the packages instalation on Debian/Ubuntu boxes in Vagrant.

I add a simple function that checks if a directory named something similar to ~/.vagrant.d/cache/apt/opscode-ubuntu-12.04/partial (it may have another path in Windows or MacOS) and create the directory if it doesn't already exist.

def local_cache(basebox_name)
  cache_dir = Vagrant::Environment.new.home_path.join('cache', 'apt', basebox_name)
  partial_dir = cache_dir.join('partial')
  partial_dir.mkdir unless partial_dir.exist?
 cache_dir

	#!/bin/bash

	# Initialize MySQL database.
	# ADD this file into the container via Dockerfile.
	# Assuming you specify a VOLUME ["/var/lib/mysql"] or `-v /var/lib/mysql` on the `docker run` command…
	# Once built, do e.g. `docker run your_image /path/to/docker-mysql-initialize.sh`
	# Again, make sure MySQL is persisting data outside the container for this to have any effect.

	set -e
	set -x

	application:open-your-keymap
	application:open-your-stylesheet
	autocomplete:attach
	autoflow:reflow-paragraph
	bookmarks:clear-bookmarks
	bookmarks:jump-to-next-bookmark
	bookmarks:jump-to-previous-bookmark
	bookmarks:toggle-bookmark
	bookmarks:view-all
	check:correct-misspelling

	[merge]
	tool = intellij
	# tool = Kaleidoscope
	[diff]
	tool = intellij
	# tool = Kaleidoscope

	# intellij mergetool config
	[mergetool "intellij"]
	cmd = /Applications/IntelliJ\\ IDEA\ 13\\ CE.app/Contents/MacOS/idea merge $(cd $(dirname "$LOCAL") && pwd)/$(basename "$LOCAL") $(cd $(dirname "$REMOTE") && pwd)/$(basename "$REMOTE") $(cd $(dirname "$BASE") && pwd)/$(basename "$BASE") $(cd $(dirname "$MERGED") && pwd)/$(basename "$MERGED")

	# to generate your dhparam.pem file, run in the terminal
	openssl dhparam -out /etc/nginx/ssl/dhparam.pem 2048