On 1/24/06, Rob Kinyon <[EMAIL PROTECTED]> wrote: > I may be able to help with this. Luckily, if you stick with Oracle > 9.2+, it can use the standard JOIN syntax.
Hm, is that reasonable? What is the most popular version of Oracle these days? > Oracle doesn't have a LIMIT syntax, though it can be simulated using ROWID. How about offset? > 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. Well, post it all to the list :) > 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. :-) Trouble is, by the time I documented it, it'd be changed again. The idea is to flesh out all this stuff by supporting lots of different databases. Once I think most bases are covered, then I'll try to coalesce it all into a sane public API. But while it's private, it's likely to change frequently and dramatically. For example, depending on what Oracle needs for auto-increment primary key support, all of the existing private code that does that may have to be overhauled (again :) Oh, and I almost forgot about auto-init. That area is pretty much self-contained. I don't know what DBD::Oracle's introspection capabilities are like, but let's hope the Oracle auto-init looks more like the Pg auto-init: http://search.cpan.org/src/JSIRACUSA/Rose-DB-Object-0.64/lib/Rose/DB/Object/Metadata/Auto/Pg.pm and less like the dreaded Informix auto-init: http://search.cpan.org/src/JSIRACUSA/Rose-DB-Object-0.64/lib/Rose/DB/Object/Metadata/Auto/Informix.pm Plus, don't forget about all the tests! RDBO explicitly tests against each supported database. There are tons and tons of tests to be written... Anyway, like I said, baby steps. Start by implementing the Rose::DB public API in a new Rose::DB::Oracle module. While that's happening, it'd be great iif someone could post the various Oracle-isms discussed above to the list and I'll start considering what RDBO needs to do to support them. -John ------------------------------------------------------- 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
