http://www.blowfisher.net/wiki/ Fri, 02 Oct 2009 11:55:47 +0800 FeedCreator 1.7.2-ppt DokuWiki http://www.blowfisher.net/wiki/lib/images/favicon.ico http://www.blowfisher.net/wiki/ http://www.blowfisher.net/wiki/tech-notes/dokuwiki-install-notes?rev=1201234257 安装 DokuWiki DokuWIKI可以不用数据库支持， 用户管理可基于简单的文件形式，即可满足同时支持若干个维护/管理用户的基本需求 * 下载地址: DokuWiki * 解压缩到www目录: wiki/ * 初始化配置: <http://www.your.domain/wiki/install.php> Fri, 25 Jan 2008 12:10:57 +0800 http://www.blowfisher.net/wiki/tech-notes/freebsd-7-benchmark?rev=1198839848 <http://www.blowfisher.net/gallery/v/fb7_0_db_pfm/> Fri, 28 Dec 2007 19:04:08 +0800 http://www.blowfisher.net/wiki/tech-notes/freebsd-gpt-partition?rev=1198830349 FreeBSD 大卷 GPT 分区备忘 man page: http://www.freebsd.org/cgi/man.cgi?query=gpt... GPT 分区 * 创建一个新的空的GPT gpt create -f /dev/da5 -f 清除MBR及分区表 * 清除一个已经存在的非空的GPT gpt destroy /dev/da5 Fri, 28 Dec 2007 16:25:49 +0800 http://www.blowfisher.net/wiki/tech-notes/freebsd-pppoe-config?rev=1201533636 /etc/rc.conf: network_interfaces="lo0 tun0" ifconfig_tun0= #router_enable="NO" # 注释掉 * 按需拨号： ee /etc/start_if.tun0: ppp -auto mysystem /etc/ppp/ppp.conf: * 注意缩进 default: set log Phase tun command set ifaddr 10.0.0.1/0 10.0.0.2/0 enable dns my-adsl: set device PPPoE:em0 set authname your_login_name set authkey your_passwd set dial set login add default HISADDR Mon, 28 Jan 2008 23:20:36 +0800 http://www.blowfisher.net/wiki/tech-notes/oracle-rownum-page?rev=1198814162 ORACLE中用rownum分页并排序的SQL语句 <http://www.blogjava.net/joessy/articles/1398.html> ORACLE中用rownum分页并排序的SQL语句 以前分页习惯用这样的SQL语句: select * from (select t.*,rownum row_num from mytable t order by t.id) b where b.row_num between 1 and 10 结果发现由于该语句会先生成rownum 后执行order by 子句, 因而排序结果根本不对, 后来在GOOGLE上搜到一篇文章, 原来多套一层select 就能很好的解决该问题,�… Fri, 28 Dec 2007 11:56:02 +0800 http://www.blowfisher.net/wiki/tech-notes/postgresql-tablespace-cost?rev=1198827027 总览 行数: 17,000,000 表大小: 2193M 索引: 4401M ------------------------------------ 存储空间总计: 6594M 表结构 CREATE TABLE tb1 ( id bigserial NOT NULL, b1 bigint NOT NULL DEFAULT 0, b2 bigint NOT NULL DEFAULT 0, b3 bigint NOT NULL DEFAULT 0, n1 integer NOT NULL DEFAULT 0, n2 integer NOT NULL DEFAULT 0, s1 smallint NOT NULL DEFAULT 0, s2 smallint NOT NULL DEFAULT 0, s3 smallint NOT NULL DEFAULT 0, s4 smallint NOT NULL DEFAULT 0,… Fri, 28 Dec 2007 15:30:27 +0800 http://www.blowfisher.net/wiki/tech-notes/postgresql-vs-mysql?rev=1198838658 <http://www.blowfisher.net/gallery/v/pg-vs-mysql> 数据来自 tweakers.net Fri, 28 Dec 2007 18:44:18 +0800 http://www.blowfisher.net/wiki/tech-notes/py-mako-quickdemo?rev=1233837824 Mako 快速参考 注释： ----------------------------------v- ## this is a comment. <%doc> 这里是... 多行的注释。 </%doc> 输出变量： ----------------------------------v- this is x: ${x} 简单运算: ----------------------------------v- "x+y" is: ${x + y} 条件判断： ----------------------------------v- % if x==5: hello x! % endif 循环： ----------------------------------v- % for a in ['one', 'two', 'three', 'four', 'five']: % if a[0] == 't': … Thu, 05 Feb 2009 20:43:44 +0800 http://www.blowfisher.net/wiki/tech-notes/python_datetime_format?rev=1231578495 PYTHON 时间戳格式化参数 <http://docs.python.org/library/datetime.html#module-datetime> Sat, 10 Jan 2009 17:08:15 +0800 http://www.blowfisher.net/wiki/tech-notes/rsync-exclude-pattern?rev=1200552180 Here are some exclude/include examples: --exclude "*.o" would exclude all filenames matching *.o --exclude "/foo" would exclude a file in the base directory called foo --exclude "foo/" would exclude any directory called foo. --exclude "/foo/*/bar" would exclude any file called bar two levels below a base directory called foo. --exclude "/foo/**/bar" would exclude any file called bar two or more levels below a base directory called foo. --include "*/" --include "*.c" --exclude "*" w… Thu, 17 Jan 2008 14:43:00 +0800