What are the benefits of using one of the DB modules like DBI as opposed to just making a mysql connection like this.
my $conn = qq|mysql -u ro_user -ppassword -e|;
my $query = qq|show tables LIKE '\%jobs_finished\%'|;
my $cmd = qq|$pre "$query" table_name|;
I know there must be real good reasons not to do this but the only thing that I can come up with is "it is bad practice to place the user name and password in the script". There has to many more drawbacks than that right?