Nguyen Tan Phat uluru-phatnguyen

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

-E: will describe the underlaying queries of the \ commands (cool for learning!)
-l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

Defining Many-to-Many Associations in Sequelize

Reference: Sequelize docs on association

Let’s say we have two models: Films and Festivals

We know that a film can be shown at many film festivals and that, conversely, a festival can show many films. This is what is known as a many-to-many relationship.

Knowing this, we can set up our associations:

We prefer to have audit logging in our services that leverage databases. It gives us clarity into sources of where ACL issues might originate as well as gives us a general timeline of activity in our application.

Audit logging is tedious to set up so this gist contains our latest iteration of audit logging support for a sequelize based service.

I needed a newer version of ImageMagick than is available on the yum packages on Amazon Linux. I tried using the remi repo but it failed with dependency errors. Here is what I did to install ImageMagick with support for PNG, JPG, and TIFF.

download the most recent package

wget http://www.imagemagick.org/download/ImageMagick.tar.gz

uncomress the package

	FROM golang:1.6.2

	COPY . /go

	RUN go get github.com/nats-io/nats
	RUN go build api-server.go

	EXPOSE 8080
	ENTRYPOINT ["/go/api-server"]

	# Plain Ol' Node
	node --max-old-space-size=1024 app.js # increase to 1gb
	node --max-old-space-size=2048 app.js # increase to 2gb
	node --max-old-space-size=3072 app.js # increase to 3gb
	node --max-old-space-size=4096 app.js # increase to 4gb
	node --max-old-space-size=5120 app.js # increase to 5gb
	node --max-old-space-size=6144 app.js # increase to 6gb

	# For pm2
	pm2 start app.js --node-args="--max-old-space-size=1024" # increase to 1gb

	# best practice: linux
	nano ~/.pgpass
	:5432::username:password
	chmod 0600 ~/.pgpass

	# best practice: windows
	edit %APPDATA%\postgresql\pgpass.conf
	:5432::username:password

	# linux

	#!/bin/bash
	#
	# PostgreSQL Backup Script Ver 1.0
	# http://autopgsqlbackup.frozenpc.net
	# Copyright (c) 2005 Aaron Axelsen <[email protected]>
	#
	# This script is based of the AutoMySQLBackup Script Ver 2.2
	# It can be found at http://sourceforge.net/projects/automysqlbackup/
	#
	# The PostgreSQL changes are based on a patch agaisnt AutoMySQLBackup 1.9

	swagger: '2.0'
	info:
	title: ChatWork API
	version: v1
	# the domain of the service
	host: api.chatwork.com
	# array of all schemes that your API supports
	schemes:
	- https
	# will be prefixed to all paths

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