Completed
Details
Assignee
Sean CorfieldSean CorfieldReporter
importimportPriority
Major
Details
Details
Assignee
Sean Corfield
Sean CorfieldReporter
import
importPriority

Created December 11, 2013 at 10:56 AM
Updated June 1, 2016 at 6:41 PM
Resolved June 1, 2016 at 6:41 PM
Currently, it is very easy to get spurious connection use on multiple statements,for instance by mapping a query function over a collection.
A workaround for this can be done by providing a binding through db-transaction.
However, this complects single connection use with commit / rollback mechanics that might be unwanted.
Another option is providing the binding yourself by wrapping it in a with-open/let construction.
This needs people to get into the implementation of the connection system, and might not play well with it.
Using connection pools is the last option, but usually is overkill for simple tasks.
Creating a macro and function that provides a simple binding for a connection in the way db-transaction does, without the included commit/rollback mechanics would do the trick. Such a function would play nice with the rest of the new connection propagation system (even including levels), and still doesn't rely on the rebinding of global vars.