fengshuo

Developer Cheat Sheets

This are my cheat sheets that I have compiled over the years. Tired of searching Google for the same things, I started adding the information here. As time went on, this list has grown. I use this almost everyday and this Gist is the first bookmark on my list for quick and easy access.

I recommend that you compile your own list of cheat sheets as typing out the commands has been super helpful in allowing me to retain the information longer.

fengshuo

5 entertaining things you can find with the GitHub Search API

Let's have some command-line fun with curl, [jq][1], and the [new GitHub Search API][2].

Today we're looking for:

• The hottest repositories created in the last week.
• The oldest user accounts with zero followers. (So sad.)
• Issue trends by language.
• Clojure projects defying convention.

fengshuo

  function onOpen() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var menuEntries = [ {name: "Run Query", functionName: "runQuery"} ];
  ss.addMenu("HTTP Archive + BigQuery", menuEntries);
}    

function runQuery() {
  var projectNumber = 'httparchive';
  
  var sheet = SpreadsheetApp.getActiveSheet();

fengshuo

{
	"colorList": {
		"c1"  : ["#000000", "#000011"],
		"c2"  : ["#000011", "#000022"],
		"c3"  : ["#000022", "#000033"],
		"c4"  : ["#000033", "#000044"],
		"c7"  : ["#000044", "#000055"],
		"c8"  : ["#000055", "#000066"],
		"c9"  : ["#000066", "#000077"],
		"c10" : ["#000077", "#000088"]

fengshuo

React "Hello World" Examples

Below are a small collection of React examples to get anyone started using React. They progress from simpler to more complex/full featured.

Going Further

• React documentation
• Flux architecture using Reflux (see this blog post for more)
• React routing with react-router
• My other Gist on using React + Reflux + WebSockets

fengshuo

For those, who don't know how to make this work: create a file, e.g. git_branch_name_to_clipboard.sh in your user directory with following content:

`git branch | grep "*" | awk '{ print $2 }' | pbcopy`  

or use this to remove the new line when you paste:

`git branch | grep "*" | awk '{ print $2 }' | tr -d '\n' | pbcopy`  

Then in `.gitconfig file`, which is located in your user folder, add these lines under [alias]:  

fengshuo

# delete local tag '12345'
git tag -d 12345
# delete remote tag '12345' (eg, GitHub version too)
git push origin :refs/tags/12345
# alternative approach
git push --delete origin tagName
git tag -d tagName

fengshuo

# `ERROR:  Error installing nokogiri:
# ERROR: Failed to build gem native extension.
# 
#   current directory: /usr/local/var/rbenv/versions/2.3.1/lib/ruby/gems/2.3.0/gems/nokogiri-1.7.0/ext/nokogiri
# /usr/local/var/rbenv/versions/2.3.1/bin/ruby -r ./siteconf20170103-68488-r71c9j.rb extconf.rb --with-xml=/usr/local/Cellar/libxml2/ --use-system-libraries
# checking if the C compiler accepts ... yes
# checking if the C compiler accepts -Wno-error=unused-command-line-argument-hard-error-in-future... no
# Building nokogiri using system libraries.
# ERROR: cannot discover where libxml2 is located on your system. please make sure `pkg-config` is installed.
# *** extconf.rb failed ***

fengshuo

-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query 
FROM pg_stat_activity 
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 

fengshuo

/* Class representing a Trie data structure */
export default class Trie {

  /**
   * Creates a Trie
   * @return {Object} Trie
   */
  constructor() {
    this.words = 0;
    this.prefixes = 0;