2.5 Connection Summary


Database interaction starts with a connection. I mentioned a few common connection problems and how to troubleshoot them. Once I have a connection, then I begin testing queries. The DBI function dbGetQuery takes two arguments - 1) the connection 2) a query string. Finally, I mentioned that it’s good to get in the habit of closing connections or use the pool package.