- version(): get the version of the DB server
- date_trunc('second', TIMESTAMP): remove the milleseconds
| #!/bin/bash | |
| set -e | |
| KERNEL_VERSION=`uname -r` # make sure kernel version >= 3.10 | |
| if [[ $KERNEL_VERSION != *"3.1"* ]]; then | |
| echo "Kernel version must be >= 3.10" | |
| fi | |
| # for ubuntu 14: there's nothing required to install | |
| # for ubuntu 12 |
| # execute command when file changed | |
| #!/bin/bash | |
| set -e | |
| prev_cs=""; while true; do | |
| cur_cs="`md5sum $*`" | |
| if [ "$cur_cs" != "$prev_cs" ]; then | |
| rake # change to your command |
| Work | |
| ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQCk/eYwgSbnJEH8338x77vBmZIYvt3YWLKw9U19fiqHuoO/hBlCuclaZtTXru7GTAs6RIa4AGMHnrZixsVUyA+FmGVNRTl6stgM1//+OumZbKmjqtXzr8BeFa1B3IxhPxI6I0AAn2NCuVyn97mREX1XAesKFNMgRaLhFV5/E+W3fkCV1mz1X8uJihVtZxu+fI9Gnb1KjM2ARHBZRQvghhYuCi7kIl7TlWD9DbwNCC2Yk55PRj/bN7NxZxRHdDA/9q2XZU8LJi6oDgs6hwregXgjuoXd9mdi8XhY/JK8p3xRFhfQ8IHoxQJ6X3YYgu4ITreV81MwoH1Qx6QqoJ4hPdGn user@enting | |
| Home (https://tinyurl.com/entingkey) |
\CMD: run CMD in a sub-shell? (useful for not using .bashrc or .zshrc which might have alias)press 1: toggle list cpu usage by cores (useful for understanding load average and io wait)< and >: sort with prev or next colume (starts from cpu)f (field): add or remove column, in top view, press W to save view to ~/.toprc| * 3 kinds of meditation: distracted(not meditating); fixed point meditation; open meditation |
| ## Angluar CLI | |
| * angular new APP_NEW | |
| * angular generate component NEW_COMPONENT |
| ## Javascript Package | |
| * npm install/update [-g (install globally, otherwise in $PWD/node-modules dir)] PACKAGE | |
| ## Cordova CLI (ref: https://cordova.apache.org/docs/en/latest/reference/cordova-cli/) | |
| * cordova <command> [options] -- [platformOpts] | |
| * verbose output: -d | |
| ## Cordova Project |
| composerize: turn docker cli command into docker-compose file | |
| * composerize docker run -p 80:80 -v /var/run/docker.sock:/tmp/docker.sock:ro --restart always --log-opt max-size=1g nginx |
| * BitTorrent (or http) Download: 百度盘离线下载 | |
| * Voip: GMail -> Hangout |