Add Close to the connection.DB interface

Close allows users to close the underlying connections, useful for cases, like tests, where one opens too many connections and does not need them to be long lived.