Connecting to your database

• Data source name ($dsn) depends on the specific database driver

• usually DBI:$driver:{options}

  • mysql/msql: DBI:mysql:database=$dbname;host=$hname
  • postgresql: DBI:Pg:dbname=$dbname;host=$hname
  • CSV: DBI:CSV:f_dir=/home/dbases/db;csv_sep_char=\;

• $dbh = DBI->connect($dsn, $user, $passwd, \%attr);

  • user, passwd, and attr are optional