Oracle support?

[Robert Hicks]

On the Django site it lists the currently implemented databases and say
"more to come soon".

Is Oracle on that list? And relatively speaking, how "soon" is soon?

Robert

[Jason Huggins]

I wrote the Oracle patch and it's working fairly well for me at the
moment, you can download and apply it from the ticket tracker now*, if
you're feeling adventurous.

I've recently been granted commit access to the "magic removal" branch
in development for the express purpose of merging in my patch and
getting it released "soon". So the quick answer to your question of
'how "soon" is soon' is:

Oracle support will hopefully** come when the magic removal branch (aka
"Django 0.92") is released. (I'm not a core Django dev, but I think
they're planning on weeks, not months for the eventual release of 0.92)

And with that said, when Oracle support does ship, it'll be *new*. So
even though it'll be unit-tested, it won't have a huge base of "road
testing" (other than my experience with it). So don't go build
lifesaving Django-on-Oracle emergency medical equipment with it just
yet. ;-)

-Jason

*
http://code.djangoproject.com/attachment/ticket/87/oracle_patch_as_of_rev_2074.patch

** Assuming I find the time in the next days/week to merge the patch
and resolve any potential issues with it before the "magic removal"
branch gets merged with trunk and released.

[Jamison Roberts]

Which Oracle is it being tested against?  I don't suppose it matters since the API used is "lowest common denominator" in general.  I plan on using Oracle 10g XE as soon as they take it out of beta.  Best deal out there if you ask me.

[Jason Huggins]

I wrote the patch using Oracle 9.2.0.1.0 on Windows XP and Python
2.4.1. I'm hoping to set up a dev server (or at least VMPlayer image)
that will test the patch against Windows and Red Hat versions of Oracle
10g.

I highly doubt there are version specific differences in the patch
between 9i and 10g, but I'm wise enough to know that I should expect
the unexpected. :-)

-Jason

[Robert Hicks]

IBM just released a lite free version of DB2 that has been specs than
the Oracle version. I would use the Oracle version though because that
is what I use at work.

Robert

[Jamison Roberts]

Well if the free DB2 acts like the OS-390 version, then I want no part of it.  Unfortunately I have to deal with mainframe Db2 for my job, and it's no fun at all.  There is nothing easy to use about it.  One of our data warehouses has several Oracle 9iR2, and they are much easier to deal with.

[Robert Hicks]

Jamison Roberts wrote:
> Well if the free DB2 acts like the OS-390 version, then I want no part
> of it. Unfortunately I have to deal with mainframe Db2 for my job, and
> it's no fun at all. There is nothing easy to use about it. One of our
> data warehouses has several Oracle 9iR2, and they are much easier to
> deal with.
>

I have no experience with DB2, so I will take your word for it. We are
an Oracle shop ourselves which is why I am chomping at the bit for
Oracle support to be added into Django proper.

I wish I was farther along in my Python to help it along.

As it goes, my choice will be whether Django, TurboGears w/SQLObject, or
Mygthy with SQLAlchemy gets Oracle support out the door first.

Robert