Good way to deploy a database in a Perl module?

Question

Does anyone have recommendations for deploying a database as part of a Perl application which is itself deployed as a Perl module?

Generally, I include a schema in a SQL file, but I would like to have a more automated process.

Answer 1

The DBIx::Class ORM has support for versioning and deploying database schemas. You can have your users either update manually or you can provide scripts. This is what I usually do, since it also allows me to deploy a SQLite database file to use during development while staging/production can be any other supported system.

There is also DBIx::Class::DeploymentHandler, which I haven't used that much yet, so can't fully comment. It seems to have very good documentation though, so it's also worth a look.