Lee Xiang Wei xwlee

Raw CSV data is made available by Common Data Hub here:

http://www.commondatahub.com/live/geography/state_province_region/iso_3166_2_state_codes

http://www.commondatahub.com/live/geography/country/iso_3166_country_codes

The table cdh_state_codes (see cdh-schema.sql below) is designed to hold the raw data, which should import readily using most common database tools, or directly into MySQL via LOAD DATA, e.g.:

SET FOREIGN_KEY_CHECKS=0;

TRUNCATE TABLE iso3166.cdh_state_codes;

Conventions:

Defining Eloquent model (will assume that DB table named is set as plural of class name and primary key named "id"):

class Shop extends Eloquent {}

Using custom table name

protected $table = 'my_shops';

Each of these commands will run an ad hoc http static server in your current (or specified) directory, available at http://localhost:8000. Use this power wisely.

Discussion on reddit.

Python 2.x

$ python -m SimpleHTTPServer 8000

New computer setup

a/o 2020-05-29

--

Format the drive

Restart with Cmd-R or Cmd-D
Erase drive / 3x if second-hand
Reinstall MacOS

###Jeffrey Way (1) - Bootcamp

Jeffrey went through about 12 subjects one right after the other and gave tips along the way.

Mail Drivers for mail notifications.

1. With Laravel 4.2 it’s easier to use APIs like Mailgun and Mandrill for e-mail notifications. This avoids using SMTP which is really cool.

File Generators for generating schema migrations.

	// knockout 2.2.1

	ko.utils.arrayFilter = function (array, predicate) { /* .. */ }

	ko.utils.arrayFirst = function (array, predicate, predicateOwner) { /* .. */ }

	ko.utils.arrayForEach = function (array, action) { /* .. */ }

	ko.utils.arrayGetDistinctValues = function (array) { /* .. */ }

	abc 1 2 3
	def 4 5 6
	ga 7 9 10
	hij 1 5 99

	sudo su postgres

	psql

	update pg_database set datistemplate=false where datname='template1';
	drop database Template1;
	create database template1 with owner=postgres encoding='UTF-8'
	lc_collate='en_US.utf8' lc_ctype='en_US.utf8' template template0;

	update pg_database set datistemplate=true where datname='template1';

	//
	// _oo0oo_
	// o8888888o
	// 88" . "88
	// (\| -_- \|)
	// 0\ = /0
	// ___/`---'\___
	// .' \\\| \|// '.
	// / \\\|\|\| : \|\|\|// \
	// / _\|\|\|\|\| -:- \|\|\|\|\|- \

	# alias to edit commit messages without using rebase interactive
	# example: git reword commithash message
	reword = "!f() {\n GIT_SEQUENCE_EDITOR=\"sed -i 1s/^pick/reword/\" GIT_EDITOR=\"printf \\\"%s\\n\\\" \\\"$2\\\" >\" git rebase -i \"$1^\";\n git push -f;\n}; f"

	# sort list of git repos with gh cli
	gh repo list --limit 300 --json name -q '.[].name' \| sort

	# count total commits in a repo
	git rev-list --all --count