ORM suggestions needed for Oracle

[llama]

I'm writing modules which will eventually parse data from files and
insert data into Oracle .
As this is fairly large amount of inserts/updates and less of one-to-
many relationships, I'm inclined
towards using an ORM tool in Perl.

I tried Class::DBI, DBIx::Class and Rose::DB::Object.

while reading through the documentation for Rose::DB::Oracle, I came
across the below note

Note: This class is a work in progress. Support for Oracle databases
is not yet complete.

I'd like to get suggestions on choosing the ORM for my project. As the
support for Oracle is not complete
should I continue developing using Rose::DB::Object or do you suggest
me to look at DBIx::Class

Also I'd like to know what features are missing in Rose::DB::Oracle,
for now can I use inserts/updates/deletes and relationships >

Ultimately all the parses will go to Production, So I want to choose
the right ORM at the start of the project and yes I'm also looking at
good performance.

Thanks in advance for your time

[John Siracusa]

On Tue, Aug 4, 2009 at 9:15 AM, llama<shob...@gmail.com> wrote:
> while reading through the documentation for Rose::DB::Oracle, I came across
> the below note
>
> Note: This class is a work in progress. Support for Oracle databases is not
> yet complete.

I'm pretty sure that bit of documentation is out of date. I can't
think of any features that haven't yet been implemented in Oracle.
Can anyone else? I'll remove that documentation unless someone tells
me otherwise.

> Ultimately all the parses will go to Production, So I want to choose
> the right ORM at the start of the project and yes I'm also looking at
> good performance.

I have ready access to Oracle (version 11g) these days so if you run
across any Oracle-related bugs, I should be able to fix them quickly.

-John

[karpet]

On Aug 4, 8:15 am, llama <shobh...@gmail.com> wrote:

> I'd like to get suggestions on choosing the ORM for my project. As the
> support for Oracle is not complete
> should I continue developing using Rose::DB::Object or do you suggest
> me to look at DBIx::Class

fwiw, I've been using RDBO with Oracle at $work for the last month or
so with no issues.

IME, if you tend toward RDBO anyway, John is *very* responsive to bugs
and/or feature requests and it would be a safe bet to go with RDBO.

[Randal L. Schwartz]

>>>>> "karpet" == karpet <pek...@gmail.com> writes:

karpet> IME, if you tend toward RDBO anyway, John is *very* responsive to bugs
karpet> and/or feature requests and it would be a safe bet to go with RDBO.

Seconded. John has always been very responsive on the mailing list and IRC
channel, and continues to push new releases frequently.

--
Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<mer...@stonehenge.com> <URL:http://www.stonehenge.com/merlyn/>
Smalltalk/Perl/Unix consulting, Technical writing, Comedy, etc. etc.
See http://methodsandmessages.vox.com/ for Smalltalk and Seaside discussion

[llama]

First of all let me thank John, Randal and Karpet for your imputs.
After reading your comments I have decided to use RDBO in my project.
I created my initial script and it works wonderfully. :)


-Shobhan

[Kevin McGrath]

llama wrote:
> Also I'd like to know what features are missing in Rose::DB::Oracle,
> for now can I use inserts/updates/deletes and relationships

Oracle 10g supports regular expressions much like RLIKE for mysql. The
syntax is a bit different and I don't think it's supported yet.

SELECT testcol
FROM test
WHERE REGEXP_LIKE(testcol, '^..a.');

Other than that I've been using RDBO with Oracle since 2007 and have been very, very happy with it. John and the rest of the members who provide support on this mailing list are one of the big reasons I continue to use RDBO.

-Kevin