<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:georss='http://www.georss.org/georss' xmlns:gd='http://schemas.google.com/g/2005' xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-4641852024075864603</id><updated>2011-04-21T17:20:18.199-07:00</updated><category term='linux'/><category term='system'/><category term='lighttpd'/><category term='log processing'/><category term='emacs'/><category term='postgresql'/><category term='scv'/><category term='mysql'/><category term='php'/><category term='kubuntu'/><category term='pg_autovacuum'/><category term='ssh'/><category term='monitoring'/><category term='pure-ftp'/><category term='arabs'/><category term='sql'/><category term='errors'/><category term='tunnelling'/><category term='debian'/><category term='video'/><category term='server'/><category term='network'/><category term='fun'/><category term='command line shell scriptiong'/><category term='russian'/><category term='accents'/><category term='ftp'/><title type='text'>web developer notes</title><subtitle type='html'>this is the place i use for my notes.
My interests are Linux system administration, php programming, postgresql  server, emacs and lighttpd.</subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://web-dev-tip.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default?max-results=100'/><link rel='alternate' type='text/html' href='http://web-dev-tip.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>Sergey</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>21</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>100</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-4641852024075864603.post-5115363659941769123</id><published>2008-04-18T15:30:00.000-07:00</published><updated>2008-05-30T04:04:54.689-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='command line shell scriptiong'/><title type='text'>Recursively convert encoding</title><content type='html'>for i in `find . -type f -print`; &lt;br /&gt;do &lt;br /&gt;iconv -f CP1251 -t UTF-8 $i -o $i.new;&lt;br /&gt;mv -f $i.new $i; &lt;br /&gt;done&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4641852024075864603-5115363659941769123?l=web-dev-tip.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://web-dev-tip.blogspot.com/feeds/5115363659941769123/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=4641852024075864603&amp;postID=5115363659941769123' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/5115363659941769123'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/5115363659941769123'/><link rel='alternate' type='text/html' href='http://web-dev-tip.blogspot.com/2008/04/recursively-convert-encoding.html' title='Recursively convert encoding'/><author><name>Sergey</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4641852024075864603.post-7109415019780539726</id><published>2008-02-20T01:57:00.000-08:00</published><updated>2008-02-20T02:03:30.976-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='log processing'/><title type='text'>Robots/Bots by user agent</title><content type='html'>&lt;div style="width:100%;height:400px;overflow:scroll"&gt;&lt;br /&gt;&lt;pre&gt;&lt;br /&gt; count |                                                                                                                      user_agent                                                                                                                      &lt;br /&gt;-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------&lt;br /&gt; 16.86 | Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)&lt;br /&gt;  3.75 | Mozilla/5.0 (compatible; LinksManager.com_bot +http://linksmanager.com/linkchecker.html)&lt;br /&gt;  2.69 | msnbot/1.0 (+http://search.msn.com/msnbot.htm)&lt;br /&gt;  2.21 | LinkLint-spider/2.3.5&lt;br /&gt;  1.99 | Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)&lt;br /&gt;  1.28 | msnbot-media/1.0 (+http://search.msn.com/msnbot.htm)&lt;br /&gt;  0.64 | ia_archiver&lt;br /&gt;  0.51 | Mozilla/4.0 (compatible; NaverBot/1.0; http://help.naver.com/delete_main.asp)&lt;br /&gt;  0.51 | Speedy Spider (http://www.entireweb.com/about/search_tech/speedy_spider/)&lt;br /&gt;  0.43 | Mozilla/5.0 (compatible; Yahoo! Slurp/3.0; http://help.yahoo.com/help/us/ysearch/slurp)&lt;br /&gt;  0.43 | LmCrawler&lt;br /&gt;  0.41 | Morfeus Fucking Scanner&lt;br /&gt;  0.39 | IRLbot/3.0 (compatible; MSIE 6.0; http://irl.cs.tamu.edu/crawler)&lt;br /&gt;  0.38 | Smart/Spider 2.61.3 - Mozilla/4.0&lt;br /&gt;  0.35 | Gigabot/3.0 (http://www.gigablast.com/spider.html)&lt;br /&gt;  0.31 | Speedy Spider (http://www.entireweb.com/about/search_tech/speedyspider/)&lt;br /&gt;  0.28 | ichiro/2.0 (http://help.goo.ne.jp/door/crawler.html)&lt;br /&gt;  0.27 | Mozilla/4.0 compatible ZyBorg/1.0 Dead Link Checker (wn.dlc@looksmart.net; http://www.WISEnutbot.com)&lt;br /&gt;  0.25 | Mozilla/5.0 (compatible; Exabot/3.0; +http://www.exabot.com/go/robot)&lt;br /&gt;  0.23 | e-SocietyRobot(http://www.yama.info.waseda.ac.jp/~yamana/es/)&lt;br /&gt;  0.22 | Yeti/0.01 (nhn/1noon, yetibot@naver.com, check robots.txt daily and follow it)&lt;br /&gt;  0.22 | Baiduspider+(+http://www.baidu.com/search/spider.htm)&lt;br /&gt;  0.21 | bot/1.0 (bot; http://; bot@bot.bot)&lt;br /&gt;  0.19 | Baiduspider+(+http://www.baidu.com/search/spider_jp.html)&lt;br /&gt;  0.19 | CazoodleBot/CazoodleBot-0.1 (CazoodleBot Crawler; http://www.cazoodle.com/cazoodlebot; cazoodlebot@cazoodle.com)&lt;br /&gt;  0.17 | WebAlta Crawler/2.0 (http://www.webalta.net/ru/about_webmaster.html) (Windows; U; Windows NT 5.1; ru-RU)&lt;br /&gt;  0.16 | msnbot/0.9 (+http://search.msn.com/msnbot.htm)&lt;br /&gt;  0.16 | CazoodleBot/Nutch-0.9-dev (CazoodleBot Crawler; http://www.cazoodle.com; mqbot@cazoodle.com)&lt;br /&gt;  0.15 | MJ12bot/v1.2.0 (http://majestic12.co.uk/bot.php?+)&lt;br /&gt;  0.14 | MJ12bot/v1.0.8 (http://majestic12.co.uk/bot.php?+)&lt;br /&gt;  0.14 | Gigabot/2.0 (http://www.gigablast.com/spider.html)&lt;br /&gt;  0.14 | Shim-Crawler(Mozilla-compatible; http://www.logos.ic.i.u-tokyo.ac.jp/crawler/; crawl@logos.ic.i.u-tokyo.ac.jp)&lt;br /&gt;  0.13 | Exabot/3.0&lt;br /&gt;  0.13 | Mozilla/5.0 (Twiceler-0.9 http://www.cuill.com/twiceler/robot.html)&lt;br /&gt;  0.12 | Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.8.1) VoilaBot BETA 1.2 (http://www.voila.com/)&lt;br /&gt;  0.12 | libwww-perl/5.805&lt;br /&gt;  0.12 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; QihooBot 1.0  qihoobot@qihoo.net)&lt;br /&gt;  0.12 | Mozilla/5.0 (compatible; Yahoo! Slurp China; http://misc.yahoo.com.cn/help.html)&lt;br /&gt;  0.11 | Acme.Spider&lt;br /&gt;  0.11 | MSNBOT_Mobile MSMOBOT Mozilla/2.0 (compatible; MSIE 4.02; Windows CE; Default)&lt;br /&gt;  0.11 | Mozilla/4.0 compatible ZyBorg/1.0 (wn-14.zyborg@looksmart.net; http://www.WISEnutbot.com)&lt;br /&gt;  0.11 | voyager/1.0&lt;br /&gt;  0.10 | Nokia6682/2.0 (3.01.1) SymbianOS/8.0 Series60/2.6 Profile/MIDP-2.0 configuration/CLDC-1.1 UP.Link/6.3.0.0.0 (compatible;YahooSeeker/M1A1-R2D2; http://help.yahoo.com/help/us/ysearch/crawling/crawling-01.html)&lt;br /&gt;  0.10 | genieBot wgao@genieknows.com&lt;br /&gt;  0.10 | FAST MetaWeb Crawler (helpdesk at fastsearch dot com)&lt;br /&gt;  0.10 | ConveraCrawler/0.9e (+http://www.authoritativeweb.com/crawl)&lt;br /&gt;  0.09 | : TCL Crawler (crawler@tcllab.org), Java/1.5.0_06&lt;br /&gt;  0.08 | sproose/1.0beta (sproose bot; http://www.sproose.com/bot.html; crawler@sproose.com)&lt;br /&gt;  0.08 | CazoodleBot/Nutch-0.9-dev (CazoodleBot Crawler; http://www.cazoodle.com/cazoodlebot; cazoodlebot@cazoodle.com)&lt;br /&gt;  0.08 | Mozilla/5.0 (compatible; MJ12bot/v1.2.1; http://www.majestic12.co.uk/bot.php?+)&lt;br /&gt;  0.08 | Accoona-AI-Agent/1.1.2 (aicrawler at accoonabot dot com)&lt;br /&gt;  0.08 | ia_archiver-web.archive.org&lt;br /&gt;  0.08 | FAST Enterprise Crawler 6 used by Singapore Press Holdings (crawler@sphsearch.sg)&lt;br /&gt;  0.07 | ICC-Crawler(Mozilla-compatible; http://kc.nict.go.jp/icc/crawl.html; icc-crawl(at)ml(dot)nict(dot)go(dot)jp)&lt;br /&gt;  0.07 | MQBOT/Nutch-0.9-dev (MQBOT Nutch Crawler; http://vwbot.cs.uiuc.edu; mqbot@cs.uiuc.edu)&lt;br /&gt;  0.07 | UbiCrawler/v0.4beta (http://gii.nagaokaut.ac.jp/~ubi/)&lt;br /&gt;  0.07 | Mozilla/5.0 (compatible; Gigamega.bot/1.0; +http://www.gigamega.net/bot.html)&lt;br /&gt;  0.06 | my-heritrix-crawler(+http://mywebsite.com)&lt;br /&gt;  0.06 | Speedy Spider (Entireweb; Beta/1.3; http://www.entireweb.com/about/search_tech/speedyspider/)&lt;br /&gt;  0.06 | MSRBOT&lt;br /&gt;  0.06 | Mozilla/4.0 (compatible; BOTW Spider; +http://botw.org)&lt;br /&gt;  0.05 | DoCoMo/2.0 N902iS(c100;TB;W24H12)(compatible; moba-crawler; http://crawler.dena.jp/)&lt;br /&gt;  0.05 | MSRBOT (http://research.microsoft.com/research/sv/msrbot)&lt;br /&gt;  0.05 | DoCoMo/1.0/N505i/c20/TB/W20H10 (compatible; Googlebot-Mobile/2.1; +http://www.google.com/bot.html)&lt;br /&gt;  0.05 | ConveraCrawler/0.9d (+http://www.authoritativeweb.com/crawl)&lt;br /&gt;  0.05 | Snapbot/1.0&lt;br /&gt;  0.05 | sogou spider&lt;br /&gt;  0.05 | libwww-perl/5.803&lt;br /&gt;  0.04 | ICC-Crawler(Mozilla-compatible; http://kc.nict.go.jp/icc/crawl.html; icc-crawl-contact(at)ml(dot)nict(dot)go(dot)jp)&lt;br /&gt;  0.04 | Mozilla/5.0 (compatible; heritrix/1.12.0 +http://www.accelobot.com)&lt;br /&gt;  0.04 | YahooFeedSeeker/2.0 (compatible; Mozilla 4.0; MSIE 5.5; http://publisher.yahoo.com/rssguide; users 0; views 16)&lt;br /&gt;  0.04 | noxtrumbot/1.0 (crawler@noxtrum.com)&lt;br /&gt;  0.04 | TurnitinBot/2.1 (http://www.turnitin.com/robot/crawlerinfo.html)&lt;br /&gt;  0.04 | Mozilla/5.0 (compatible; BecomeBot/3.0; +http://www.become.com/site_owners.html)&lt;br /&gt;  0.04 | Mozilla/5.0 (compatible; Webbot/0.1; http://www.webbot.ru/bot.html)&lt;br /&gt;  0.04 | YahooFeedSeeker/2.0 (compatible; Mozilla 4.0; MSIE 5.5; http://publisher.yahoo.com/rssguide)&lt;br /&gt;  0.04 | iearthworm/1.0, mailto:iearthworm@yahoo.com.cn&lt;br /&gt;  0.04 | Teemer (NetSeer, Inc. is a Los Angeles based Internet startup company.; http://www.netseer.com/crawler.html; crawler@netseer.com)&lt;br /&gt;  0.04 | KAIST AITrc Crawler&lt;br /&gt;  0.04 | MSRBOT (http://research.microsoft.com/research/sv/msrbot/&lt;br /&gt;  0.04 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT; MS Search 4.0 Robot)&lt;br /&gt;  0.04 | Mozilla/5.0 (Windows;) NimbleCrawler 2.0.1 obeys UserAgent NimbleCrawler For problems contact: crawler@healthline.com&lt;br /&gt;  0.04 | Mozilla/4.0 (compatible; MSIE 4.01; Windows NT; MS Search 5.0 Robot)&lt;br /&gt;  0.03 | McBot/5.001 (windows; U; NT4.0; en-us)&lt;br /&gt;  0.03 | SurveyBot/2.3 (Whois Source)&lt;br /&gt;  0.03 | spider tspyyp@tom.com&lt;br /&gt;  0.03 | Snapbot/1.0 (Snap Shots, +http://www.snap.com)&lt;br /&gt;  0.03 | genieBot genieBot@genieknows.com&lt;br /&gt;  0.03 | Gigabot/1.0&lt;br /&gt;  0.03 | ShopWiki/1.0 ( +http://www.shopwiki.com/wiki/Help:Bot)&lt;br /&gt;  0.03 | YahooFeedSeeker/2.0 (compatible; Mozilla 4.0; MSIE 5.5; http://publisher.yahoo.com/rssguide; users 1; views 64)&lt;br /&gt;  0.03 | Yahoo-MMCrawler/3.x (mms dash mmcrawler dash support at yahoo dash inc dot com)&lt;br /&gt;  0.03 | Sensis Web Crawler (search_comments\\at\\sensis\\dot\\com\\dot\\au)&lt;br /&gt;  0.03 | disco/Nutch-1.0-dev (experimental crawler; www.discoveryengine.com; disco-crawl@discoveryengine.com)&lt;br /&gt;  0.03 | Factbot 1.09&lt;br /&gt;  0.03 | DiGi-RSSBot&lt;br /&gt;  0.03 | Mozilla/5.0 (compatible; googlebot/2.1; +http://www.google.com/bot.html) googlebot@google.com&lt;br /&gt;  0.03 | Mozilla/5.0 (compatible; heritrix/1.8.0 +http://crawlerx51.com)&lt;br /&gt;  0.03 | Mozilla/5.0 (compatible; archive.org_bot/1.13.1x +http://crawler.archive.org)&lt;br /&gt;  0.02 | Googlebot/2.1 (+http://www.google.com/bot.html)&lt;br /&gt;  0.02 | Speedy Spider (Entireweb; Beta/1.2; http://www.entireweb.com/about/search_tech/speedyspider/)&lt;br /&gt;  0.02 | NaverBot-1.0 (NHN Corp. / +82-31-784-1989 / nhnbot@naver.com)&lt;br /&gt;  0.02 | Gigabot/2.0&lt;br /&gt;  0.02 | Snapbot/1.0 (+http://www.snap.com)&lt;br /&gt;  0.02 | NIF/1.1  (http://www.newsisfree.com/robot.php)&lt;br /&gt;  0.02 | FAST Enterprise Crawler 6 used by fast (jorgent@fast)&lt;br /&gt;  0.02 | Mozilla/5.0 (compatible; Konqueror/3.5; Linux) KHTML/3.5.5 (like Gecko) (Exabot-Thumbnails)&lt;br /&gt;  0.02 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; QihooBot 1.0)&lt;br /&gt;  0.02 | RedBot/redbot-1.0 (Rediff.com Crawler; redbot at rediff dot com)&lt;br /&gt;  0.02 | Mozilla/5.0 (compatible; YodaoBot/1.0; http://www.yodao.com/help/webmaster/spider/; )&lt;br /&gt;  0.02 | WebCrawler_1.1 internet@bredband.net&lt;br /&gt;  0.02 | Mozilla/5.0 (compatible;YodaoBot-Image/1.0;http://www.yodao.com/help/webmaster/spider/;)&lt;br /&gt;  0.02 | LocalcomBot/1.3.0 (+http://www.local.com/bot.htm)&lt;br /&gt;  0.02 | ilial/Nutch-0.9 (Ilial, Inc. is a Los Angeles based Internet startup company. For more information please visit http://www.ilial.com/crawler; http://www.ilial.com/crawler; crawl@ilial.com)&lt;br /&gt;  0.02 | Mozilla/5.0 (compatible; AnsearchBot/1.0; +http://www.ansearch.com.au/)&lt;br /&gt;  0.02 | Nokia6820/2.0 (4.83) Profile/MIDP-1.0 Configuration/CLDC-1.0 (compatible; Googlebot-Mobile/2.1; +http://www.google.com/bot.html)&lt;br /&gt;  0.02 | st7bot/0.03&lt;br /&gt;  0.02 | ilial/Nutch-0.9 (Ilial, Inc. is a Los Angeles based Internet startup company.; http://www.ilial.com/crawler; crawl@ilial.com)&lt;br /&gt;  0.02 | NetResearchServer/4.0(loopimprovements.com/robot.html)&lt;br /&gt;  0.02 | http://www.almaden.ibm.com/cs/crawler   [bc23]&lt;br /&gt;  0.02 | Googlebot-Image/1.0&lt;br /&gt;  0.02 | VMBot/0.9 (VMBot; http://www.verticalmatch.com; vmbot@tradedot.com)&lt;br /&gt;  0.02 | Mozilla/4.0 (compatible; LinkMarket-Bot)&lt;br /&gt;  0.02 | Mozilla/5.0 (compatible; BecomeJPBot/2.3; MSIE 6.0 compatible; +http://www.become.co.jp/site_owners.html)&lt;br /&gt;  0.02 | Gigabot/2.0; http://www.gigablast.com/spider.html&lt;br /&gt;  0.02 | Gaisbot/3.0+(robot06@gais.cs.ccu.edu.tw;+http://gais.cs.ccu.edu.tw/robot.php)&lt;br /&gt;  0.02 | libwww-perl/5.79&lt;br /&gt;  0.02 | Factbot 1.09 (see http://www.factbites.com/webmasters.php)&lt;br /&gt;  0.02 | VadixBot&lt;br /&gt;  0.01 | Nutch/Nutch-1.0-dev (Experimental webcrawler for personal research; http://lucene.apache.org/nutch/; nutch at h0m3)&lt;br /&gt;  0.01 | LapozzBot/1.4 (+http://robot.lapozz.hu)&lt;br /&gt;  0.01 | Mozilla/5.0 (compatible; BecomeBot/2.3; MSIE 6.0 compatible; +http://www.become.com/site_owners.html)&lt;br /&gt;  0.01 | Teemer (NetSeer, Inc.; http://www.netseer.com/crawler.html; crawler@netseer.com)&lt;br /&gt;  0.01 | Mozilla/5.0 compatible WebaltBot/1.00 (i686-pc-linux)&lt;br /&gt;  0.01 | Speedy Spider (Entireweb; Beta/1.0; http://www.entireweb.com/about/search_tech/speedyspider/)&lt;br /&gt;  0.01 | Speedy Spider (Entireweb; Beta/1.1; http://www.entireweb.com/about/search_tech/speedyspider/)&lt;br /&gt;  0.01 | SeznamBot/2.0 (+http://fulltext.seznam.cz/)&lt;br /&gt;  0.01 | MSRBOT (http://research.microsoft.com/research/sv/msrbot/)&lt;br /&gt;  0.01 | Mozilla/5.0 (compatible; Exabot Test/3.0; +http://www.exabot.com/go/robot)&lt;br /&gt;  0.01 | Steeler/3.3 (http://www.tkl.iis.u-tokyo.ac.jp/~crawler/)&lt;br /&gt;  0.01 | LinksManager.com_bot&lt;br /&gt;  0.01 | libwww-perl/5.65&lt;br /&gt;  0.01 | Nusearch Spider (www.nusearch.com)&lt;br /&gt;  0.01 | Mozilla/5.0 (compatible; worio bot heritrix/1.10.0 +http://worio.com)&lt;br /&gt;  0.01 | RSSMicro.com RSS/Atom Feed Robot&lt;br /&gt;  0.01 | Sogou web spider/3.0(+http://www.sogou.com/docs/help/webmasters.htm#07)&lt;br /&gt;  0.01 | NPBot/3 (NPBot; http://www.nameprotect.com; npbot@nameprotect.com)&lt;br /&gt;  0.01 | Krugle/Krugle,Nutch/0.8+ (Krugle web crawler; http://corp.krugle.com/crawler/info.html; webcrawler@krugle.com)&lt;br /&gt;  0.01 | Mozilla/5.0 (compatible; woriobot heritrix/1.10.0 +http://worio.com)&lt;br /&gt;  0.01 | Pluggd/Nutch-0.9 (automated crawler; http://www.pluggd.com; support at pluggd dot com)&lt;br /&gt;  0.01 | NutchCVS/0.8-dev (Nutch running at UW; http://www.nutch.org/docs/en/bot.html; sycrawl@cs.washington.edu)&lt;br /&gt;  0.01 | VMBot/0.7.2 (VMBot; http://www.VerticalMatch.com/; vmbot@tradedot.com)&lt;br /&gt;  0.01 | HMSE_Robot&lt;br /&gt;  0.01 | genieBot enash@genieknows.com&lt;br /&gt;  0.01 | NutchCVS/0.7.2 (Nutch; http://lucene.apache.org/nutch/bot.html; nutch-agent@lucene.apache.org)&lt;br /&gt;  0.01 | SeznamBot/1.0 (+http://fulltext2.seznam.cz/)&lt;br /&gt;  0.01 | EmeraldShield.com Web Spider (http://www.emeraldshield.com/webbot.aspx)&lt;br /&gt;  0.01 | genieBot (wgao@genieknows.com)&lt;br /&gt;  0.01 | Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; Girafabot; girafabot at girafa dot com; http://www.girafa.com)&lt;br /&gt;  0.01 | ExaBotTest/2.0&lt;br /&gt;  0.01 | OutfoxBot/0.5 (for internet experiments; http://; outfoxbot@gmail.com)&lt;br /&gt;  0.01 | VWBOT/Nutch-0.9-dev (VWBOT Nutch Crawler; http://vwbot.cs.uiuc.edu; vwbot@cs.uiuc.edu)&lt;br /&gt;  0.01 | MJ12bot/v1.1.0 (http://majestic12.co.uk/bot.php?+)&lt;br /&gt;  0.01 | Acoon-Robot v3.00 (http://www.acoon.de and http://www.acoon.com)&lt;br /&gt;  0.01 | RufusBot (Rufus Web Miner; http://www.webaroo.com/rooSiteOwners.html)&lt;br /&gt;  0.01 | woriobot (+http://www.worio.com)&lt;br /&gt;  0.01 | ZIBB Crawler (email address / WWW address)&lt;br /&gt;  0.01 | psbot/0.1 (+http://www.picsearch.com/bot.html)&lt;br /&gt;  0.01 | Twiceler www.cuill.com/twiceler/robot.html&lt;br /&gt;  0.01 | LarbinWebCrawler spider@download11.com&lt;br /&gt;  0.01 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322; MSIECrawler)&lt;br /&gt;  0.01 | msnbot-Products/1.0 (+http://search.msn.com/msnbot.htm)&lt;br /&gt;  0.01 | PHP version tracker (http://www.nexen.net/phpversion/bot.php)&lt;br /&gt;  0.01 | IRLbot/2.0 (compatible; MSIE 6.0; http://irl.cs.tamu.edu/crawler)&lt;br /&gt;  0.01 | NextGenSearchBot 1 (for information visit http://www.zoominfo.com/About/misc/NextGenSearchBot.aspx)&lt;br /&gt;  0.01 | VisBot/2.0 (Visvo.com Crawler; http://www.visvo.com/bot.html; bot@visvo.com)&lt;br /&gt;  0.01 | nicebot&lt;br /&gt;  0.01 | Findexa Crawler (http://www.findexa.no/gulesider/article26548.ece)&lt;br /&gt;  0.01 | Gigabot/2.0att&lt;br /&gt;  0.01 | sogou develop spider&lt;br /&gt;  0.01 | lawinfo-crawler/Nutch-0.9-dev (Crawler for lawinfo.com pages; http://www.lawinfo.com; webmaster@lawinfo.com)&lt;br /&gt;  0.01 | Mozilla/5.0 (compatible; AnsearchBot/1.0; +http://www.ansearch.com/)&lt;br /&gt;  0.01 | aipbot/2 (aipbot; http://www.aipbot.com; aipbot@aipbot.com)&lt;br /&gt;  0.01 | Twiceler-0.9 http://www.cuill.com/twiceler/robot.html&lt;br /&gt;  0.00 | Mozilla/4.0 (BejiBot Crawler 1.2a)&lt;br /&gt;  0.00 | IlseBot/1.1&lt;br /&gt;  0.00 | owsBot/0.2 (owsBot; www.oneworldstreet.com; owsBot)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1;  http://www.changedetection.com/bot.html )&lt;br /&gt;  0.00 | Mozilla/5.0 (compatible; askpeter_jeanie_2008_bot/4.1; +http://www.askpeter.info)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows 98) (via babelfish.yahoo.com)&lt;br /&gt;  0.00 | Bigsearch.ca/Nutch-1.0-dev (Bigsearch.ca Internet Spider; http://www.bigsearch.ca/; info@enhancededge.com)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; MRSPUTNIK 1, 8, 0, 17 SW; MRA 4.10 (build 01952); .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; MSIECrawler)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible: FDSE robot)&lt;br /&gt;  0.00 | SonyEricssonP910c/R2A SEMC-Browser/Symbian/3.0 Profile/MIDP-2.0 Configuration/CLDC-1.0 (compatible;YahooSeeker/M1A1-R2D2; http://help.yahoo.com/help/us/ysearch/crawling/crawling-01.html)&lt;br /&gt;  0.00 | HouxouCrawler/Nutch-0.9 (houxou.com's nutch-based crawler which serves special interest on-line communities; http://www.houxou.com/crawler; crawler at houxou dot com)&lt;br /&gt;  0.00 | NUTCHCRAWLER/Nutch-0.9 (anouar@yatinoo.com)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; MSIECrawler)&lt;br /&gt;  0.00 | Googlebot/1.0 (Googlebot; http://www.google.com/; googlebot@google.com)&lt;br /&gt;  0.00 | ScSpider/0.2&lt;br /&gt;  0.00 | 411.info Crawler (http://411.info)&lt;br /&gt;  0.00 | KDDI-CA33 UP.Browser/6.2.0.10.4 (GUI) MMP/2.0 (compatible; Googlebot-Mobile/2.1; +http://www.google.com/bot.html)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; Alexa Toolbar; MSIECrawler)&lt;br /&gt;  0.00 | Mozilla/5.0 (compatible; Synoobot/0.9; http://www.synoo.com/search/bot.html)&lt;br /&gt;  0.00 | Mozilla/5.0 (compatible; OWPBot/0.3; http://www.openwhitepages.com/)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; FunWebProducts; MSIECrawler)&lt;br /&gt;  0.00 | Mozilla/5.0 (compatible; CjLogbot 1.0; +http://www.cjlog.com/bot)&lt;br /&gt;  0.00 | ichiro/3.0 (http://help.goo.ne.jp/door/crawler.html)&lt;br /&gt;  0.00 | libwww-perl/5.76&lt;br /&gt;  0.00 | DataparkSearch/4.46 (+http://dataparksearch.org/bot)&lt;br /&gt;  0.00 | Qweery_robot.txt_CheckBot/3.01 (http://qweerybot.qweery.com)&lt;br /&gt;  0.00 | ZoomSpider - wrensoft.com [ZSEBOT]&lt;br /&gt;  0.00 | Mozilla/5.0 (compatible; TridentSpider/3.1)&lt;br /&gt;  0.00 | CazoodleBot/0.1 (CazoodleBot Crawler; http://www.cazoodle.com; mqbot@cazoodle.com)&lt;br /&gt;  0.00 | spider (tspyyp@tom.com)&lt;br /&gt;  0.00 | genieBot (genieBot@genieknows.com)&lt;br /&gt;  0.00 | Cazoodle/Nutch-0.9-dev (Cazoodle Nutch Crawler; http://www.cazoodle.com; mqbot@cazoodle.com)&lt;br /&gt;  0.00 | Pete-Spider Light/1.46&lt;br /&gt;  0.00 | KAIST AITrc Crawler(\xba\xbb crawler\xb4\xc2 \xbf\xac\xb1\xb8\xbf\xeb\xc0\xd4\xb4\xcf\xb4\xd9. crawling\xc0\xbb \xbf\xf8\xc7\xcf\xc1\xf6 \xbe\xca\xc0\xb8\xbd\xc3\xb8\xe9 \xbf\xac\xb6\xf4\xc1\xd6\xbd\xc3\xb1\xe2 \xb9\xd9\xb6\xf8\xb4\xcf\xb4\xd9.&lt;br /&gt;  0.00 | lanshanbot/1.0&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE is not me; EDI/1.6.6; Edacious &amp; Intelligent Web Robot; Daum Communications Corp., Korea)&lt;br /&gt;  0.00 | msnbot/1.0+(+http://search.msn.com/msnbot.htm)&lt;br /&gt;  0.00 | Mozilla/3.0 (compatible; ScollSpider; http://www.webwobot.com)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; SIMBAR Enabled; FunWebProducts; SIMBAR={7D736384-0BF3-4924-AFC2-80D3C73DB022}; MSIECrawler)&lt;br /&gt;  0.00 | OrangeSpider&lt;br /&gt;  0.00 | LTI/LemurProject Nutch Spider/Nutch-1.0-dev (Research spider using Nutch; http://lucene.apache.org/nutch/bot.html; admin@lemurproject.org)&lt;br /&gt;  0.00 | Keyword Density Analyzer v1.01 ( http://www.ranks.nl/tools/spider.html )&lt;br /&gt;  0.00 | SouFZ-Spider[SouFZ.COM]&lt;br /&gt;  0.00 | libwww-perl/5.64&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; MyIE2; .NET CLR 1.1.4322) (via babelfish.yahoo.com)&lt;br /&gt;  0.00 | libwww-perl/5.53&lt;br /&gt;  0.00 | Feed-Directory/0.1 (+http://www.feed-directory.com/bot.html)&lt;br /&gt;  0.00 | QweeryBot/3.02 (http://qweerybot.qweery.nl)&lt;br /&gt;  0.00 | blogsearchbot-pumpkin-2&lt;br /&gt;  0.00 | GnoZtiK bot/1.0 (http://www.gnoztik.com)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; FunWebProducts; .NET CLR 2.0.50727; MSIECrawler)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; DigExt) (via babelfish.yahoo.com)&lt;br /&gt;  0.00 | shaboyi spider&lt;br /&gt;  0.00 | NextGenSearchBot 1 (for information visit http://about.zoominfo.com/About/NextGenSearchBot.aspx)&lt;br /&gt;  0.00 | Mozilla/5.0 (compatible; Megaglobe Crawler/1.0; http://www.megaglobe.com)&lt;br /&gt;  0.00 | SygolBot http://www.sygol.com&lt;br /&gt;  0.00 | yacybot (i386 Linux 2.6.20-vs2.2.0-gentoo; java 1.5.0_11; Europe/en) http://yacy.net/yacy/bot.html&lt;br /&gt;  0.00 | Exabot-Test/1.0&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) (via babelfish.yahoo.com)&lt;br /&gt;  0.00 | Seekbot/1.0 (http://www.seekbot.net/bot.html) RobotsTxtFetcher/1.2&lt;br /&gt;  0.00 | Mozilla/5.0 (SnapPreviewBot) Gecko/20061206 Firefox/1.5.0.9&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Voyager; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE is not me; DAUMOA/1.0.0; DAUM Web Robot; Daum Communications Corp., Korea)&lt;br /&gt;  0.00 | Shim-Crawler(Mozilla-compatible; http://www.logos.ic.i.u-tokyo.ac.jp/crawl/; crawl@logos.ic.i.u-tokyo.ac.jp)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; MSIECrawler)&lt;br /&gt;  0.00 | Yahoo! Mindset&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; SIMBAR Enabled; .NET CLR 1.1.4322; MSIECrawler)&lt;br /&gt;  0.00 | MQbot http://metaquerier.cs.uiuc.edu/crawler&lt;br /&gt;  0.00 | Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.8.1.9) Gecko/20071025 Firefox/2.0.0.9 (via babelfish.yahoo.com)&lt;br /&gt;  0.00 | WebarooBot (Webaroo Bot; http://64.124.122.252/feedback.html)&lt;br /&gt;  0.00 | ScollSpider/2.0 (+http://www.webwobot.com/ScollSpider.php)&lt;br /&gt;  0.00 | yacybot (i386 Linux 2.6.9-023stab033.9-smp; java 1.5.0_10; Europe/de) http://yacy.net/yacy/bot.html&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 4.0), libwww-perl/5.69&lt;br /&gt;  0.00 | MJ12bot/v1.1.2 (http://majestic12.co.uk/bot.php?+)&lt;br /&gt;  0.00 | zerxbot/Version 0.6 libwww-perl/5.79&lt;br /&gt;  0.00 | varsabulur.com [ZSEBOT]&lt;br /&gt;  0.00 | Norbert the Spider(Burf.com)&lt;br /&gt;  0.00 | Googlebot/2.1 (+http://www.googlebot.com/bot.html; MSIE 6.0; Windows NT 5.1; SV1)&lt;br /&gt;  0.00 | Mozilla/5.0 (Yahoo-Test/4.0 mailto:vertical-crawl-support@yahoo-inc.com)&lt;br /&gt;  0.00 | gsa-crawler (Enterprise; S4-FUVPASTFQ6AAB; dahe@google.com)&lt;br /&gt;  0.00 | ZoomSpider - wrensoft.com&lt;br /&gt;  0.00 | owsBot/0.1 (Nutch; www.oneworldstreet.com; nutch-agent@lucene.apache.org)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible;  Vagabondo/4.0Beta; webcrawler at wise-guys dot nl; http://webagent.wise-guys.nl/)&lt;br /&gt;  0.00 | TerrawizBot/1.0 (+http://www.terrawiz.com/bot.html)&lt;br /&gt;  0.00 | holmes/3.11 (http://morfeo.centrum.cz/bot)&lt;br /&gt;  0.00 | GigaBot/1.0&lt;br /&gt;  0.00 | MOT-V975/81.33.02I MIB/2.2.1 Profile/MIDP-2.0 Configuration/CLDC-1.1 (compatible;YahooSeeker/M1A1-R2D2; http://help.yahoo.com/help/us/ysearch/crawling/crawling-01.html)&lt;br /&gt;  0.00 | boitho.com-dc/0.85 ( http://www.boitho.com/dcbot.html )&lt;br /&gt;  0.00 | Grub/2.0 (Grub.org crawler; http://www.grub.org/; bot@grub.org)&lt;br /&gt;  0.00 | Sogou Orion spider/3.0(+http://www.sogou.com/docs/help/webmasters.htm#07)&lt;br /&gt;  0.00 | GurujiBot/1.0 (+http://www.guruji.com/WebmasterFAQ.html)&lt;br /&gt;  0.00 | Mozilla/5.0 (Yahoo-Test/4.0; yahoo-ysm-ks@yahoo-inc.com)&lt;br /&gt;  0.00 | Sogou head spider/3.0(+http://www.sogou.com/docs/help/webmasters.htm#07)&lt;br /&gt;  0.00 | oBot&lt;br /&gt;  0.00 | LTI/LemurProject Nutch Spider/Nutch-1.0-dev (Research spider using Nutch; http://www.lemurproject.org; mhoy@cs.cmu.edu)&lt;br /&gt;  0.00 | FyberSpider&lt;br /&gt;  0.00 | Gigabot/2.0/gigablast.com/spider.html&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; FunWebProducts; .NET CLR 1.1.4322; MSIECrawler)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE is not me; DAUMOA/1.0.1; DAUM Web Robot; Daum Communications Corp., Korea)&lt;br /&gt;  0.00 | Evaal/0.7.2 (Evaal search engine; http://evaal.coml; bot@evaal.com)&lt;br /&gt;  0.00 | Blogobot/Delta&lt;br /&gt;  0.00 | k2spider&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.2; SV1; .NET CLR 1.1.4322; Girafabot [girafa.com])&lt;br /&gt;  0.00 | BilgiBot/1.0(beta) (http://www.bilgi.com/; bilgi at bilgi dot com)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; FunWebProducts; HbTools 4.8.4; MSIECrawler)&lt;br /&gt;  0.00 | btfc Obotnxmnuiulrftvu&lt;br /&gt;  0.00 | Jyxobot/1&lt;br /&gt;  0.00 | pythonic-crawler (suzuki@tkl.iis.u-tokyo.ac.jp)&lt;br /&gt;  0.00 | FDF-Bot - Free Domainfinder by www.geld13.de&lt;br /&gt;  0.00 | Mozilla/5.0 (compatible; askpeter_jeanie_2008_bot/4.2; +http://www.askpeter.info)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; DigExt; .NET CLR 1.0.3705; Zango 10.0.341.0; MSIECrawler)&lt;br /&gt;  0.00 | Mozilla/5.0 (Yahoo-Test/4.0; mailto:vertical-crawl-support@yahoo-inc.com)&lt;br /&gt;  0.00 | i1searchbot/2.0 (i1search web crawler; http://www.i1search.com; crawler@i1search.com)&lt;br /&gt;  0.00 | Exabot/2.0&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705; Googlebot; .NET CLR 1.1.4322; .NET CLR 1.0.3705; Googlebot)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; FunWebProducts; HbTools 4.8.4; SeekmoToolbar 4.8.4; MSIECrawler)&lt;br /&gt;  0.00 | Yeti/0.01 (nhn/1noon, yetibot@naver.com, check robots.txt daily and follows it)&lt;br /&gt;  0.00 | GurujiBot/1.0 (+http://www.guruji.com/en/WebmasterFAQ.html)&lt;br /&gt;  0.00 | Jambot/0.2.1 (Jambot; http://www.jambot.com/blog/static.php?page=webmaster-robot; crawler@jambot.com)&lt;br /&gt;  0.00 | libwww-perl/5.48&lt;br /&gt;  0.00 | Metaeuro Web Crawler/0.2 (MetaEuro Web Search Clustering Engine; http://www.metaeuro.com; crawlwer at metaeuro dot com)&lt;br /&gt;  0.00 | WebarooBot (Webaroo Bot; http://www.webaroo.com/rooSiteOwners.html)&lt;br /&gt;  0.00 | kicktooBotV1.1 kictooBot@kictoo.com&lt;br /&gt;  0.00 | Novosoft Spider/Nutch-0.9 (http://www.novosoft.net)&lt;br /&gt;  0.00 | LBot&lt;br /&gt;  0.00 | PCbot/5.3&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows 98; yie6_SBC; YPC 3.0.1; Alexa Toolbar; MSIECrawler)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; NaverBot/1.0; nhnbot@naver.com)&lt;br /&gt;  0.00 | SpiderVex v0.1&lt;br /&gt;  0.00 | Mozilla/5.0 (compatible; MojeekBot/2.0; http://www.mojeek.com/bot.html)&lt;br /&gt;  0.00 | Nokia6682/2.0 (3.01.1) SymbianOS/8.0 Series60/2.6 Profile/MIDP-2.0 configuration/CLDC-1.1 UP.Link/6.3.0.0.0 (compatible;YahooSeeker/M1A1-R2D2;http://help.yahoo.com/help/us/ysearch/crawling/crawling-01.html)&lt;br /&gt;  0.00 | Crawler Mozilla/4.0( compatible; MSIE 6.0; Windows NT 5.1; SV1; Maxthon; Alexa Toolbar)&lt;br /&gt;  0.00 | Sosoimagespider+(+http://help.soso.com/soso-image-spider.htm)&lt;br /&gt;  0.00 | crawler/10.36&lt;br /&gt;  0.00 | focused_crawler (flexo; Linux x86_64; http://ivia.ucr.edu/user_agents.html)&lt;br /&gt;  0.00 | Mozilla/5.0 (compatible; NGBot/4.5)&lt;br /&gt;  0.00 | Mozilla/4.0 compatible ZyBorg/1.0 (wn-16.zyborg@looksmart.net; http://www.WISEnutbot.com)&lt;br /&gt;  0.00 | WeRelateBot/0.9 (WeRelate; http://www.werelate.org/wiki/WeRelate:Bot; dallan@werelate.org)&lt;br /&gt;  0.00 | Attentio/Nutch-0.9-dev (Attentio's beta blog crawler; www.attentio.com; info@attentio.com)&lt;br /&gt;  0.00 | VanillaZilla/0.1 libwww-perl/5.79&lt;br /&gt;  0.00 | hl_ftien_spider_v1.1&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; GPU p2p crawler http://gpu.sourceforge.net/search_engine.php)&lt;br /&gt;  0.00 | KiwiStatus (NZS.com)/0.2 (NZS.com KiwiStatus Spider,  Local Search New Zealand; http://www.nzs.com; bot-at-nzs dot com)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; DigExt; .NET CLR 1.0.3705; MSIECrawler)&lt;br /&gt;  0.00 | boitho.com-dc/0.82 ( http://www.boitho.com/dcbot.html )&lt;br /&gt;  0.00 | W3C-checklink/4.3 [4.42] libwww-perl/5.805&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MyFamilyBot/1.0; http://www.ancestry.com/learn/bot.aspx)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) (via babelfish.yahoo.com)&lt;br /&gt;  0.00 | libwww-perl/5.69&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; YPC 3.0.2; SV1; MSIECrawler)&lt;br /&gt;  0.00 | masidani_bot_v0.6(www.masidani.com) (masidani@masidani.com)&lt;br /&gt;  0.00 | Mozilla/6.0 (MSIE 6.0; Windows NT 5.1; RSSMicro.com RSS/Atom Feed Robot)&lt;br /&gt;  0.00 | SGH-Z130 SHP/VPP/R5 SMB3.1 SMM-MMS/1.1.0 profile/MIDP-2.0 configuration/CLDC-1.0 (compatible;YahooSeeker/M1A1-R2D2; http://help.yahoo.com/help/us/ysearch/crawling/crawling-01.html)&lt;br /&gt;  0.00 | QweeryBot/3.02 ( http://qweerybot.qweery.nl)&lt;br /&gt;  0.00 | TMCrawler&lt;br /&gt;  0.00 | BCNutch/Nutch-0.9 (BrightCloud crawler; http://www.brightcloud.com/crawler.asp)&lt;br /&gt;  0.00 | LapozzBot/1.5 (+http://robot.lapozz.hu)&lt;br /&gt;  0.00 | Mozilla/5.0 (compatible;MAINSEEK_BOT)&lt;br /&gt;  0.00 | Googlebot/2.X (http://www.googlebot.com/bot.html) (383; MSIE 7.0; Windows NT 5.1; InfoPath.1; .NET CLR 2.0.50727)&lt;br /&gt;  0.00 | AdSenserBot&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; MSIECrawler)&lt;br /&gt;  0.00 | yacybot (i386 Mac OS X 10.4.9; java 1.6.0-dp; Europe/de; YaCy 0.514/03593; yacy.net) http://yacy.net/yacy/bot.html&lt;br /&gt;  0.00 | Mozilla/5.0 (compatible; Exabot-Images/3.0; +http://www.exabot.com/go/robot)&lt;br /&gt;  0.00 | GoldenFeed Spider 1.0 (http://www.goldenfeed.com)&lt;br /&gt;  0.00 | Mozilla/5.0 (MrCarlito-0.1 http://www.mrcarlito.com/spider.html)&lt;br /&gt;  0.00 | NG-Search/0.9.8 (NG-SearchBot; http://www.ng-search.com)&lt;br /&gt;  0.00 | BuildCMS crawler (http://www.buildcms.com/crawler)&lt;br /&gt;  0.00 | NetWhatCrawler/0.06-dev (NetWhatCrawler from NetWhat.com; http://www.netwhat.com; support@netwhat.com)&lt;br /&gt;  0.00 | MSNBOT_Mobile Mozilla/2.0 (compatible; MSIE 4.02; Windows CE; Default)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Advanced Searchbar 3.25; MSIECrawler)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; SIMBAR={16BC191A-29AA-4259-9FB3-AB3CD3CA7170}; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1; MSIECrawler)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; HbTools 4.7.7; MSIECrawler)&lt;br /&gt;  0.00 | URL_Spider_Pro/2.5+(http://www.innerprise.net/usp-spider.asp)&lt;br /&gt;  0.00 | iaskspider/2.0(+http://iask.com/help/help_index.html)&lt;br /&gt;  0.00 | sdcresearchlabs-testbot/0.8-dev (www.shopping.com/bot.html; http://lucene.apache.org/nutch/bot.html; researchbot@shopping.com)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; FunWebProducts; SV1; MSIECrawler)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; MEGAUPLOAD 1.0; MSIECrawler)&lt;br /&gt;  0.00 | IIITBOT/1.1 (Indian Language Web Search Engine; http://webkhoj.iiit.net; pvvpr at iiit dot ac dot in)&lt;br /&gt;  0.00 | Nokia6682/2.0 (3.01.1) SymbianOS/8.0 Series60/2.6 Profile/MIDP-2.0 configuration/CLDC-1.1 UP.Link/6.3.0.0.0 (compatible;YahooSeeker/M1A1-R2D2;mobile-search-customer-care AT yahoo-inc dot com)&lt;br /&gt;  0.00 | LarbinWebCrawler (spider@download11.com)&lt;br /&gt;  0.00 | RwB's spider for atUKplc. Version 0.0.3ish&lt;br /&gt;  0.00 | Nokia6610/1.0 (3.09) Profile/MIDP-1.0 Configuration/CLDC-1.0 (compatible;YahooSeeker/M1A1-R2D2; http://help.yahoo.com/help/us/ysearch/crawling/crawling-01.html)&lt;br /&gt;  0.00 | asked/Nutch-0.8 (web crawler; http://asked.jp; epicurus at gmail dot com)&lt;br /&gt;  0.00 | libwww-perl/5.800&lt;br /&gt;  0.00 | libwww-perl/5.801&lt;br /&gt;  0.00 | SIE-SX1/05 UP.Browser/7.0.0.1.181 (GUI) MMP/2.0 Profile/MIDP-2.0 Configuration/CLDC-1.1 (compatible;YahooSeeker/M1A1-R2D2; http://help.yahoo.com/help/us/ysearch/crawling/crawling-01.html)&lt;br /&gt;  0.00 | YahooFeedSeeker/2.0 (compatible; Mozilla 4.0; MSIE 5.5; http://publisher.yahoo.com/rssguide; users 1; views 16)&lt;br /&gt;  0.00 | Seekbot/1.0 (http://www.seekbot.net/bot.html) HTTPFetcher/2.2&lt;br /&gt;  0.00 | grbot&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows 98; yie6_SBC; YPC 3.0.1; MSIECrawler)&lt;br /&gt;  0.00 | msnbot/1.1 (+http://search.msn.com/msnbot.htm)&lt;br /&gt;  0.00 | BilgiBetaBot/0.8-dev/0.8-dev (bilgi.com (Beta); http://lucene.apache.org/nutch/bot.html; nutch-agent@lucene.apache.org)&lt;br /&gt;  0.00 | BilgiBetaBot/0.8-dev (bilgi.com (Beta) ; http://lucene.apache.org/nutch/bot.html; nutch-agent@lucene.apache.org)&lt;br /&gt;  0.00 | Mozilla/5.0 (compatible; SnapPreviewBot; en-US; rv:1.8.0.9) Gecko/20061206 Firefox/1.5.0.9&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) m_pupil@yahoo.com.cn&lt;br /&gt;  0.00 | Oxford_AI_BOT_V1.0 (compatible; MSIE 6.0;)&lt;br /&gt;  0.00 | lanshanbot/1.0 (+http://search.msn.com/msnbot.htm)&lt;br /&gt;  0.00 | MQBOT/Nutch-0.9-dev (MQBOT Nutch Crawler; http://falcon.cs.uiuc.edu; mqbot@cs.uiuc.edu)&lt;br /&gt;  0.00 | MSMOBOT Mozilla/2.0 (compatible; MSIE 4.02; Windows CE; Default)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; FunWebProducts; MSIECrawler)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible;  Vagabondo/4.0; webcrawler at wise-guys dot nl; http://webagent.wise-guys.nl/; http://www.wise-guys.nl/)&lt;br /&gt;  0.00 | YodaoBot/1.0 (http://www.yodao.com/help/webmaster/spider/; )&lt;br /&gt;  0.00 | libwww-perl/5.73&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) (m_pupil@yahoo.com.cn)&lt;br /&gt;  0.00 | YahooFeedSeeker/2.0 (compatible; Mozilla 4.0; MSIE 5.5; http://publisher.yahoo.com/rssguide; users 0; views 0)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; ZangoToolbar 4.8.3; HbTools 4.8.4; MSIECrawler)&lt;br /&gt;  0.00 | Nokia6680/1.0 ((4.04.07) SymbianOS/8.0 Series60/2.6 Profile/MIDP-2.0 Configuration/CLDC-1.1 (botmobi find.mobi/bot.html) )&lt;br /&gt;  0.00 | JAC (Just Another Crawler BETA 1.0)&lt;br /&gt;  0.00 | msnbot/0.01 (+http://search.msn.com/msnbot.htm)&lt;br /&gt;  0.00 | nrsbot/5.0(loopip.com/robot.html)&lt;br /&gt;  0.00 | Spock Alpha Crawler (joseph@corp.spock.com)&lt;br /&gt;  0.00 | RSS-SPIDER (http://www.rss-spider.com/submit200709.php)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 5.0; Windows 95) VoilaBot BETA 1.2 (http://www.voila.com/)&lt;br /&gt;  0.00 | Mozilla/5.0 (compatible; Googlebot/2.1;+http://www.google.com/bot.html)&lt;br /&gt;  0.00 | GSiteCrawler/v1.12 rev. 260 (http://gsitecrawler.com/)&lt;br /&gt;  0.00 | SEO[.AG] - Search Engine Optimizer Bot [http://www.seo.ag]&lt;br /&gt;  0.00 | NutchCVS/0.06-dev (Nutch; http://www.nutch.org/docs/en/bot.html; nutch-agent@lists.sourceforge.net)&lt;br /&gt;  0.00 | Mozilla/5.0 (compatible; BecomeJPBot/2.3; MSIE 6.0 compatible; +http://www.become.co.jp/site_owner.html)&lt;br /&gt;  0.00 | NutchCVS/0.7.2 (Nutch; http://lucene.apache.org/nutch/bot.html; west@cis.poly.edu)&lt;br /&gt;  0.00 | Steeler/3.2 (http://www.tkl.iis.u-tokyo.ac.jp/~crawler/)&lt;br /&gt;  0.00 | VSynCrawler/1.0&lt;br /&gt;  0.00 | Mozilla/5.0 (superbot.com; +http://www.super.info)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; FunWebProducts; MEGAUPLOAD 1.0; MSIECrawler)&lt;br /&gt;  0.00 | Balihoo/Nutch-1.0-dev (Crawler for Balihoo.com search engine - obeys robots.txt and robots meta tags ; http://balihoo.com/index.aspx; robot at balihoo dot com)&lt;br /&gt;  0.00 | sproose/0.1 (sproose bot; http://www.sproose.com/bot.html; crawler@sproose.com)&lt;br /&gt;  0.00 | Mozilla/5.0 (compatible; Jeanie_2008_bot/3.2; +http://www.quickengines.com)&lt;br /&gt;  0.00 | Mozilla/5.0 (compatible; googlebot/2.1; +http://www.google.com/bot.html) (googlebot@google.com)&lt;br /&gt;  0.00 | genieBot (enash@genieknows.com)&lt;br /&gt;  0.00 | Mozilla/5.0 (compatible; BuiltWith/0.1; +http://builtwith.com/bot.html)&lt;br /&gt;  0.00 | FAST Enterprise Crawler 6 used by Comperio AS (sts@comperio.no)&lt;br /&gt;  0.00 | LG-C1500 UP.Browser/6.2.3 (GUI) MMP/1.0 (compatible;YahooSeeker/M1A1-R2D2; http://help.yahoo.com/help/us/ysearch/crawling/crawling-01.html)&lt;br /&gt;  0.00 | gsinfobot_1.2.0 (gary@sysadminforhire.com)&lt;br /&gt;  0.00 | PCbot/4.3&lt;br /&gt;  0.00 | Feedster Crawler/3.0; Feedster, Inc.&lt;br /&gt;  0.00 | PhpDig/1.8.8 (+http://www.phpdig.net/robot.php)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE enviable; DAUMOA/1.0.1; DAUM Web Robot; Daum Communications Corp., Korea; +http://ws.daum.net/aboutkr.html)&lt;br /&gt;  0.00 | IlseBot/1.0&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0; obot)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; MSIECrawler)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 5.01; Windows 95; MSIECrawler)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 4.0; Girafabot; girafabot at girafa dot com; http://www.girafa.com)&lt;br /&gt;  0.00 | libwww-perl/5.63&lt;br /&gt;  0.00 | googlebot 1.0&lt;br /&gt;  0.00 | MOT-V975/81.33.02I MIB/2.2.1 Profile/MIDP-2.0 Configuration/CLDC-1.1 (compatible;YahooSeeker/M1A1-R2D2;mobile-search-customer-care AT yahoo-inc dot com)&lt;br /&gt;  0.00 | Acoon-Robot v3.1.0 (http://www.acoon.de and http://www.acoon.com)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible;  Vagabondo/2.3; webcrawler at wise-guys dot nl; http://webagent.wise-guys.nl/)&lt;br /&gt;  0.00 | yacybot (i386 Linux 2.6.18-xenU; java 1.5.0_11; Etc/en) http://yacy.net/yacy/bot.html&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; FunWebProducts; .NET CLR 1.1.4322; InfoPath.2; MSIECrawler)&lt;br /&gt;  0.00 | Yoriwa/0.1 (compatible; Mozilla 4.0; MSIE 5.5; robot@yoriwa.com)&lt;br /&gt;  0.00 | pulseBot (pulse Web Miner)&lt;br /&gt;  0.00 | Spock Crawler (http://www.spock.com/crawler)&lt;br /&gt;  0.00 | CydralSpider/1.9 (Cydral Web Image Search; http://www.cydral.com)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705; MSIECrawler)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1; .NET CLR 3.0.04506.30; MSIECrawler)&lt;br /&gt;  0.00 | blackspider&lt;br /&gt;  0.00 | VadixBot_Exp&lt;br /&gt;  0.00 | SiteCrawler/1.0&lt;br /&gt;  0.00 | Giant/1.0 (Openmaru bot; robot@openmaru.com)&lt;br /&gt;  0.00 | Snapbot/1.0 (Site Search Crawler, +http://www.snap.com)&lt;br /&gt;  0.00 | Smart/Spider 2.7.1 - Mozilla/4.0&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0 compatible; Asterias Crawler v4; +http://www.singingfish.com/help/spider.html; webmaster@singingfish.com); SpiderThread  Revision: 3.11&lt;br /&gt;  0.00 | Mozilla/5.0 (compatible; BecomeBot/3.0; MSIE 6.0 compatible; +http://www.become.com/site_owners.html)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible;  Vagabondo/4.0Beta; webcrawler at wise-guys dot nl; http://webagent.wise-guys.nl/; http://www.wise-guys.nl/)&lt;br /&gt;  0.00 | BilgiBot/1.0(beta) (bilgi.com(beta); http://lucene.apache.org/nutch/bot.html; nutch-agent@lucene.apache.org)&lt;br /&gt;  0.00 | http://www.almaden.ibm.com/cs/crawler   [bc5]&lt;br /&gt;  0.00 | libwww-perl/5.50&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727; MSIECrawler)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; DigExt; MSIECrawler)&lt;br /&gt;  0.00 | DiamondBot/2.0&lt;br /&gt;  0.00 | CydralSpider/2.4 (Cydral Image Search; http://www.cydral.com)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; (R1 1.5); MSIECrawler)&lt;br /&gt;  0.00 | boitho.com-dc/0.86 ( http://www.boitho.com/dcbot.html )&lt;br /&gt;  0.00 | Nokia6680/1.0 ((4.04.07) SymbianOS/8.0 Series60/2.6 Profile/MIDP-2.0 Configuration/CLDC-1.1 (for mobile crawler) )&lt;br /&gt;  0.00 | NIF/1.1  (http://www.newsisfree.com/robot.php  users:)&lt;br /&gt;  0.00 | WWWeasel Robot v1.00 (http://wwweasel.de)&lt;br /&gt;  0.00 | GeonaBot/1.2; http://www.geona.com/&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; MSIECrawler)&lt;br /&gt;  0.00 | Mozilla/5.0 (compatible; nextthing.org/1.0; +http://www.nextthing.org/bot)&lt;br /&gt;  0.00 | disco/Nutch-0.9 (experimental crawler ... please email imagine@gmail.com if problems observed; nedrocks@gmail.com)&lt;br /&gt;  0.00 | MyApp/0.1 libwww-perl/5.805&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; InfoPath.1) (via babelfish.yahoo.com)&lt;br /&gt;  0.00 | Twiceler www.cuill.com/robots.html&lt;br /&gt;  0.00 | BrightCrawler (http://www.brightcloud.com/brightcrawler.asp)&lt;br /&gt;  0.00 | Mozilla/5.0 (compatible; AboutUsBot/0.9; +http://www.aboutus.org/AboutUsBot)&lt;br /&gt;  0.00 | BaiduImagespider+(+http://www.baidu.jp/search/s308.html)&lt;br /&gt;  0.00 | hbtronix.spider.2 -- http://hbtronix.de/spider.php&lt;br /&gt;  0.00 | gsinfobot_1.2.0 gary@sysadminforhire.com&lt;br /&gt;  0.00 | Sogou Pic Spider/3.0(+http://www.sogou.com/docs/help/webmasters.htm#07)&lt;br /&gt;  0.00 | LG-C1500 UP.Browser/6.2.3 (GUI) MMP/1.0 (compatible;YahooSeeker/M1A1-R2D2;mobile-search-customer-care AT yahoo-inc dot com)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible; MSIE enviable; DAUMOA 2.0; DAUM Web Robot; Daum Communications Corp., Korea; +http://ws.daum.net/aboutkr.html)&lt;br /&gt;  0.00 | SGH-Z130 SHP/VPP/R5 SMB3.1 SMM-MMS/1.1.0 profile/MIDP-2.0 configuration/CLDC-1.0 (compatible;YahooSeeker/M1A1-R2D2;mobile-search-customer-care AT yahoo-inc dot com)&lt;br /&gt;  0.00 | libwww-perl/5.808&lt;br /&gt;  0.00 | EasyDL/3.04  http://keywen.com/Encyclopedia/Bot&lt;br /&gt;  0.00 | RIBAECrawler&lt;br /&gt;  0.00 | Mozilla/5.0 (compatible; Yahoo! DE Slurp; http://help.yahoo.com/help/us/ysearch/slurp)&lt;br /&gt;  0.00 | woriobot (+http://www.worio.com/)&lt;br /&gt;  0.00 | KiwiStatus (NZS.com)/0.2 (NZS.com KiwiStatus Spider,  Local Search New Zealand; http://www.nzs.com; bot@nzs.com)&lt;br /&gt;  0.00 | Mozilla/5.0 (+http://www.toile.com/) ToileBot/0.1&lt;br /&gt;  0.00 | OutfoxMelonBot/0.5 (for internet experiments; http://; outfoxbot@gmail.com)&lt;br /&gt;  0.00 | Xaldon WebSpider 2.7.b6&lt;br /&gt;  0.00 | kicktooBotV1.1 (kictooBot@kictoo.com)&lt;br /&gt;  0.00 | WebCrawler_1.1 (internet@bredband.net)&lt;br /&gt;  0.00 | NutchCVS (Nutch; http://lucene.apache.org/nutch/bot.html; nutch-agent@lucene.apache.org)&lt;br /&gt;  0.00 | Mozilla/5.0 (compatible; Yahoo! Slurp/si-emb; http://help.yahoo.com/help/us/ysearch/slurp)&lt;br /&gt;  0.00 | Googlebot/2.X (+http://www.googlebot.com/bot.html)&lt;br /&gt;  0.00 | Mozilla/4.0 (compatible;  Vagabondo/4.0; webcrawler at wise-guys dot nl; http://webagent.wise-guys.nl/)&lt;br /&gt;  0.00 | Vacobot; (+http://vaco.ws/bot.html)&lt;br /&gt;  0.00 | PlantyNet_WebRobot_V1.9 babo@plantynet.com&lt;br /&gt;(492 rows)&lt;br /&gt;&lt;br /&gt;&lt;/pre&gt;&lt;br /&gt;&lt;/div&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4641852024075864603-7109415019780539726?l=web-dev-tip.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://web-dev-tip.blogspot.com/feeds/7109415019780539726/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=4641852024075864603&amp;postID=7109415019780539726' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/7109415019780539726'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/7109415019780539726'/><link rel='alternate' type='text/html' href='http://web-dev-tip.blogspot.com/2008/02/robotsbots-by-user-agent.html' title='Robots/Bots by user agent'/><author><name>Sergey</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4641852024075864603.post-1323618236731226036</id><published>2008-02-05T01:32:00.001-08:00</published><updated>2008-02-05T01:32:49.258-08:00</updated><title type='text'>Comma delimited results</title><content type='html'>In psql, you can do:&lt;br /&gt;&lt;br /&gt;regression=# select * from tenk1 limit 2;&lt;br /&gt; unique1 | unique2 | two | four | ten | twenty | hundred | thousand | twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 | string4&lt;br /&gt;---------+---------+-----+------+-----+--------+---------+----------+-------------+-----------+----------+-----+------+----------+----------+---------&lt;br /&gt;    8800 |       0 |   0 |    0 |   0 |      0 |       0 |      800 |         800 |      3800 |     8800 |   0 |    1 | MAAAAA   | AAAAAA   | AAAAxx&lt;br /&gt;    1891 |       1 |   1 |    3 |   1 |     11 |      91 |      891 |        1891 |      1891 |     1891 | 182 |  183 | TUAAAA   | BAAAAA   | HHHHxx&lt;br /&gt;(2 rows)&lt;br /&gt;&lt;br /&gt;regression=# \a&lt;br /&gt;Output format is unaligned.&lt;br /&gt;regression=# \f ,&lt;br /&gt;Field separator is ','.&lt;br /&gt;regression=# \t&lt;br /&gt;Showing only tuples.&lt;br /&gt;regression=# select * from tenk1 limit 2;&lt;br /&gt;8800,0,0,0,0,0,0,800,800,3800,8800,0,1,MAAAAA,AAAAAA,AAAAxx&lt;br /&gt;1891,1,1,3,1,11,91,891,1891,1891,1891,182,183,TUAAAA,BAAAAA,HHHHxx&lt;br /&gt;regression=#&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4641852024075864603-1323618236731226036?l=web-dev-tip.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://web-dev-tip.blogspot.com/feeds/1323618236731226036/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=4641852024075864603&amp;postID=1323618236731226036' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/1323618236731226036'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/1323618236731226036'/><link rel='alternate' type='text/html' href='http://web-dev-tip.blogspot.com/2008/02/comma-delimited-results.html' title='Comma delimited results'/><author><name>Sergey</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4641852024075864603.post-2541435797176952431</id><published>2007-09-19T04:27:00.000-07:00</published><updated>2007-09-19T04:28:29.578-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='postgresql'/><title type='text'>select only 2-level domains.</title><content type='html'>select url from d_directories_backlinks where directory_id in (select entry_id from d_directories where lang='ja') and length(split_part(replace(get_host(url),'www.',''),'.',3))=0;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4641852024075864603-2541435797176952431?l=web-dev-tip.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://web-dev-tip.blogspot.com/feeds/2541435797176952431/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=4641852024075864603&amp;postID=2541435797176952431' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/2541435797176952431'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/2541435797176952431'/><link rel='alternate' type='text/html' href='http://web-dev-tip.blogspot.com/2007/09/select-only-2-level-domains.html' title='select only 2-level domains.'/><author><name>Sergey</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4641852024075864603.post-3896205134212218204</id><published>2007-09-06T02:04:00.000-07:00</published><updated>2007-09-06T02:22:54.015-07:00</updated><title type='text'>network monitoring tools</title><content type='html'>http://nethogs.sourceforge.net/&lt;br /&gt;&lt;br /&gt;Just found these great tools. the nethogs allows to measure the b/w by process id that is really helpful.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4641852024075864603-3896205134212218204?l=web-dev-tip.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://web-dev-tip.blogspot.com/feeds/3896205134212218204/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=4641852024075864603&amp;postID=3896205134212218204' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/3896205134212218204'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/3896205134212218204'/><link rel='alternate' type='text/html' href='http://web-dev-tip.blogspot.com/2007/09/network-monitoring-tools.html' title='network monitoring tools'/><author><name>Sergey</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4641852024075864603.post-5145955622771632022</id><published>2007-07-08T02:19:00.000-07:00</published><updated>2008-12-09T06:54:30.877-08:00</updated><title type='text'>Best Putin's photo</title><content type='html'>&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://3.bp.blogspot.com/_Scp56Mr2l-0/RpCsRkhaf3I/AAAAAAAAAAc/r8UoGU1kSv0/s1600-h/putin_photo.jpeg"&gt;&lt;img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;" src="http://3.bp.blogspot.com/_Scp56Mr2l-0/RpCsRkhaf3I/AAAAAAAAAAc/r8UoGU1kSv0/s320/putin_photo.jpeg" border="0" alt=""id="BLOGGER_PHOTO_ID_5084753397162868594" /&gt;&lt;/a&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4641852024075864603-5145955622771632022?l=web-dev-tip.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://web-dev-tip.blogspot.com/feeds/5145955622771632022/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=4641852024075864603&amp;postID=5145955622771632022' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/5145955622771632022'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/5145955622771632022'/><link rel='alternate' type='text/html' href='http://web-dev-tip.blogspot.com/2007/07/blog-post.html' title='Best Putin&apos;s photo'/><author><name>Sergey</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://3.bp.blogspot.com/_Scp56Mr2l-0/RpCsRkhaf3I/AAAAAAAAAAc/r8UoGU1kSv0/s72-c/putin_photo.jpeg' height='72' width='72'/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4641852024075864603.post-8274535409207011814</id><published>2007-05-29T11:39:00.000-07:00</published><updated>2007-05-29T11:45:11.050-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='linux'/><category scheme='http://www.blogger.com/atom/ns#' term='kubuntu'/><title type='text'>make fonts to be smooth in kubuntu linux</title><content type='html'>emacs /home/user/.fonts.conf&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;&amp;lt;?xml version="1.0″ ?&amp;gt;&lt;br&gt;&lt;br /&gt;&amp;lt;!DOCTYPE fontconfig SYSTEM "fonts.dtd"&amp;gt;&lt;br&gt;&lt;br /&gt;&amp;lt;fontconfig&amp;gt;&lt;br&gt;&lt;br /&gt;&amp;lt;match target="font"&amp;gt;&lt;br&gt;&lt;br /&gt;&amp;lt;edit name="autohint" mode="assign"&amp;gt;&lt;br&gt;&lt;br /&gt;&amp;lt;bool&amp;gt;true&amp;lt;/bool&amp;gt;&lt;br&gt;&lt;br /&gt;&amp;lt;/edit&amp;gt;&lt;br&gt;&lt;br /&gt;&lt;br /&gt;&amp;lt;/match&amp;gt;&lt;br&gt;&lt;br /&gt;&amp;lt;/fontconfig&amp;gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4641852024075864603-8274535409207011814?l=web-dev-tip.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://web-dev-tip.blogspot.com/feeds/8274535409207011814/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=4641852024075864603&amp;postID=8274535409207011814' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/8274535409207011814'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/8274535409207011814'/><link rel='alternate' type='text/html' href='http://web-dev-tip.blogspot.com/2007/05/make-fonts-to-be-smooth-in-kubuntu.html' title='make fonts to be smooth in kubuntu linux'/><author><name>Sergey</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4641852024075864603.post-2240467222594742240</id><published>2007-05-16T11:57:00.000-07:00</published><updated>2007-05-16T11:58:48.230-07:00</updated><title type='text'>View user defined function in postgresql</title><content type='html'>Once you have written your function you may view its definition in pg_proc. EG&lt;br /&gt;&lt;br /&gt;&lt;pre&gt;select * from pg_proc where proname='myFunction';&lt;/pre&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4641852024075864603-2240467222594742240?l=web-dev-tip.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://web-dev-tip.blogspot.com/feeds/2240467222594742240/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=4641852024075864603&amp;postID=2240467222594742240' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/2240467222594742240'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/2240467222594742240'/><link rel='alternate' type='text/html' href='http://web-dev-tip.blogspot.com/2007/05/view-user-defined-function-in.html' title='View user defined function in postgresql'/><author><name>Sergey</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4641852024075864603.post-5765943666338704725</id><published>2007-03-23T08:44:00.000-07:00</published><updated>2007-03-23T08:47:26.564-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='sql'/><category scheme='http://www.blogger.com/atom/ns#' term='mysql'/><category scheme='http://www.blogger.com/atom/ns#' term='scv'/><title type='text'>restore mysql database table from Microsoft file</title><content type='html'>load data infile '/var/www/_system_/htdocs/sites.csv' into table sites fields terminated by ';' ENCLOSED by '"' LINES TERMINATED BY '\r\n' STARTING BY '';&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4641852024075864603-5765943666338704725?l=web-dev-tip.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://web-dev-tip.blogspot.com/feeds/5765943666338704725/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=4641852024075864603&amp;postID=5765943666338704725' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/5765943666338704725'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/5765943666338704725'/><link rel='alternate' type='text/html' href='http://web-dev-tip.blogspot.com/2007/03/restore-mysql-database-table-from.html' title='restore mysql database table from Microsoft file'/><author><name>Sergey</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4641852024075864603.post-4322771821277452407</id><published>2007-03-22T00:44:00.000-07:00</published><updated>2007-03-22T00:52:05.780-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='sql'/><category scheme='http://www.blogger.com/atom/ns#' term='pg_autovacuum'/><category scheme='http://www.blogger.com/atom/ns#' term='system'/><category scheme='http://www.blogger.com/atom/ns#' term='postgresql'/><title type='text'>pg_autovacuum usage</title><content type='html'>this is how i use autovacuum.&lt;br /&gt;pg_autovacuum -v 3 -V 0.001 -a 2 -A 0.01 -U user password -d 3 -s 100&lt;br /&gt;&lt;br /&gt;usage: pg_autovacuum&lt;br /&gt;   [-D] Daemonize (Detach from tty and run in the background)&lt;br /&gt;   [-d] debug (debug level=0,1,2,3; default=0)&lt;br /&gt;   [-s] sleep base value (default=300)&lt;br /&gt;   [-S] sleep scaling factor (default=2.000000)&lt;br /&gt;   [-v] vacuum base threshold (default=1000)&lt;br /&gt;   [-V] vacuum scaling factor (default=2.000000)&lt;br /&gt;   [-a] analyze base threshold (default=500)&lt;br /&gt;   [-A] analyze scaling factor (default=1.000000)&lt;br /&gt;   [-L] logfile (default=none)&lt;br /&gt;   [-c] vacuum_cost_delay (default=none)&lt;br /&gt;   [-C] vacuum_cost_page_hit (default=none)&lt;br /&gt;   [-m] vacuum_cost_page_miss (default=none)&lt;br /&gt;   [-n] vacuum_cost_page_dirty (default=none)&lt;br /&gt;   [-l] vacuum_cost_limit (default=none)&lt;br /&gt;   [-U] username (libpq default)&lt;br /&gt;   [-P] password (libpq default)&lt;br /&gt;   [-H] host (libpq default)&lt;br /&gt;   [-p] port (libpq default)&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4641852024075864603-4322771821277452407?l=web-dev-tip.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://web-dev-tip.blogspot.com/feeds/4322771821277452407/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=4641852024075864603&amp;postID=4322771821277452407' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/4322771821277452407'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/4322771821277452407'/><link rel='alternate' type='text/html' href='http://web-dev-tip.blogspot.com/2007/03/pgautovacuum-usage.html' title='pg_autovacuum usage'/><author><name>Sergey</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4641852024075864603.post-5698691699032497483</id><published>2007-03-17T09:19:00.000-07:00</published><updated>2007-03-17T09:28:18.788-07:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='linux'/><category scheme='http://www.blogger.com/atom/ns#' term='ssh'/><category scheme='http://www.blogger.com/atom/ns#' term='tunnelling'/><category scheme='http://www.blogger.com/atom/ns#' term='system'/><title type='text'>http(s) over ssh tunnelling</title><content type='html'>if machine A stands in DMZ(before the firewall) and B is part of the corporate network (behind the firewall),&lt;br /&gt;on the machine A :&lt;br /&gt;# ssh -gNL 33333:B:443 root@B&lt;br /&gt;for example:&lt;br /&gt;# ssh -gNL 33333:192.168.1.119:443 root@192.168.1.119&lt;br /&gt;-g - Allows remote hosts to connect to local forwarded ports.&lt;br /&gt;this will cause https://A:33333/ to work just like https://B:33333/ but from outside the network.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4641852024075864603-5698691699032497483?l=web-dev-tip.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://web-dev-tip.blogspot.com/feeds/5698691699032497483/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=4641852024075864603&amp;postID=5698691699032497483' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/5698691699032497483'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/5698691699032497483'/><link rel='alternate' type='text/html' href='http://web-dev-tip.blogspot.com/2007/03/https-over-ssh-tunnelling.html' title='http(s) over ssh tunnelling'/><author><name>Sergey</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4641852024075864603.post-3147246224452202297</id><published>2007-02-12T01:32:00.000-08:00</published><updated>2007-02-08T15:09:54.509-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='accents'/><category scheme='http://www.blogger.com/atom/ns#' term='postgresql'/><title type='text'>remove accents from strings using postgresql</title><content type='html'>function remove_accents(&amp;$str)&lt;br /&gt;{&lt;br /&gt;  return svq("select convert(TO_ASCII(convert('".pg_escape_string($str)."','UNICODE','LATIN 1'),'LATIN 1'),'LATIN 1','UNICODE');");&lt;br /&gt;}&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4641852024075864603-3147246224452202297?l=web-dev-tip.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://web-dev-tip.blogspot.com/feeds/3147246224452202297/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=4641852024075864603&amp;postID=3147246224452202297' title='6 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/3147246224452202297'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/3147246224452202297'/><link rel='alternate' type='text/html' href='http://web-dev-tip.blogspot.com/2007/02/remove-accents-from-strings-using.html' title='remove accents from strings using postgresql'/><author><name>Sergey</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>6</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4641852024075864603.post-1228931411149098429</id><published>2007-02-08T15:08:00.000-08:00</published><updated>2007-02-08T14:48:04.438-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='lighttpd'/><category scheme='http://www.blogger.com/atom/ns#' term='system'/><title type='text'>lighttpd canonical hosts (non-www to www redirect)</title><content type='html'>This will redirect http://domin.com to http://www.domain.com/ with 301 code&lt;br /&gt;&lt;br /&gt;$HTTP["host"] == "domain.com" {&lt;br /&gt;url.redirect = ( "^/(.*)" =&gt; "http://www.domain.com/$1" )&lt;br /&gt;}&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4641852024075864603-1228931411149098429?l=web-dev-tip.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://web-dev-tip.blogspot.com/feeds/1228931411149098429/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=4641852024075864603&amp;postID=1228931411149098429' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/1228931411149098429'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/1228931411149098429'/><link rel='alternate' type='text/html' href='http://web-dev-tip.blogspot.com/2007/02/lighttpd-canonical-hosts-non-www-to-www.html' title='lighttpd canonical hosts (non-www to www redirect)'/><author><name>Sergey</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4641852024075864603.post-82006052897987363</id><published>2007-02-08T14:45:00.000-08:00</published><updated>2007-02-02T01:59:51.771-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='server'/><category scheme='http://www.blogger.com/atom/ns#' term='ftp'/><category scheme='http://www.blogger.com/atom/ns#' term='linux'/><category scheme='http://www.blogger.com/atom/ns#' term='system'/><category scheme='http://www.blogger.com/atom/ns#' term='pure-ftp'/><category scheme='http://www.blogger.com/atom/ns#' term='postgresql'/><title type='text'>pure ftp with postgres</title><content type='html'>in the conf file words User, Password, Dir must be enclosed in "" coz its special words&lt;br /&gt;&lt;br /&gt;starting:&lt;br /&gt;pure-ftpd-postgresql -l pgsql:/etc/pure-ftpd/db/postgresql.conf  -A &amp;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4641852024075864603-82006052897987363?l=web-dev-tip.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://web-dev-tip.blogspot.com/feeds/82006052897987363/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=4641852024075864603&amp;postID=82006052897987363' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/82006052897987363'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/82006052897987363'/><link rel='alternate' type='text/html' href='http://web-dev-tip.blogspot.com/2007/02/pure-ftp-with-postgres.html' title='pure ftp with postgres'/><author><name>Sergey</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4641852024075864603.post-5942642290954347979</id><published>2007-02-02T01:17:00.000-08:00</published><updated>2007-02-02T01:59:51.800-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='linux'/><category scheme='http://www.blogger.com/atom/ns#' term='debian'/><category scheme='http://www.blogger.com/atom/ns#' term='emacs'/><category scheme='http://www.blogger.com/atom/ns#' term='system'/><title type='text'>install emacs on debian</title><content type='html'>aptitude install emacs-common&lt;br /&gt;aptitude install emacs21&lt;br /&gt;&lt;br /&gt;search for module to emable php-mode:&lt;br /&gt;apt-cache search emacs | grep php&lt;br /&gt;php-elisp - Emacs support for php files&lt;br /&gt;&lt;br /&gt;apt-get install php-elisp&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4641852024075864603-5942642290954347979?l=web-dev-tip.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://web-dev-tip.blogspot.com/feeds/5942642290954347979/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=4641852024075864603&amp;postID=5942642290954347979' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/5942642290954347979'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/5942642290954347979'/><link rel='alternate' type='text/html' href='http://web-dev-tip.blogspot.com/2007/02/install-emacs-on-debian.html' title='install emacs on debian'/><author><name>Sergey</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4641852024075864603.post-7763257361413871477</id><published>2007-02-02T01:07:00.000-08:00</published><updated>2007-02-02T01:10:26.017-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='linux'/><category scheme='http://www.blogger.com/atom/ns#' term='debian'/><category scheme='http://www.blogger.com/atom/ns#' term='system'/><title type='text'>W: There are no public key available for the following key IDs</title><content type='html'>If you just ran apt-get update and you got:&lt;br /&gt;&lt;br /&gt;There are no public key available for the following key IDs:&lt;br /&gt;A70DAF536070D3A1&lt;br /&gt;&lt;br /&gt;then type:&lt;br /&gt;&lt;br /&gt;sudo gpg --recv-key --keyserver wwwkeys.eu.pgp.net A70DAF536070D3A1 &lt;br /&gt;sudo gpg --export A70DAF536070D3A1 | apt-key add - &lt;br /&gt;&lt;br /&gt;and all will be well.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4641852024075864603-7763257361413871477?l=web-dev-tip.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://web-dev-tip.blogspot.com/feeds/7763257361413871477/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=4641852024075864603&amp;postID=7763257361413871477' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/7763257361413871477'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/7763257361413871477'/><link rel='alternate' type='text/html' href='http://web-dev-tip.blogspot.com/2007/02/w-there-are-no-public-key-available-for.html' title='W: There are no public key available for the following key IDs'/><author><name>Sergey</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4641852024075864603.post-3811061568917231974</id><published>2007-01-31T11:27:00.000-08:00</published><updated>2008-12-09T06:54:31.140-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='arabs'/><title type='text'>Arabs</title><content type='html'>&lt;a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://2.bp.blogspot.com/_Scp56Mr2l-0/RcDuUhgBgLI/AAAAAAAAAAM/hogo3waIqDY/s1600-h/arabs.jpg"&gt;&lt;img style="float:left; margin:0 10px 10px 0;cursor:pointer; cursor:hand;" src="http://2.bp.blogspot.com/_Scp56Mr2l-0/RcDuUhgBgLI/AAAAAAAAAAM/hogo3waIqDY/s320/arabs.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5026279220502954162" /&gt;&lt;/a&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4641852024075864603-3811061568917231974?l=web-dev-tip.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://web-dev-tip.blogspot.com/feeds/3811061568917231974/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=4641852024075864603&amp;postID=3811061568917231974' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/3811061568917231974'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/3811061568917231974'/><link rel='alternate' type='text/html' href='http://web-dev-tip.blogspot.com/2007/01/arabs.html' title='Arabs'/><author><name>Sergey</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media='http://search.yahoo.com/mrss/' url='http://2.bp.blogspot.com/_Scp56Mr2l-0/RcDuUhgBgLI/AAAAAAAAAAM/hogo3waIqDY/s72-c/arabs.jpg' height='72' width='72'/><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4641852024075864603.post-4321190476229564535</id><published>2007-01-31T11:06:00.000-08:00</published><updated>2007-01-31T12:27:51.972-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='video'/><category scheme='http://www.blogger.com/atom/ns#' term='fun'/><category scheme='http://www.blogger.com/atom/ns#' term='russian'/><title type='text'>Пальцы</title><content type='html'>&lt;object width="425" height="350"&gt;&lt;param name="movie" value="http://www.youtube.com/v/j7LITSn8onU"&gt;&lt;/param&gt;&lt;param name="wmode" value="transparent"&gt;&lt;/param&gt;&lt;embed src="http://www.youtube.com/v/j7LITSn8onU" type="application/x-shockwave-flash" wmode="transparent" width="425" height="350"&gt;&lt;/embed&gt;&lt;/object&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4641852024075864603-4321190476229564535?l=web-dev-tip.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://web-dev-tip.blogspot.com/feeds/4321190476229564535/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=4641852024075864603&amp;postID=4321190476229564535' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/4321190476229564535'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/4321190476229564535'/><link rel='alternate' type='text/html' href='http://web-dev-tip.blogspot.com/2007/01/blog-post.html' title='Пальцы'/><author><name>Sergey</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4641852024075864603.post-8907235797017674385</id><published>2007-01-31T02:36:00.000-08:00</published><updated>2007-01-31T12:31:24.334-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='php'/><category scheme='http://www.blogger.com/atom/ns#' term='monitoring'/><category scheme='http://www.blogger.com/atom/ns#' term='system'/><title type='text'>simple php process monitor</title><content type='html'>&lt;code&gt;&lt;br /&gt;&lt;br /&gt;require_once("declare.php");&lt;br /&gt;define("RUNFILEDIR",PREFIX."/runfiles");&lt;br /&gt;function setrunfile()&lt;br /&gt;{&lt;br /&gt;  $fp = fopen(RUNFILEDIR."/".getmypid(),"w");&lt;br /&gt;  fwrite($fp,time());&lt;br /&gt;  fclose($fp);&lt;br /&gt;}&lt;br /&gt;function delrunfile($PID=0)&lt;br /&gt;{&lt;br /&gt;  if(!$PID)    $PID = getmypid();&lt;br /&gt;  unlink(RUNFILEDIR."/$PID");&lt;br /&gt;}&lt;br /&gt;&lt;br /&gt;function kill($PID)&lt;br /&gt;{&lt;br /&gt;  delrunfile($PID);&lt;br /&gt;  exec("kill -KILL $PID");&lt;br /&gt;}&lt;br /&gt;&lt;br /&gt;function monitor($maxruntime=999999)&lt;br /&gt;{&lt;br /&gt;  foreach(getfiles(RUNFILEDIR) as $f)&lt;br /&gt;    if($ts=file_get_contents($f))&lt;br /&gt;      {&lt;br /&gt;        $etime = time()-$ts;&lt;br /&gt;        $PID = preg_replace("#.*\/#","",$f);&lt;br /&gt;        info("$PID - $etime");&lt;br /&gt;        if($etime&gt;$maxruntime)&lt;br /&gt;          kill($PID);&lt;br /&gt;      }&lt;br /&gt;&lt;br /&gt;}&lt;br /&gt;monitor();&lt;br /&gt;&lt;/code&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4641852024075864603-8907235797017674385?l=web-dev-tip.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://web-dev-tip.blogspot.com/feeds/8907235797017674385/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=4641852024075864603&amp;postID=8907235797017674385' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/8907235797017674385'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/8907235797017674385'/><link rel='alternate' type='text/html' href='http://web-dev-tip.blogspot.com/2007/01/simple-php-process-monitor.html' title='simple php process monitor'/><author><name>Sergey</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4641852024075864603.post-5689386978757051496</id><published>2007-01-31T01:07:00.000-08:00</published><updated>2007-01-31T12:31:27.379-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='php'/><category scheme='http://www.blogger.com/atom/ns#' term='system'/><title type='text'>php get process id</title><content type='html'>getmypid -- Gets PHP's process ID&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4641852024075864603-5689386978757051496?l=web-dev-tip.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://web-dev-tip.blogspot.com/feeds/5689386978757051496/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=4641852024075864603&amp;postID=5689386978757051496' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/5689386978757051496'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/5689386978757051496'/><link rel='alternate' type='text/html' href='http://web-dev-tip.blogspot.com/2007/01/php-get-process-id.html' title='php get process id'/><author><name>Sergey</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-4641852024075864603.post-5064328701314741496</id><published>2007-01-28T11:37:00.000-08:00</published><updated>2007-01-31T12:29:26.353-08:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='network'/><category scheme='http://www.blogger.com/atom/ns#' term='linux'/><category scheme='http://www.blogger.com/atom/ns#' term='php'/><category scheme='http://www.blogger.com/atom/ns#' term='system'/><category scheme='http://www.blogger.com/atom/ns#' term='errors'/><title type='text'>Temporary failure in name resolution</title><content type='html'>php_network_getaddresses: getaddrinfo failed: Temporary failure in name resolution&lt;br /&gt;&lt;br /&gt;Error: The system could not resolve domain name to ip address.&lt;br /&gt;&lt;br /&gt;Solution:&lt;br /&gt;get nameserver ip addreses from the internet provider&lt;br /&gt;open /etc/resolv.conf and add:&lt;br /&gt;&lt;br /&gt;nameserver &lt;i&gt;first ip&lt;/i&gt;&lt;br /&gt;nameserver &lt;i&gt;second ip&lt;/i&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/4641852024075864603-5064328701314741496?l=web-dev-tip.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://web-dev-tip.blogspot.com/feeds/5064328701314741496/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment.g?blogID=4641852024075864603&amp;postID=5064328701314741496' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/5064328701314741496'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/4641852024075864603/posts/default/5064328701314741496'/><link rel='alternate' type='text/html' href='http://web-dev-tip.blogspot.com/2007/01/temporary-failure-in-name-resolution.html' title='Temporary failure in name resolution'/><author><name>Sergey</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry></feed>
