果凍
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