austinmcconnell

// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console

austinmcconnell

@media only screen and (max-width: 600px) {

	.minimum .site-tagline{
		display: none;
	}
	
	.home-featured-1,
	.home-featured-2,
	.home-featured-3,
	.home-featured-4 {

austinmcconnell

Common Postgres Things

Create

Create new user

CREATE USER $user_name$;

CREATE USER $user_name$ WITH PASSWORD '$password$';

Create new database

CREATE DATABASE $new_db_name$;

austinmcconnell

First, check your current config (example output in `homebrew.mxcl.postgresql.plist.xml` lower down in this gist):

    cat ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist

Most importantly, note the `-D /usr/local/var/postgres` argument.

Second, shut down your current PostgreSQL.

    brew services stop postgresql

austinmcconnell

from pathlib import Path
import subprocess

CURRENT_DIR = Path('.')

projects = sorted([x for x in CURRENT_DIR.iterdir() if x.is_dir()])

for project in projects:

    print('*' * 70)

austinmcconnell

command+delete          Send Hex Code: 0x15           kill line backward
command+shift+delete    Send Hex Code: 0x0B           kill line forward
option+delete           Send Hex Code: 0x17           kill word backward
option+shift+delete     Send Escape Sequence: Esc+d   kill word forward
command+left            Send Hex Code: 0x01           move to start of line
command+right           Send Hex Code: 0x05           move to end of line
option+left             Send Escape Sequence: Esc+b   move word backward
option+left             Send Escape Sequence: Esc+f   move word forward

austinmcconnell

# usage: create_sftp_user <username>
function create_sftp_user() {
    # create user
    sudo adduser --disabled-password --gecos "" $1

    # prevent ssh login & assign SFTP group
    sudo usermod -g sftpaccess $1
    sudo usermod -s /bin/nologin $1

    # chroot user (so they only see their directory after login)

austinmcconnell

** Find commmonly accessed tables and their use of indexes:

SELECT relname,seq_tup_read,idx_tup_fetch,cast(idx_tup_fetch AS numeric) / (idx_tup_fetch + seq_tup_read) AS idx_tup_pct FROM pg_stat_user_tables WHERE (idx_tup_fetch + seq_tup_read)>0 ORDER BY idx_tup_pct;

Returns output like:

       relname        | seq_tup_read | idx_tup_fetch |      idx_tup_pct       
----------------------+--------------+---------------+------------------------
 schema_migrations    |          817 |             0 | 0.00000000000000000000
 user_device_photos   |          349 |             0 | 0.00000000000000000000

austinmcconnell

Keybase proof

I hereby claim:

• I am austinmcconnell on github.
• I am austinmcconnell (https://keybase.io/austinmcconnell) on keybase.
• I have a public key whose fingerprint is AD0E FDBD 8AB8 C942 B24F 45EB D10D 0D7D E28C E6C6

To claim this, I am signing this object:

austinmcconnell

Shakespeare Sonnet++ Postmortem (incident #465)

Date

2015-10-21

Authors

• jennifer
• martym