2007年8月27日 星期一

一個有用的網站 (for DBA/Administrator)


有提到不錯的管理資料, 值得參考, 閱讀.


Monitoring and Tracing Unix Processes

by Jeff Hunter, Sr. Database Administrator


This article is intended for use by any Unix/DBA Administrator who needs to monitor trace information from a UNIX process. For a more detailed look at the "truss" command using Sun Solaris, check out: (Using the "truss" command in Solaris)

How to Trace Unix System Calls for a Process

The following platforms support a trace utility that can be used to identify what a process is doing:

O/S Version Trace Utility
Sun Solaris 2.x, Unixware 7.0
truss, e.g.:

Unixware 7.0
$ truss -aefo

$ truss -rall -wall -p
HP/UX 11
tusc, e.g.:
$ tusc -afpo
sctrace, e.g.:
$ sctrace -Amo
strace, e.g.:
$ strace -fo
$ strace -p
par, e.g.:
$ par -siSSo
Compaq Tru64 Unix
trace, e.g.:
$ trace -fo
Sequent Dynix/PTX
truss, e.g.:
$ truss -aefo

2007年8月26日 星期日

The 40 coolest free applications around

The 40 coolest free applications around
[ 23-08-2007 ]

Everyone loves free software (open source or otherwise) and this list demonstrates quite how many excellent applications can be had for free. If you thought you needed to buy something - maybe check this list first.

The aim of this list is to compile the greatest free and open source applications currently available; I spend many many hours online each day (through the nature of my work) so it's worth writing down some of the things I find for the benefit of those who are fortunate to have better things to do.

Image Editing and Graphics

The GNU Image Manipulation Program is a Photoshop replacement that doesn’t have "quite" as much functionality but it’s excellent for free. It comes installed by default on many Linux distros and is also available in Windows. Worth a look.

Paint.net - http://www.getpaint.net/index2.html
A really good, lightweight alternative to Photoshop. It offers layers, unlimited undo, special effects and a wide variety of useful tools. The download is around 2mb too so absolutely worth a look – I use this when Photoshop is playing up.

ImageMagick - http://www.imagemagick.org/script/index.php
A lesser known application but it offers the ability to "create, edit, and compose bitmap images. It can read, convert and write images in a variety of formats (about 100)". Use it to "translate, flip, mirror, rotate, scale, shear and transform images, adjust image colors, apply various special effects, or draw text, lines, polygons, ellipses and Bézier curves."

Blender - http://www.blender.org/download/get-blender/
A 3D Studio Max alternative, very comprehensive and full-featured.


It’s basically Microsoft Office so you need little else with this installed. It has MS Office support (in both reading and writing) so this fantastic suite is fully compatible.

Google Documents - http://docs.google.com/
Google documents is a free service that simply requires registration in order to use it. You create Microsoft-Office-esq documents in an online environment and they store them on their servers. You can export them and save the files to your hard drive too. In addition, Google allows multiple user collaboration which means numerous people can all be working on the same document at the same time and it will update in real time. Very cool stuff.

Web and web development

Andrew Sellick covered this in his comprehensive list Top 15 free and open source web developer tools so this part of the list is mostly his (he's a friend so this content use was agreed).

Firefox - http://www.mozilla-europe.org/en/products/firefox/
Firefox is arguably the second most popular browser available (sitting behind Internet Explorer 6). It's extendable, customisable, secure and massively popular. You can develop plugins for it, other people develop plugins for it - it's just worth having.

Kuler - http://kuler.adobe.com/
A very powerful colour-picking tool, allowing for the easy creation of colour schemes.

Aptana - http://www.aptana.com/
The Aptana IDE is a free, open-source, cross-platform, JavaScript-focused development environment for building Ajax applications. It features code assist on JavaScript, HTML, and CSS languages, FTP/SFTP support and a JavaScript debugger to troubleshoot your code.

Color Cop - http://www.colorcop.net/
A very handy tool for capturing colours anywhere on your screen. Color Cop makes it quick and easy in those situations where you need to know what colour is being used.

Firefox web developer toolbar - https://addons.mozilla.org/en-US/firefox/addon/60
The Web Developer extension adds a menu and a toolbar to the browser with various web developer tools. It is designed for Firefox, Flock, Mozilla and Seamonkey, and will run on any platform that these browsers support including Windows, Mac OS X and Linux.

Internet Explorer Toolbar - [another long url]
The Microsoft Internet Explorer Developer Toolbar provides a variety of tools for quickly creating, understanding, and troubleshooting Web pages. This version is a preview release and behavior may change in the final release.

Firebug - http://www.getfirebug.com/
Firebug integrates with Firefox to put a wealth of web development tools at your fingertips while you browse. You can edit, debug, and monitor CSS, HTML, and JavaScript live in any web page.

Watchfire WebXACT - http://webxact.watchfire.com/
WebXACT is a free online service that lets you test single pages of web content for quality, accessibility, and privacy issues. It is very similar to Bobby and usefull to anyone wishing to check the accessibilty level of their templates/site.

JsUnit - http://www.jsunit.net/
JsUnit is a Unit Testing framework for client-side (in-browser) JavaScript. It is essentially a port of JUnit to JavaScript. Also included is a platform for automating the execution of tests on multiple browsers and mutiple machines running different OSs.

Xenu - http://home.snafu.de/tilman/xenulink.html
Xenu’s Link Sleuth (TM) checks Web sites for broken links. Link verification is done on "normal" links, images, frames, plug-ins, backgrounds, local image maps, style sheets, scripts and java applets. It displays a continously updated list of URLs which you can sort by different criteria. A report can be produced at any time.

Vischeck - http://www.vischeck.com/vischeck/vischeckURL.php
Vischeck is a way of showing you what things look like to someone who is color blind. You can try Vischeck online- either run Vischeck on your own image files or run Vischeck on a web page. You can also download programs to let you run it on your own computer.

Feng GUI - http://www.feng-gui.com/
Find out how people View your website or image and which areas are getting most of the attention. The ViewFinder Heatmap service, is an artificial intelligence service which simulates human visual attention and creates an attention heatmap.

Fiddler - http://www.fiddlertool.com/fiddler/
Fiddler is a HTTP Debugging Proxy which logs all HTTP traffic between your computer and the Internet. Fiddler allows you to inspect all HTTP Traffic, set breakpoints, and "fiddle" with incoming or outgoing data. Fiddler includes a powerful event-based scripting subsystem, and can be extended using any .NET language.

browsershots.org - http://browsershots.org/
Browsershots.org is a free open-source online service providing screenshots of your web site in a multitude of different browsers. It is not as advanced as BrowserCam but a fantastic tool none the less.

Expresso 2.1 - http://www.ultrapico.com/Expresso.htm
Expresso is useful tool for learning how to use regular expressions and for developing and debugging regular expressions prior to incorporating them into your code. It provides a very cut down version of RegexBuddy but most importantly it is simple to use and free.

ColorJack - [very long url]
ColorJack is an amazing online application providing users with the ability to match colours that work well together. Perfect for those developers who struggle to get a good colour scheme together.

Development Applications (IDE's)

Eclipse - http://www.eclipse.org/
Eclipse is an open source community whose projects are focused on building an open development platform comprised of extensible frameworks, tools and runtimes for building, deploying and managing software across the lifecycle. It’s quite hardcore in my personal opinion so certainly not one for beginners.

NetBeans - http://www.netbeans.org/
All the tools software developers need to create cross-platform Java desktop, enterprise and web applications. Runs on Windows, Linux, MacOS, as well as Solaris. I never got on well with NetBeans but it is a good application, just not one I choose.

Code::Blocks - http://www.codeblocks.org/
A free c++ IDE built to meet the “most demanding needs of its users”.

SharpDevelop - http://www.sharpdevelop.net/OpenSource/SD/Default.aspx
A free IDE for C#, VB.net and Boo projects on Microsoft’s .NET platform.

Operating Systems

Ubuntu - http://www.ubuntu.com
The most popular Linux distro at the moment - offering astonishing performance, usability and support (from a massive online community) all for free.

PCLinuxOS - http://www.pclinuxos.com/
One of my favourite Linux releases; PCLinuxOS is very different to Ubuntu but powerful and usable in equal measures. I find it a lot more intuitive but purely though personal preference. It too is supported by a healthy community.

Fedora - http://fedoraproject.org/
I'm not a Fedora user but there are an awful lot of them. Fedora was the daddy long before Ubuntu appeared on the scene and therefore it inherits a lot of excellent features from how long these guys have been doing it. Excellent software, strong communities and worth a look. This is Linux too incase you didn't know.

openSUSE - http://www.opensuse.org/
Quoted as being one of the more fully featured, usable editions of Linux - openSUSE has a lot of users and is one of the major players in the scene today.

Lots more Linux! - Distrowatch has info on lots more
Linux is free and it is becoming a viable alternative to Windows these days; here is Distrowatch - a site that links to reviews on each release as well as offering a brief description, background and links.

Video Playback

Media Player Classic - [long url]
Amazingly lightweight and incredibly durable - MPC succeeds where most others fail. It really will play anything and doesn’t even need installing.

VLC Media Player - http://www.videolan.org/vlc/
A very popular application; a highly portable multimedia player for various audio and video formats. It will play just about anything too.

Youtube - http://www.youtube.com
Youtube is maybe an odd choice to put into the video playback area but bare with me. You can upload your videos to Youtube quite happily for free and there are hundreds upon thousands of hours of footage on there. From the illegal to the completely random Youtube has more video playback options than your wildest dreams.


Audacity - http://audacity.sourceforge.net/
Audacity is free, open source software for recording and editing sounds. It is available for Mac OS X, Microsoft Windows, GNU/Linux, and other operating systems.

While not open source, it is free and very good indeed. Far better than iTunes in my personal opinion.


AVG - http://free.grisoft.com/doc/1
A popular and comprehensive, free anti-virus application. I use it. Simple.

Avast! Home edition - http://www.avast.com/eng/avast_4_home.html
Also quite popular and available for free.


FreeCiv http://www.freeciv.org/index.php/Freeciv
A free development of the popular Civilisation games created by Sid Meier.

FreeCol - http://www.freecol.org/
Exactly the same but for Colonisation.

Also here is a massive list of open source games for Windows that's absolutely worth checking out.

No doubt I've missed dozens and dozens of applications (and categories too) so please drop your thoughts into a comment and I'll make a revised list. If this list is useful to one person then it's been worthwhile - I just fear that there are countless people who don't appreciate the scale of choice they have with free software.

Showing most recent 20 of 24 comments [View all comments]
Lookout - now hard to get outlook addin.

Once there used 2B a small firm who was sooo successful in creating a small and slick outlook search add-on, that needed .net and was so good, that Microsoft bought it out, and digested it into MSN desktop,,

It can still be found somewhere, not anymore in Microsoft realm.

I have not checked it on a 2007 system, neither vista.

write boaz_yah@yahoo.com should you like a 1.3M zip sent over by mail

I do not monitor this account daily so please do not expect 24/7 service.
by Boaz

by zzzzzzz

Another to add to your list:


Freeware realistic cataloging software for DVDs and Books. Works with the webcam to scan in your items via barcode too.
by hubber

Instead of Winamp you could try foobar2k (http://www.foobar2000.org)
by xyr

Asterisk (www.asterisk.org) -- what office can operate without a phone system -- and Asterisk enables you to turn an inexpensive server into an IP PBX that rival proprietary phones systems costs tens of thousands of dollars (or more).
by www.netVOICE.ca

Vmware Player!
by lucid

"...bare with me"? You sure you wanted to say that?
by Pedant

what, no joomla?
by E

There is a list of free/open source software that I’ve paid for:

Popular programs omitted from your list: abiword, gnumeric, latex (and various tools), vim, filezilla, gnucash, putty, thunderbird, vim, vnc, inkscape
by F/OSS

How about clonezilla ?
Especially clonezilla live

Clonezilla is a partition or disk cloning tool similar to Symantec Ghost. It saves and restores only blocks in use on the hard drive if the file system is supported. For unsupported file systems, dd is used instead. It has been used to clone a 5 GB system to 40 clients in about 10 minutes.
by clone

Nice list!

My vote for some that are already mentioned:
mplayer, clamwin, and 7-zip (all excellent and all open-source)

And one more named "Geany" for the IDE category:

by Jeff

Opera version 9.23 Build 8808 is a great web browser. It’s an alternative to IE.

IObit Advanced Windows Care Personal and IObit Smart Defrag are great freewares.

TweakVI Basic is a great tweaker and optimizer for Windows Vista.
by Southern Cross

LogMeIn (www.logmein.com) - remote access - there is a free version for both PCs and Macs
by Maisy

I discovered Scribus a while back as well, but really can’t get used to it. I’m sure it has its merits. One might be able to some work with it after using it for a while. Currently, I just gave up however.
by Nils

Azureus, Amarok, Pidgin 2.10, Gimp 2.4, Picasa, NetBeans 5.5.1, Thunderbird, jEdit 4.3pre10.
by xlinuks

I have in my Blog a list of free apps, you can check it:


this is the post, as you can see some of yours are in my list, and you can enter for the links:

1- VLC* and Gom for playing all media ( it doesn’t play real media ).

2- for malware protection Antivir* (it has one of the best detection rate for last months but it doesn’t protect from spyware), Active Virus Shield ( it use Kasersky engine, umm you can call it Kaspersky lite), Avast and Clamwin.( somehow I don’t like AVG )

3- Windows Defender*, Spyware Terminator, Spybot and Arovax AntiSpyware* for anti spyware.

4- Comodo and Ashampoo for Firewall protection.

5- Paint.NET*, Artweaver for photo editing and designing.

6- OpenOffice* for Office and spreadsheets work.

7- Firefox* and Opera as stand alone browsers for surfing Net (I like Firefox more and it’s the default Browser).

8- Notepad++* notepad replacement and for PHP editing

9- Deep Burner* and CDBurnerXp for Burning CDs and DVDs

10- Google Desktop* for desktop search.

11- “7-Zip“* to open and make Zip, 7z and Rar and other type of archives ( 7-zip doesn’t make rar files and only open it ).

12- Thunderbird is an Email Clint like Outlook.

13- Utorrent* and Azureus for downloading Torrent files.

13- Orbit ,Fashget* and Freedownloadmanager as download managers that supports resumable downloads and multiple simultaneous downloads.

14- Any Video Converter Free, Media Converter SA Edition, Prism Video Converter and MediaCoder* as a video and audio converting tool between among different audio/video formats.

15- Amaya as a Web editor.

16- Limewire, FrostWire and Phex* as P2P client based on the Gnutella network.

I know this is a post :), but it’s a list.
by Murtadh

Add these to your list

- Scribus, Desktop publishing
- Inkscape, vector drawing
- mplayer, video player
- Amarok, audio player and music collection manager
- emacs, text editor
- rdesktop, remote desktop for windows
- gentoo, linux distribution
by David

I recommend Knoppix as a cool, useful operating and set of system recovery tools. It can save your bacon.

by wayn3w

Great list, may I also recommend cd burner xp may not be open source but its free, feature rich with excellent attention payed to gui and usability

openly yours
antonio vertigo
by tony

You might want to consider Scribus the Desk Top Publishing program. Originally developed for Linux, and included or a click away on many Linux distros, Scribus is also now available for Windows XP.

by davecs

2007年8月24日 星期五

video tag in SVG

今天看到一個令人興奮的網頁, 有人替 firefox 3 寫了一個補丁, 可以提供 video tag.
如果再和 SVG 一起使用, 就可以將 video object 旋轉, 再整合 javascript, 那就真是太炫了.



HTML 5的草稿

patched build

2007年8月22日 星期三

PostgreSQL 的測試 - 3

繼續之前的測試, 這次多了 pc200 (是一台 Dell 的機器)


2.6.9-34.EL 2.6.9-34 .ELsmp 2.6.9-34 .ELsmp2.6.9-42.0 .10.ELsmp2.6.20-rc6 #1 SMP2.6.20-rc6 #1 SMP2.6.9-42.0 .10.ELsmp
CPU Intel(R) Pentium(R) 4 CPU 2.80GHz
512 KB Cache (5605.85)
Genuine Intel(R) CPU T2400 @ 1.83GHz
2048 KB Cache (1998.36)
Intel(R) Core(TM)2 CPU 6600 @ 2.40GHz
4096 KB Cache (4819.82)
Intel(R) Xeon(R) CPU 5140 @ 2.33GHz
4096 KB Cache (4657.86)
(DualCore x2)
(22:39:05 - 04:11:41)
(16:33:14 - 19:01:25)
(15:11:55 - 17:20:51)
(17:47:33 - 20:17:48)
(22:40:28 - 03:01:13)

1:24:22 (09:42:26 - 11:06:42)
(noatime/ atime, noprint)
(noatime, nohexdump)

average dur./call
min dur. /1000call
max dur. /1000call

mean /1000call
std devi. /1000call

可以發現, 即使是使用了 4GB 的 ram, 只可以改善 std. dev.
據此可以推論, 會出現 比較大的執行時間, 應該是 os 的 buffer layer 的影響.

另外, noatime 這個 mount 選項並沒有多少改善. (反而延長了時間)

若是讓 rad.py 不列印任何資訊的話(noprint), 可以改善整個測試的時間. 而且是很可觀的.
noprint 表示將程式內的 InfoPrint() 全部 註解 掉. 這除了 不 call time.time() 外, 也不 call hexDump().
若只是讓 rad.py 不執行 hexDump 的話(直接 return 空字串), 可以節省(與noatime比) 40%左右.

2007年8月10日 星期五

flash 的網站

因緣際會看到 一個 flash 的相關 blog, 還不錯, 記下來.




這兩天仔細閱讀了 PJSIP-Dev-Guide.pdf, 真是獲益良多.
document 的結構非常清楚 表達了一個 SIP protocol stack 架構.
並且闡明如何利用 一些簡單的規則 來撰寫程式.
分層負責/管理 的方式, 除了容易理解程式, 也更好使用.

2007年8月1日 星期三


a blog introduce geexbox - http://www.linux.com/feature/118210
offical website of geexbox: http://geexbox.org/en/index.html
offical website of icecast - http://www.icecast.org/ and http://dir.xiph.org/index.php

turn a pc into media center pc.

study this for further LI.

moc - Music On Console

a blog for moc - http://polishlinux.org/apps/cli/moc-audio-player-advanced-tricks/

official web site of moc - http://moc.daper.net/

a command-line music player. worth to give it a try.