chanakya has asked for the wisdom of the Perl Monks concerning the following question:

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 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

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

Replies are listed 'Best First'.
Re: ORM suggestions needed
by perrin (Chancellor) on Aug 03, 2009 at 17:17 UTC
    I think you should ask the author what his idea of "not yet complete" is. Many things on CPAN that are used constantly for critical work have disclaimers like that, or 0.001 version numbers. People are definitely using Rose::DB::Object.
[reply]
Re: ORM suggestions needed
by metaperl (Curate) on Aug 03, 2009 at 16:51 UTC
    I'm experimenting with DBIx::DataModel.

    I just played around with the Quickstart and am now moving on to the reference docs.

    Certainly DBIx::Class has the largest and most active community of developers.

    You could also look at Fey::ORM but I find it a bit cumbersome. Well written and based on years of experience with his prior project Alzabo but nonetheless too much work and too little convenience.

    Finally, you might help complete whatever Oracle support is lacking in Rose::DB::Object.

[reply]
Re: ORM suggestions needed
by chanakya (Friar) on Aug 04, 2009 at 11:54 UTC
    Thanks for your comments.
    I was searching Perlmonks and came across an interesting
    link between CBIC and DBIC http://www.perlmonks.org/?node_id=572567.

    Based on the discussion looks like DBIC is better. I also need to check the level of Oracle support from Rose::DB::Object.

    Thanks every one
[reply]
[reply]
      you mean CDBI, not CBIC :)
[reply]

Back to Seekers of Perl Wisdom