Andrew Channels Dexter Pinion

Wherein I write some stuff that you may like to read. Or not, its up to you really.

March 28, 2006

Python and Oracle

Congratulations to Catherine Devlin for her recent using Python with Oracle article at OTN. Keep up the good work.

I'd like to add that you don't need to running Windows or Red Hat either. You can install Oracle XE on Debian or Ubuntu and then compile cx_Oracle from source quite easily.

Just make sure that you've installed the appropriate development packages (gcc and build-essential). Then unpack the cx_Oracle source package, cd into the directory it creates and type;

$ sudo python install

It works like a dream for me and now I've got a development machine with Oracle, MySQL, SQLite and PostgreSQL all running on it. Which gives me plenty of scope for experimenting with cross platform code and comparing and contrasting features of the various databases. Hopefully there will be more on this subject here in the not too distant future.

Update: but wait, there's more. Thanks to Frits Hoogland I discover that Oracle have a Debian repository. I can add this to my /etc/apt/sources.list and keep my database sparkly and up to date. Marvelous.

Posted by Andy Todd at March 28, 2006 02:33 PM