1、postgreSQL INSERT 和SELECT 语句的嵌套用法，usage：
insert into route("route-key",name) values((select max("route-key") from route)+10000,'helloRoute')2、Ubuntu GIF 制作工具: byzanz
#install
sudo apt-get install byzanz
#使用
xwininfo
#点击你要截图位置，终端打印如下内容（我点击的是chrome浏览器）
xwininfo: Please select the window about which you
would like information by clicking the
mouse in that window.
xwininfo: Window id: 0x3a00001 "New Tab - Google Chrome"
Absolute upper-left X: 65
Absolute upper-left Y: 24
Relative upper-left X: 0
Relative upper-left Y: 0
Width: 1301
Height: 744
Depth: 24
Visual: 0x20
Visual Class: TrueColor
Border width: 0
Class: InputOutput
Colormap: 0x22 (installed)
Bit Gravity State: NorthWestGravity
Window Gravity State: NorthWestGravity
Backing Store State: NotUseful
Save Under State: no
Map State: IsViewable
Override Redirect State: no
Corners: +65+24 -0+24 -0-0 +65-0
-geometry 1301x744-0-0
#这里主要信息有： Absolute upper-left X， Absolute upper-left Y，Width，Height，在终端输入：
byzanz-record -x 65 -y 24 -w 1301 -h 715 /home/mercy/x.gif
#就可以制作GIF了
