Good way to deploy a database in a Perl module?
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 S开发者_开发知识库QL file, but I would like to have a more automated process.
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.
精彩评论