Mateo mph-code

FWIW: I (@rondy) am not the creator of the content shared here, which is an excerpt from Edmond Lau's book. I simply copied and pasted it from another location and saved it as a personal note, before it gained popularity on news.ycombinator.com. Unfortunately, I cannot recall the exact origin of the original source, nor was I able to find the author's name, so I am can't provide the appropriate credits.

Effective Engineer - Notes

By Edmond Lau
Highly Recommended 👍
http://www.theeffectiveengineer.com/

What's an Effective Engineer?

Free O'Reilly books and convenient script to just download them.

Thanks /u/FallenAege/ and /u/ShPavel/ from this Reddit post

How to use:

Take the download.sh file and put it into a directory where you want the files to be saved.
cd into the directory and make sure that it has executable permissions (chmod +x download.sh should do it)
Run ./download.sh and wee there it goes. Also if you do not want all the files, just simply comment the ones you do not want.

Trello

Postgres Cheatsheet

This is a collection of the most common commands I run while administering Postgres databases. The variables shown between the open and closed tags, "<" and ">", should be replaced with a name you choose. Postgres has multiple shortcut functions, starting with a forward slash, "". Any SQL command that is not a shortcut, must end with a semicolon, ";". You can use the keyboard UP and DOWN keys to scroll the history of previous commands you've run.

Setup

installation, Ubuntu

http://www.postgresql.org/download/linux/ubuntu/ https://help.ubuntu.com/community/PostgreSQL

npm rank

This gist is updated daily via cron job and lists stats for npm packages:

Top 1,000 most depended-upon packages
Top 1,000 packages with largest number of dependencies
Top 1,000 packages with highest PageRank score

I was playing with GitHub Archive recently. Out of curiosity I ran this query:

SELECT COUNT(repository_owner) as totalStars, repository_owner
FROM [githubarchive:github.timeline] 
WHERE type = 'WatchEvent'
AND repository_organization IS NULL
GROUP BY repository_owner
ORDER BY totalStars DESC

I was playing with GitHub Archive recently. Out of curiosity I ran this query:

SELECT COUNT(repository_owner) as totalStars, repository_owner
FROM [githubarchive:github.timeline] 
WHERE type = 'WatchEvent'
GROUP BY repository_owner
ORDER BY totalStars DESC
LIMIT 1000

	[
	{
	owner: 'bcoe',
	repo: 'top-npm-users',
	description: ':star: Generate a list of top npm users by based on monthly downloads.',
	language: 'JavaScript',
	isFork: false,
	stargazers: 27,
	watchers: 27
	}

	#!/bin/bash

	checkExisting(){

	echo "Checking if already existing device on file..."

	while read fileLine; do

	if [ "$line" = "$fileLine" ]; then
	echo "[WARNING] Device already initialized on this system. Nothing to do here"

	// How to use:
	// 1. Open "Script Editor" (requires OS X 10.10 Yosemite)
	// 2. Change the language from "AppleScript" to "JavaScript"
	// 3. Paste the code below and replace the safari example.
	//
	// More info:
	// https://developer.apple.com/library/mac/releasenotes/InterapplicationCommunication/RN-JavaScriptForAutomation/index.html

	var sys_events = Application("System Events");