aqua data studio - sql queries, import data
iSQLViewer - good potential but seems to have bugs with import/export
XML etc.
eclipse - of course, the java IDE
mail - thunderbird
browser - of course, firefox
henplus - command line query tool like sqlplus but a real gem
realplayer - audio stimulation
kate - text editor of choice
knowit - notes in a hirearchical structure
kdissert - just looked at it now but worth a mention looks so promising
html editing - open for suggestions - nothing yet
vmware - run windows on linux - can we really be productive without windows?
Anyone got any other good apps they use that help productivity?