Business Machine

Technology, business
and innovation.

And, not least, about
the Mac.

Weblog Archive Cutedge

by: Bernard Teo

Creative Commons License

Copyright © 2003-2012
Bernard Teo
Some Rights Reserved.

The Ultimate Business Machine - Archives

List of Categories : Database * Technology * Commentary * Singapore * Travel *

Wed 10 Dec 2003


Category : Technology/oracle.txt

We've got Oracle 9 running on Panther on a Titanium. It's a milestone of sorts. I can't stop looking at it, doing simple things like "desc act_accounts" or "select * from act_accounts where acctcode = 'so-and-so';". It sounds inane but you've got to appreciate how far we've come since we've got OS X.

I remember about five years ago when Apple moved from OS 8 to 9 and Oracle moved from Oracle 7 to 8. Everything to do with Oracle on the Mac stopped working. I remember pleading with friends at Oracle Singapore for drivers that will work, but they've already lost interest in the Mac. If not for the Internet, and someone on the other side of the world who discovered one particular combination that worked, we would have had to give up working on the Mac.

Even that would have been lost, had our customer moved on to Oracle 9. But, fortunately, these were people who had no interest in giving any cent more to Oracle than they need.

Until today, I've actually kept one PowerBook 3400, running OS 9, just to be able to do Oracle-related work. Now, this can be retired. (Our kid's going to have his own PowerBook, just like Daddy and Mommy.)

There's an advantage to running Oracle on a Unix server. You can simply ssh to it and do database administration. On Windows, we had to install those fat SQLNet drivers on every client machine. You can't just drag and drop the drivers and associated programs like SQLPlus. It's a non-trivial installation, so you'll be able to justify the IT headcount. On the Mac now, we just ssh to the server and "borrow" the SQLPLus running on it. Client applications access the server via a very "thin" JDBC driver. We don't need to mess up all our other Macs with SQLNet stuff.

Oracle's still got the edge in terms of the "expressiveness" of their SQL dialect. But, if we want to keep our code portable, we'll have the restrict ourselves to the 80% of the SQL expressions that will work across all the other platforms we want to run on. From this point of view, MySQL has almost caught up with Oracle. If I were Oracle, I would be seriously worried. It's hard to compete with "free".

So, now, I can show Java on OS X accessing Oracle on OS X in the forthcoming Xcode seminar. Of course, you still have all the other permutations, including Java and Oracle on PCs and Unix and Linux. Haven't you heard? Customers want choice. And it's choice they will get.

Posted at 5:28AM UTC | permalink

Put your Mac to Work Now how would you do something like that?

Weblogs. Download and start a weblog of your own.

A Mac Business Toolbox
A survey of the possibilities

A Business Scenario
How we could use Macs in businesses

VPN Enabler for Mavericks

MailServe for Mavericks

DNS Enabler for Mavericks

DNS Agent for Mavericks

WebMon for Mavericks

Luca for Mavericks

Liya for Mountain Lion & Mavericks

Postfix Enabler for Tiger and Panther

Sendmail Enabler for Jaguar

Services running on this server, a Mac Mini running Mac OS X 10.9.2 Mavericks:

  • Apache 2 Web Server
  • Postfix Mail Server
  • Dovecot IMAP Server
  • Fetchmail
  • SpamBayes Spam Filter
  • Procmail
  • BIND DNS Server
  • DNS Agent
  • WebDAV Server
  • VPN Server
  • PHP-based weblog
  • MySQL database
  • PostgreSQL database

all set up using MailServe, WebMon, DNS Enabler, DNS Agent, VPN Enabler, Liya and our SQL installers, all on Mavericks.