OS X Software for Oracle Developers

06/27/2012 in Community using tags macos , oracle , utilities

One of the great things about working for Enkitec is that it’s a very Mac-friendly shop. When I arrived there in 2007 there were a handful of us running Macs and the attitude at the top seemed to be respectful, but skeptical. They allowed me to use my own laptop, which at the time was a 15-inch Intel Core2 Duo Macbook Pro, with the understanding that I could request a standard-issue Dell laptop at any time should the need arise. It never did. Since that time a large number of my coworkers have made the switch, abandoning their bulky, slow Dell Latitude laptops for 13-inch Macbook Pros, as have both owners of the company.

I’ve been a Mac user since 1998, since the advent of the original bondi blue iMac, a machine that I greatly loved, as far as you can love a machine (and no farther!). I’ve used a Mac at work since about the year 2000, a good while before OS X really hit the mainstream. Back in those days about the only thing I could hope to accomplish on it at the office was email, iTunes, looking up something on the internet, and running an SSH session or two. Still, I faithfully carried my little white plastic iBook G3 to work every day just because I enjoyed using the damn thing so much. I looked for any opportunity at all to integrate it into whatever I was doing at work. Over the years that came to include more and more stuff. I still remember how excited I was the day Oracle Applications earned Gold Certification on OS 9! Woohoo! I desperately needed a life.

The advent and acceptance of OS X changed everything. The Unix underpinnings gave legitimacy to the Mac as a serious “office” platform. I went from using my laptop as a toy to using it as a companion system, then a few years later as my primary system, then finally as my only system. Likewise, the number of Windows applications I needed to run on a daily basis, even in VMWare, was reduced from several to none. Hallelujah. In the same timeframe I also went from being the “office mac weirdo” to one of several “elite mac-using jackasses”, to just another one of the guys. Or so they tell me to my face.

One of the questions I’m asked most often by coworkers switching to the Mac is what software they should download first. This is my list.

[Note: I provide links to the developer’s sites, but many of these apps are available in the App Store.]

Crucial Stuff

These are the tools any Mac user, but particularly those working in IT, should have in their arsenal.

* Butler
The one and only truly critical app in this list, Butler is an application launcher, search tool, universal bookmark manager, iTunes remote controller, Applescript launcher, keyboard macro tool, pasteboard manager and more. It puts the contents of your Mac at your fingertips and I couldn’t imagine using a computer without it. Indispensable.

Update: Since I wrote this article I’ve made the switch to Alfred for accomplishing essentially the same tasks. I was a longtime Butler user and supporter, even while more popular apps like Quicksilver came and went(?), but it has become evident that Butler is no longer being actively developed, while Alfred continues to add significant new functionality, like the enhanced scripting capabilities in version 2.0. There is currently a sizable community of people developing sophisticated workflows for Alfred, but the most compelling feature is the integration with 1Password (see below) that allows you to open and log in to your password protected web sites using a keyboard shortcut. My only complaint is that I preferred the iTunes automation in Butler (also found in Alfred, but works differently), but I imagine Butler’s conceits could be mimicked by using a custom workflow in Alfred.

Universal password manager, syncs with iPad and iPhone version. Use it to store the hundreds of passwords you accumulate both personally and on the job. A plugin for Safari, Chrome, and Firefox handles automatic entry of password credentials on websites you visit.

MS Office
Or at least just Word and Excel. Never use Powerpoint. See below. It’s true that there are plenty of alternatives these days like OpenOffice, LibreOffice, Google Docs, etc., but unless everybody in your workplace has standardized on those tools, you’re bound to run across conversion issues that can sometimes be a serious nuisance.

Yes, I recommend both office suites, as Pages is vastly superior to Word as a composition tool and Keynote simply demolishes Powerpoint for presentations. Faster, lighter, easier to use — the whole iWork suite is worth it just for Keynote. Companion apps for iPad and iPhone are cheap and automatically sync your documents. Personally I use always use Keynote for creating presentations and working with Powerpoint slideshows, I use Pages whenever I can, and I use Numbers when I want to create a visually sharp chart/spreadsheet combo for presentations that I won’t be handing off to other people to modify.

Growl Perhaps soon to be obsoleted by the new Notification Center feature of OS X Mountain Lion, Growl provides a heads-up display for various things happening on the Mac. I use it mostly for email notifications, but the feedback it provides when attaching an external device or connecting to a network is often helpful.

Update: Dead in the water. Absorbed into notifications in Mountain Lion.

A good text editor goes a very long way, as any coder can tell you. Some people organize their whole lives with text files, though. Emacs is also available, but it doesn’t have the Mac sensibilities of this storied old tool. If you’d rather not spend the money, TextWrangler is the free, stripped-down counterpart.

Solves the problem of how to catalog, archive, and make available the vast library of information you accumulate over the years. Companion apps for iPad and iPhone put all your information at your fingertips. Can also be used as a collaborative tool for teams.

Software for the Oracle Developer

SQL Developer
Oracle’s free tool for SQL and PL/SQL development.

NetBeans and/or JDeveloper
For J2EE development. Netbeans is the better tool, IMO, unless you need to work with Oracle ADF.

I’ve used VMWare Fusion for years and recently tried VirtualBox to take advantage of Oracle’s developer VMs, and have been impressed with the performance and configurability. Beat’s VMWare’s price, as well.

Oracle 10g Instant Client
Can’t beat the convenience of being able to connect to a database without having to boot a VM.

For remote desktop (RDP) connections. Traditionally, it’s been a better, more reliable option than Microsoft’s Remote Desktop app

Citrix Receiver
Needed If your company publishes corporate apps with Citrix Webapps, and many do.

Performance analysis/debugging tool for Java apps.

Apache Directory Studio
A useful and fully-featured LDAP tool.

Packet sniffer.

My tools of choice for easy source code manaagement.

Download and compile Unix software.

Kindle /Send to Kindle
Take advantage of Kindle’s massive collection of technical ebooks. The ‘Send to Kindle’ tool allows you to upload your own PDFs for reading in the Kindle app.

Read man pages in a browser window.

Productivity Apps

GTD task/life management tool. Companion apps for iPhone, iPad keep everything in sync and support location-based notes.

Also might have chosen Pixelmator, but this is the one I own. Almost everybody could use a good image editor at some time or other. Pixelmator is supposed to be closer to Photoshop.

Screenshot markup tool. Integrates with Evernote.

For Sharing and Collaboration

Disk space in the cloud with sharing and privacy features. Integrates with many applications on Mac, iPhone, iPad.

More secure alternative to Dropbox for sensitive files.

Another secure cloud-based storage option.

A brain dead easy way to send secure, encrypted email attachments!

Video phone for talking to your PC-using buddies. For your Mac brothers you should use Facetime.

Google Hangouts
I have some anecdotal evidence that this may be a more stable video conferencing solution than Skype. I’ll update as I gain more experience using the two.

Free screen sharing software, if you don’t have access to GoToMeeting.

System Tools

Lightweight system monitor that sits in the menu bar. Measures CPU, memory, network, and disk usage.

Creates bootable, up-to-date copies of your entire hard drive! Great, possibly indispensable, for recovering from a hard disk failure. Can also be used just to sync disk contents. Only copies changed data during file sync. Very efficient.

Defrag utility. You shouldn’t need to do it ever in OS X, but I’m hoping it prolongs the life of my hard drive. Anybody got any real statistics on that? By the way don’t try this on an SSD drive! It’ll decrease the life of the drive.

Disk Utility does pretty much everything this app does, except for allowing you to partition a disk without data loss. Unfortunately, this will not work if the disk is too full or badly fragmented. That’s when iDefrag really comes in handy.

GUI tool for executing Unix commands. Comes with a large library of useful commands, including many Mac-specific ones. Can be used as a learning tool and you can add your own scripts.

OmniDiskSweeper and/or GrandPerspective
Analyze the contents and sizes of the stuff on your hard drive. GrandPerspective provides a better visualization, but you don’t always need the “fluff”.

Internet Tools

FTP/SFTP tool with numerous useful features. Download an entire website or keep remote sites in sync with local folders. Transmit is also popular.

The web browser. (I use Webkit.)

The web browser. (See above.)

See what’s coming down the pipe in Safari.

BitTorrent client.

Open source media player. Plays a wide variety of formats.

If You Have The Money…

Create, edit, sign, mark up, footnote, redact, and otherwise manipulate PDFs. Also does OCR and tables of contents. Very nice tool. Companion app for iPad.

Like Visio, only a thousand times better. The Omni Group’s flagship product. Wish very much I owned this one.

Does to MS Project what Keynote does to Powerpoint. Bought my copy a few versions back when it was far less expensive, and it still has all the project tracking features I need.

Obscure Use Cases

MailServe for Lion
Automates configuration of OS X’s built in Postfix mail server. I’ve had to use this in the past when I was unable to connect to the corporate email server and didn’t want to send files through Gmail. (Did I mention I despise most web mail clients?)

TNEF’s Enough
Used it once to extract the Word document embedded in a winmail.dat attachment from MS Outlook.

PST Bridge
Used convert or read PST files (basically mail archives) generated by MS Outlook.

Just for Fun

Invert your screen colors to reduce strain on the eyes at night, or to conserve battery power. Neat effect.

Audio Overload
Pass the time by listening to music from the console video games of long ago. Video game music files found separately, somewhere out there on the internet.

That’s it for now. Hope you find something useful.

comments powered by Disqus