Is there a Perl ORM with database reverse engineering?

Question

I’m looking for a Perl ORM library that has support for reverse engineering of the database schema. All I’ve found so far is http://perlorm.sourceforge.net/ and it appears to have no reverse engineering support.

Answer 1

There are three commonly used ORMs in Perl, Class:DBI, DBIx::Class and Rose::DB::Object. According to this page at PerlMonks, they can all load the metadata from the database, but it doesn't say how.

Answer 2

There is a list of recommended ORM modules at the P5P wiki.

Rose::DB::Object and DBIx::Class can generate classes for you from an existing database schema, and can also write them out to a set of Perl module files.

• Rose::DB::Object::Loader
• DBIx::Class::Schema::Loader

Answer 3

DBIx::Class has DBIx::Class::Schema::Loader which generates classes for you from an existing datbase and can also write them out to files. It it limited to loading a single schema though.