Skip to content

Instantly share code, notes, and snippets.

View yeliu84's full-sized avatar

Ye Liu yeliu84

View GitHub Profile
{"lastUpload":"2019-08-13T05:35:05.693Z","extensionVersion":"v3.4.1"}
Verifying my Blockstack ID is secured with the address 1Ays5dZiZ7dMaEpEqrVbCom6CcfSnPArsV https://explorer.blockstack.org/address/1Ays5dZiZ7dMaEpEqrVbCom6CcfSnPArsV
@yeliu84
yeliu84 / ejectall.sh
Last active October 21, 2017 07:25
Eject all disks
# http://osxdaily.com/2014/05/22/eject-all-mounted-volumes-command-line-mac/
osascript -e 'tell application "Finder" to eject (every disk whose ejectable is true)'

Keybase proof

I hereby claim:

  • I am jaux on github.
  • I am jaux (https://keybase.io/jaux) on keybase.
  • I have a public key ASBj7OSCN4gcTribY2YApNHMyXV5ZPAfsGQFfoup6Gm4-Qo

To claim this, I am signing this object:

@yeliu84
yeliu84 / cpus.sh
Last active August 29, 2015 14:21 — forked from jj1bdx/cpus.sh
#!/bin/sh
# Originally from:
# https://github.com/blankpage/e5UNIXBuilder/blob/master/build-akili.sh
# Linux and similar...
CPUS=`getconf _NPROCESSORS_ONLN 2>/dev/null`
# FreeBSD and similar...
[ -z "$CPUS" ] && CPUS=`getconf NPROCESSORS_ONLN`
# Solaris and similar...
[ -z "$CPUS" ] && CPUS=`ksh93 -c 'getconf NPROCESSORS_ONLN'`
@yeliu84
yeliu84 / user_comments.sql
Created January 29, 2015 07:30
Answer for Seven Databases in Seven Weeks: Day 3 Do#2
/**
* Seven Databases in Seven Weeks: Day 3 Do#2
*
* Expand the movies database to track user comments and extract keywords
* (minus English stopwords). Cross-reference these keywords with actors’ last
* names, and try to find the most talked about actors.
*/
-- create user_comments table
DROP TABLE IF EXISTS user_comments;
@yeliu84
yeliu84 / search_movies.sql
Created January 28, 2015 23:23
Answer for Seven Databases in Seven Weeks Day 3 Do#1
/**
* Seven Databases in Seven Weeks: Day 3 Do#1
*
* Create a stored procedure where you can input a movie title or actor’s name
* you like, and it will return the top five suggestions based on either movies
* the actor has starred in or films with similar genres.
*/
CREATE OR REPLACE FUNCTION search_movies(term text) RETURNS SETOF movies AS $$
DECLARE
@yeliu84
yeliu84 / commit-msg.sh
Last active August 29, 2015 14:09
Prepend issue number to commit message.
#!/bin/bash
#
# Author: Ye Liu
# URL: https://gist.github.com/jaux/0380afaaada554488054
# License: MIT
TICKET_FILE="$(pwd)/.last-ticket"
line=$(head -n 1 "$1")
@yeliu84
yeliu84 / 0_reuse_code.js
Created June 3, 2014 15:52
Here are some things you can do with Gists in GistBox.
// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console
@yeliu84
yeliu84 / dataToBinaryFile.js
Last active August 29, 2015 13:57
Write base64 encoded image data as binary file
(function() {
'use strict';
var imageData = '/9j/4AAQSkZJRgABAQEASgBKAAD/4gxYSUNDX1BST0ZJTEUAAQEAAAxITGlubwIQAABtbnRyUkdCIFhZWiAHzgACAAkABgAxAABhY3NwTVNGVAAAAABJRUMgc1JHQgAAAAAAAAAAAAAAAAAA9tYAAQAAAADTLUhQICAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABFjcHJ0AAABUAAAADNkZXNjAAABhAAAAGx3dHB0AAAB8AAAABRia3B0AAACBAAAABRyWFlaAAACGAAAABRnWFlaAAACLAAAABRiWFlaAAACQAAAABRkbW5kAAACVAAAAHBkbWRkAAACxAAAAIh2dWVkAAADTAAAAIZ2aWV3AAAD1AAAACRsdW1pAAAD+AAAABRtZWFzAAAEDAAAACR0ZWNoAAAEMAAAAAxyVFJDAAAEPAAACAxnVFJDAAAEPAAACAxiVFJDAAAEPAAACAx0ZXh0AAAAAENvcHlyaWdodCAoYykgMTk5OCBIZXdsZXR0LVBhY2thcmQgQ29tcGFueQAAZGVzYwAAAAAAAAASc1JHQiBJRUM2MTk2Ni0yLjEAAAAAAAAAAAAAABJzUkdCIElFQzYxOTY2LTIuMQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAWFlaIAAAAAAAAPNRAAEAAAABFsxYWVogAAAAAAAAAAAAAAAAAAAAAFhZWiAAAAAAAABvogAAOPUAAAOQWFlaIAAAAAAAAGKZAAC3hQAAGNpYWVogAAAAAAAAJKAAAA+EAAC2z2Rlc2MAAAAAAAAAFklFQyBodHRwOi8vd3d3LmllYy5jaAAAAAAAAAAAAAAAFklFQyBodHRwOi8vd3d3LmllYy5jaAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA