Command to to display active connections to a PostgresDB: SELECT * FROM pg_stat_activity;

Connection to Redshift

$ psql -h <ENDPOINT_NAME> -p 5439 -d <DB_NAME> -U <DB_USERNAME>
View gist:2999707
<!doctype html>
<title>Site Maintenance</title>
body { text-align: center; padding: 150px; }
h1 { font-size: 50px; }
body { font: 20px Helvetica, sans-serif; color: #333; }
article { display: block; text-align: left; width: 650px; margin: 0 auto; }
a { color: #dc8100; text-decoration: none; }
a:hover { color: #333; text-decoration: none; }
chmod +x
View program.cs
using System;
namespace DVDScreensaver
class Program
static void Main()
Console.Title = "lmoa";
Screensaver.Start(120,30,new Screensaver.Pos(5,5));
  • configure an embedded local Messaging Broker
  <!-- This creates an embedded ActiveMQ Broker -->
  <broker xmlns="" useJmx="true" persistent="false">
      <transportConnector uri="tcp://localhost:61616" />

Mac web developer apps

This gist's comment stream is a collection of webdev apps for OS X. Feel free to add links to apps you like, just make sure you add some context to what it does — either from the creator's website or your own thoughts.

— Erik

### Why?
# Because it's apparently too much to ask that my $3K laptop be able to
# broker access to my camera without letting it die. But I totally get that
# this is a low priority in comparison to the Touch Bar. You can live without a
# camera, but you can't live without emoji.
sudo killall coreaudiod
View kitty-crunch.zsh-theme
# CRUNCH - created from Steve Eley's cat waxing.
# Initially hacked from the Dallas theme. Thanks, Dallas Reedy.
# This theme assumes you do most of your oh-my-zsh'ed "colorful" work at a single machine,
# and eschews the standard space-consuming user and hostname info. Instead, only the
# things that vary in my own workflow are shown:
# * The time (not the date)
# * The RVM version and gemset (omitting the 'ruby' name if it's MRI)
# * The current directory

Sequence diagram of CouchDB 2.0 compaction

Diaglam of calls during view compaction in CouchDB 2.0. Some steps omitted to simplify things.