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

Hi monks, I have been looking for a wrapper around the module DBI, which provides me a convenient interface to set up a query and query the database with relative ease. I had a look at DBIx::Wrapper, I am yet to code using it. But I will be very happy, if any perl module provides me an XML based query set up and get the response in XML. I think that the DBIx::Wrapper will return the response in XML if we really need. When the use of DBI is more in a project, it becomes difficult to work around this plain DBI module. Please point me some directions on this issue.

Replies are listed 'Best First'.
Re: convenient wrapper for DBI module
by mirod (Canon) on Oct 24, 2008 at 07:40 UTC

    My favourite low-level interface to databases is DBIx::Simple. It's interface is simpler and more consistent than DBI, and it makes simple tasks very simple indeed.

    To get XML back from a database, I have used XML::Generator::DBI in the past, with good results.

    And finally, if you want a higher-level interface, an ORM actually, then these days DBIx::Class seems to be the most popular choice.

[reply]
Re: convenient wrapper for DBI module
by desoto (Novice) on Oct 27, 2008 at 20:33 UTC

    My favorite wrapper is Data::ObjectDriver. I can't say I'm well versed in all the data abstraction methods and modules out there, but I've found it to be the easiest to use.

    My only complaint is that there's no Oracle driver available for it. The guys that wrote Data::ObjectDriver have written a Oracle driver (it's used in Movable Type), but haven't released it to CPAN.

[reply]
Re: convenient wrapper for DBI module
by Youdaman (Acolyte) on Oct 29, 2008 at 00:43 UTC
[reply]

Back to Seekers of Perl Wisdom