Shihua Ma mashihua

Setup new Mac with OSX Lion from scratch.

These commands are good as of 2012-03-18.

Install Xcode 4

The download/install takes a while so start it first. When it finishes downloading you will still need to run it to complete installation.

Note: Make sure you install the XCode Command Line Tools after XCode is done installing. To do this go to Xcodes -> Preferences -> Downloads -> Command Line Tools -> Install. If you don't you might not be able to install brew packages (i.e. brew install wget will fail).*

Thanks to Rico for posting the fix (http://ricochen.wordpress.com/2012/02/18/installing-git-on-mac-os-x-lion-through-homebrew-error-fix/)

Backend Development

node.js
- Installation paths: use one of these techniques to install node and npm without having to sudo.
- Node.js HOWTO: Install Node+NPM as user (not root) under Unix OSes
- Felix's Node.js Guide
- Creating a REST API using Node.js, Express, and MongoDB
- Node Cellar Sample Application with Backbone.js, Twitter Bootstrap, Node.js, Express, and MongoDB
- JavaScript Event Loop
Node.js for PHP programmers

The MySQL slow query log is a difficult format to extract information from. After looking at various examples with mixed results, I realized that it's much easier to configure MySQL to write the slow query log to a table in CSV format!

From the MySQL documentation:

By default, the log tables use the CSV storage engine that writes data in comma-separated values format. For users who have access to the .CSV files that contain log table data, the files are easy to import into other programs such as spreadsheets that can process CSV input.

my.cnf

Note: don't forget to open up permissions on your slow query log CSV file so logstash can read it!

# enable slow query log

	Copyright (c) 2011 Thomas Fuchs, http://mir.aculo.us

	Permission is hereby granted, free of charge, to any person obtaining
	a copy of this software and associated documentation files (the
	"Software"), to deal in the Software without restriction, including
	without limitation the rights to use, copy, modify, merge, publish,
	distribute, sublicense, and/or sell copies of the Software, and to
	permit persons to whom the Software is furnished to do so, subject to
	the following conditions:

	Copyright (c) 2011 YOUR_NAME_HERE, YOUR_URL_HERE

	Permission is hereby granted, free of charge, to any person obtaining
	a copy of this software and associated documentation files (the
	"Software"), to deal in the Software without restriction, including
	without limitation the rights to use, copy, modify, merge, publish,
	distribute, sublicense, and/or sell copies of the Software, and to
	permit persons to whom the Software is furnished to do so, subject to
	the following conditions:

	#!/bin/sh
	# ------------------------------------------------------------------------------
	# SOME INFOS : fairly standard (debian) init script.
	# Note that node doesn't create a PID file (hence --make-pidfile)
	# has to be run in the background (hence --background)
	# and NOT as root (hence --chuid)
	#
	# MORE INFOS : INIT SCRIPT http://www.debian.org/doc/debian-policy/ch-opersys.html#s-sysvinit
	# INIT-INFO RULES http://wiki.debian.org/LSBInitScripts
	# INSTALL/REMOVE http://www.debian-administration.org/articles/28

	SubmitControl.prototype.submit = function() {
	var sXmlReq = "";
	if (BSGetElementIgnoreError("TransID_New") != null) {
	this.addFieldByElementId("TransID_New");
	}
	for (var i = 0; i < this.m_fields.length; i++) {
	var sName = (this.m_fields[i])[0];
	var sValue = (this.m_fields[i])[1];
	if ((sName != null) && (sValue != null)) {
	sValue = sValue.replace("%", "%25");

	.fake_file_input {
	background: url(../images/fake_file_input.png) no-repeat;
	cursor: pointer;
	width: 150px;
	height: 30px;
	overflow: hidden;
	position: relative;
	display: inline-block;
	*display: inline;
	*zoom: 1;

	(*
	Copyright (c) 2008, Christian Mittendorf <[email protected]>
	All rights reserved.

	Redistribution and use in source and binary forms, with or without
	modification, are permitted provided that the following conditions are met:

	Redistributions of source code must retain the above copyright notice, this
	list ofconditions and the following disclaimer. Redistributions in binary form
	must reproduce the above copyright notice, this list of conditions and the

	{
	"emojis": [
	{"emoji": "👩‍👩‍👧‍👧", "name": "family_mothers_two_girls", "shortname": "", "unicode": "", "html": "👩&zwj;👩&zwj;👧&zwj;👧", "category": "p", "order": ""},
	{"emoji": "👩‍👩‍👧‍👦", "name": "family_mothers_children", "shortname": "", "unicode": "", "html": "👩&zwj;👩&zwj;👧&zwj;👦", "category": "p", "order": ""},
	{"emoji": "👩‍👩‍👦‍👦", "name": "family_mothers_two_boys", "shortname": "", "unicode": "", "html": "👩&zwj;👩&zwj;👦&zwj;👦", "category": "p", "order": ""},
	{"emoji": "👨‍👩‍👧‍👧", "name": "family_two_girls", "shortname": "", "unicode": "", "html": "👨&zwj;👩&zwj;👧&zwj;👧", "category": "p", "order": ""},
	{"emoji": "👨‍👩‍👧‍👦", "name": "family_children", "shortname": "", "unicode": "", "html": "👨&zwj;👩&zwj;👧&zwj;👦", "category": "p", "order": ""},
	{"emoji": "👨‍👩‍👦‍👦", "name": "family_two_boys", "shortname": "", "unicode": "", "html": "👨&zw