Electronics & Programming

develissimo

Open Source electronics development and programming

  • You are not logged in.
  • Root
  • » Django
  • » When will there be a Oracle Backend? [RSS Feed]

#1 Nov. 16, 2005 12:58:19

[EMAIL P.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

When will there be a Oracle Backend?


Hi,

i saw a Ticket for that, when will it be implemented in Django? :)

Offline

#2 Nov. 16, 2005 13:04:43

P.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

When will there be a Oracle Backend?


Hi,

i saw a Ticket about an Oracle Backend. When will it be implemented in
Django? :)

Offline

#3 Nov. 16, 2005 13:05:08

P.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

When will there be a Oracle Backend?


Hi,

i saw a Ticket about an Oracle Backend. When will it be implemented in
Django? :)

Offline

#4 Nov. 16, 2005 14:28:00

Jacob K.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

When will there be a Oracle Backend?


On Nov 16, 2005, at 7:04 AM, Pash wrote:i saw a Ticket about an Oracle Backend. When will it be implemented in
Django? :)IIRC there are a few pretty major differences between Oracle andother RDBMSes that are preventing a Oracle backend from being"easy". I'll reinstall Oracle and take another look at the patch;would you be up for testing a (possibly buggy) backend if I could getone out?Jacob

Offline

#5 Nov. 16, 2005 19:07:08

David S.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

When will there be a Oracle Backend?


Jacob Kaplan-Moss <jacob <at> jacobian.org> writes:

> would you be up for testing a (possibly buggy) backend if I could get
> one out?

I would like to volunteer as well. Are there unit tests or is that part of
volunteering?

Also, I am curious what the differences are and if versions matter.

Offline

#6 Nov. 16, 2005 20:27:13

Jacob K.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

When will there be a Oracle Backend?


On Nov 16, 2005, at 12:58 PM, David S. wrote:Jacob Kaplan-Moss <jacob <at> jacobian.org> writes:would you be up for testing a (possibly buggy) backend if I could get
one out?I would like to volunteer as well. Are there unit tests or is thatpart ofvolunteering?There are inteed unit tests of the db backends; last time I checkedthey didn't pass with Oracle.Also, I am curious what the differences are and if versions matter.Off the top of my head, the big difference I can think of is thatOracle doesn't support LIMIT/OFFSET on queries (you're supposed touse a cursor or a temp table). This in and of itself causes issuesfor Django, and I'm 99% sure there are other differences of thistype. I'm going to mess around with it when I get a spare moment andtry to get something at least partially working; I'll make anannouncement when there's something worth trying.Jacob

Offline

#7 Nov. 16, 2005 21:00:00

Jeremy D.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

When will there be a Oracle Backend?


On 11/16/05, Jacob Kaplan-Moss <> wrote:
> Off the top of my head, the big difference I can think of is that
> Oracle doesn't support LIMIT/OFFSET on queries (you're supposed to

This doesn't suck:http://e-docs.bea.com/workshop/docs81/doc/en/core/index.html

Offline

#8 Nov. 16, 2005 21:10:28

Jeremy D.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

When will there be a Oracle Backend?


On 11/16/05, Jeremy Dunck <> wrote:
> On 11/16/05, Jacob Kaplan-Moss <> wrote:
> > Off the top of my head, the big difference I can think of is that
> > Oracle doesn't support LIMIT/OFFSET on queries (you're supposed to
>
> This doesn't suck:
>http://e-docs.bea.com/workshop/docs81/doc/en/core/index.html>

>From there:

select x from foo limit 10 offset 20
becomes:
select * from (
select x from foo
) where rownum between 20 and 30

.. modulo fencepost errors...

Offline

#9 Nov. 16, 2005 21:21:58

M.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

When will there be a Oracle Backend?


Jacob Kaplan-Moss wrote:Off the top of my head, the big difference I can think of is thatOracle doesn't support LIMIT/OFFSET on queries (you're supposed touse a cursor or a temp table).Oracle has 'rownum' - a virtual field representing the ordinal number ofa row. So you can do this:SELECT id, name FROM table where rownum<=5;This in and of itself causes issues for Django, and I'm 99% surethere are other differences of this type.My experience is that Oracle mostly differs by features not present inother systems, not the contrary :-)

Offline

#10 Nov. 16, 2005 21:28:25

Jacob K.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

When will there be a Oracle Backend?


On Nov 16, 2005, at 3:10 PM, Jeremy Dunck wrote:select x from foo limit 10 offset 20
becomes:
select * from (
select x from foo
) where rownum between 20 and 30Right; the issue is that query rewriting is... scary; making thebackend rewrite your queries for you sucessfully could be difficult(FYI, I think this specific problem is already worked out in thepatch; I meant it more by way of an example).Jacob

Offline

  • Root
  • » Django
  • » When will there be a Oracle Backend? [RSS Feed]

Board footer

Moderator control

Enjoy the 22nd of April
PoweredBy

The Forums are managed by develissimo stuff members, if you find any issues or misplaced content please help us to fix it. Thank you! Tell us via Contact Options
Leave a Message
Welcome to Develissimo Live Support