果凍

Mock - Mocking and Testing Library http://mock.readthedocs.org/en/latest/http ://mock.readthedocs.org/en/latest/

i3 - Quickly jumping to open window https://wiki.archlinux.org/index.php/I3#Quickly_jumping_to_open_window

讓 title bar 顯示 bash 正在執行的程序

# If this is an xterm set the title to user@host:dir
case "$TERM" in
xterm*|rxvt*)
    PROMPT_COMMAND='echo -ne "\033]0;${USER}@${HOSTNAME}: ${PWD}\007"'
    # Show the currently running command in the terminal title:
    # http://www.davidpashley.com/articles/xterm-titles-with-bash.html
    show_command_in_title_bar()
    {
        case "$BASH_COMMAND" in
            *\033]0*)
                # The command is trying to set the title bar as well;
                # this is most likely the execution of $PROMPT_COMMAND.
                # In any case nested escapes confuse the terminal, so don't
                # output them.
                ;;
            *)
                echo -ne "\033]0;${USER}@${HOSTNAME}: ${BASH_COMMAND}\007"
                ;;
        esac
    }
    trap show_command_in_title_bar DEBUG
    ;;
*)
    ;;
esac

bash prompt for git https://github.com/magicmonty/bash-git-prompt

bash prompt demo http://www.gilesorr.com/bashprompt/prompts/

philipz

Postgres-XL http://www.postgres-xl.org/

AndrewChang

Phabricator http://fab.wmflabs.org/project/board/31/

beststeve

Malzilla - malware hunting tool http://malzilla.sourceforge.net/

yan

$ crontab -e or $ crontab mycron

$ contab -l concat two row into one column

select userRoles.userId, GROUP_CONCAT(roles.name) from roles, userRoles where roles.id=userRoles.roleId group by userRoles.userId

sqlalchey subquery http://stackoverflow.com/questions/6206600/sqlalchemy-subquery-in-a-where-clause