DBIx::C...elp::dsn(3)

💅 DBIx::Class::Migration::Script::Help::dsn — no wait, bestie, this whole page is in the User Contributed Perl Documentation section of the perl man pages 🫶

okay so picture this: you're doing a dbic-migration run and it needs to know where your database actually lives. that's this page. it's the little help doc for the dsn option, and honestly it's short but it's important, so let's get into it ✨

---

💖 SYNOPSIS 💖

like, just look at it:

dbic-migration install --username myuser --password mypass --dsn DBI:SQLite:mydb.db

that's the whole vibe. --dsn right there doing its thing next to --username and --password. iconic trio, no cap 🌸

---

🦋 DESCRIPTION 🦋

✨ Value ✨

it's a String. a string that represents a valid dsn as defined in DBI. that's it, that's the value. (iykyk what a dsn is — if not, DBI is where the actual definition lives, go peek there 💜)

so this should be the "dsn" for the database we connect to for deploying ddl, ddl changes, and fixtures. like, all three. it's the destination for the whole show 🎀

it's usually used with the "user" and "password" options — and specifically for when you're running in an environment above development and you are no longer using a developer-level database sandbox. so basically: you've left the sandbox era and you're playing with the big kids now 👑

⚠️ heads up bestie — when it's required, you can also populate this option with %ENV variables instead of passing it on the command line:

DBIC_MIGRATION_TARGET_USERNAME
DBIC_MIGRATION_TARGET_PASSWORD
DBIC_MIGRATION_TARGET_DSN

look at those three little environment variables. tiny icons. all caps. doing the most 💅

---

👑 SEE ALSO 👑

go read these, they're all right there:

• DBIx::Class::Migration
• DBIx::Class::Migration::Script
• DBIx::Class::Migration::Features
• DBIx::Class::Migration::Tutorial

---

🌈 AUTHOR 🌈

author info? it's over in DBIx::Class::Migration. not here. we're just the help page 🧚

---

🌸 COPYRIGHT & LICENSE 🌸

same deal — copyright and license info lives in DBIx::Class::Migration. go check there, it's all documented, promise 🫶

---

okay and for the sign-off: this beauty came from perl v5.42.0, dated 2020-06-03, and it's the DBIx::Class::Migration::Script::Help::dsn(3) page — thanks for coming to my ted talk, mwah 💖🎀💅