[SQLObject] Re: Oracle

[Dirk E. <Dir...@Ce...>]

Hi,

Mark Mueller asked about the Oracle version of SQLObject a few days ago.

The state of affair's is:
I moved to a new job (university).
I do not use Oracle here.
I have not set up any DB related stuff here yet.

John Dell'Aquila and myself have a both ported SQLObject to Oracle.
Our (untested) first versions where very similar. That's a good sign. :-)
The only real issue with SQLObject and Oracle is the slice notation
part where you retrieve rows at specific table index positions.
Some DBs have LIMIT and OFFSET keywords for this. Oracle has no notion
of this. John wrote a kludge version using rownum to retrieve all rows
up to the highest index (LIMIT + OFFSET + 1) and then remove the indices
smaller than the lowest index (OFFSET) on the python side of things.

The version I have somewhere in a tarball is against SQLObject 0.4x.
I would be happy to give you a copy. Maybe I'll install Oracle
here for test purposes some day. But I can't make any promises...

Andy Todd said that he would be happy to test any versions we come
up with.

John are you still reading this list?

Regards,
Dirk

-- 
 Dirk J. Evers                      dir...@ce...
 NRW Graduate School in                             +49 (0)521/106-3793
 Bioinformatics and Genome Research, CeBiTec - Center for Biotechnology
 University of Bielefeld,                    D-33594 Bielefeld, Germany