On 1/24/06, John Siracusa <[EMAIL PROTECTED]> wrote: > On 1/24/06 2:29 AM, Ron Savage wrote: > > What is the state? > > Is there any unshipped Oracle code available to be worked on? > > Is it a matter of converting *::Pg.pm, say, to *::Oracle.pm, for starters? > > > > At the moment I have a great deal of time available to do the typing, if the > > answer to the previous question is Yes, and even a little bit of > > enthusiasm... > > And yes, I have access to Oracle. > > As far as I know, no one has started work on Oracle support. I have no > access to Oracle or I'd be doing it. If you want to give it a shot, I can > help guide you through it. The first step is to add Oracle support to > Rose::DB. That is, to create Rose::DB::Oracle implementing all of the > public APIs of Rose::DB. > > Then the fun begins :) There are many undocumented/private APIs in Rose::DB > that Rose::DB::Object relies upon that will need to be implemented, plus > probably a few more new ones that will need to be added just for Oracle. > The primary key and serial column stuff will probably also be a problem. > Finally, there's the dreaded Manager which knows nothing of Oracle's > potentially odd syntax for doing JOIN and LIMIT queries.
I may be able to help with this. Luckily, if you stick with Oracle 9.2+, it can use the standard JOIN syntax. Oracle doesn't have a LIMIT syntax, though it can be simulated using ROWID. Auto-incrementing is also wonky in Oracle - you have to manually create a sequence and do some random locking stuff in order to do it right. I either have or can easily get all this information. John - It might be useful to document the undocumented stuff in Rose::DB that RDBO depends on in some "How to extend RDBO"-type document. At least so that you have it documented for yourself. :-) Rob ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid3432&bid#0486&dat1642 _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
