views:

200

answers:

1

In Ror or Django or web2py you can "describe" a database (as a set of classes that remaps to tables) and the framework (having being provided with a connection string to the desired database) generates the tables, fields, relations and in the case of RoR and web2py it also keeps it up-to-date (eg, removing a class drops the table, adding a property to the class triggers an "alter table add" etc).

Is there any Perl module that does the same? Eg, it takes the YAML/XML/JSON description of a database as input and modifies/generates the database schema accordingly?

+2  A: 

Yes, the module is SQL::Translator::Parser::YAML, and here is some documentation

singingfish
Also known as SQLFairy -> http://sqlfairy.sourceforge.net/
daotoad