I understand that with this approach each insertion uses a new connection to the database. Is this efficient compared with having just one connection created at backend setting time?

(This discussion remembers to the one we have about requesting a new fresh HTTP client each time a data is inserted in CKAN or HDFS :). In that case, the conclusion was it made sense to create a new one per insertion. Does the same apply for MySQL connections?)