CODEWITHSUNDEEP
databaseperl
jrowe
jrowe

Reputation: 93

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 SQL file, but I would like to have a more automated process.

Upvotes: 8

Views: 267

Answers (1)

phaylon
phaylon

Reputation: 1923

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.

Upvotes: 10

Related Questions