themathmagician

PSQL Cheatsheet

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)

Setting up a new Git Repo

##Create a new repository on the command line

touch README.md
git init
git add README.md
git commit -m "first commit"

git remote add origin git@github.com:alexpchin/.git

Quick Setup for Sublime Text 3 for Angular 2

Easy to remember, easy to forget.

Step 1: Download Sublime Text 3

Sublime Text 3 Download

Step 2: Create a bash shortcut

It's nice to be able to run subl in a terminal.

Maintaining Java Installs on macOS Using Homebrew Cask

Recently, I upgraded my MacBook Pro from a old, trusty Yosemite to Sierra, and reluctantly had to clean out the old JDK versions I had accumulated over a few years. I also wanted to have a Java 9 JDK to play around with the new module system and API’s.

Good news is that, for a while now, you have been able to install and upgrade multiple versions of JDK using only your shell, without having to deal with Oracle’s graphical installers.

To install Java from scratch, install Homebrew Cask cask-update (you need to have Homebrew already installed) first, then install Java using Cask:

brew tap buo/cask-upgrade & brew tap caskroom/versions
brew cask install java8

	Feature: API
	In order to use the service from third party apps
	As a user
	I want to be able to use an API

	Background:
	Given a user exists # Pickle
	And I login as the user using basic auth

	Scenario Outline: Get a ticket

	# Add the following 'help' target to your Makefile
	# And add help text after each target name starting with '\#\#'

	help: ## Show this help.
	@fgrep -h "##" $(MAKEFILE_LIST) \| fgrep -v fgrep \| sed -e 's/\\$$//' \| sed -e 's/##//'

	# Everything below is an example

	target00: ## This message will show up when typing 'make help'
	@echo does nothing

	// Sequence of numbers
	val xs = Seq(1, 5, 3, 4, 6, 2)

	// Sort using Natural ordering as defined for Integers in Scala Library
	xs.sorted //1,2,3,4,5,6

	// Sort 'with' a comparator function
	xs.sortWith(_<_) //1,2,3,4,5,6
	xs.sortWith(_>_) //6,5,4,3,2,1
	xs.sortWith((left,right) => left > right) //6,5,4,3,2,1

	postgres:
	image: postgres:9.4
	volumes:
	- ./init.sql:/docker-entrypoint-initdb.d/init.sql

	type FilterOperator = 'AND' \| 'OR';
	type FiltersBy<T> = {
	[K in keyof T]?: (value: T[K]) => boolean;
	};

	/**
	* Factory function that creates a specialized function to filter
	* arrays, by validating all filters (AND operator),
	* or validating just one of the filters (OR operator).
	* @param operator Method to validate all filters: AND, OR

	FROM alpine:3.6
	RUN apk add --no-cache --update gcc make automake autoconf libtool musl-dev zlib-dev git openssl nodejs nodejs-npm imagemagick

	RUN git clone https://github.com/skyrpex/potrace.git && \
	cd potrace && \
	autoreconf -i && \
	./configure && make && make install

	RUN npm install -g svgo