RE: Best practice for connections and cursors

2013-08-02 Thread Joseph L. Casale
Speaking to the OP: personally, I don't like the approach of putting data access methods at the module level to begin with. I'd rather use a class. Just because it makes sense to have a singleton connection now doesn't mean it will always make sense as your application grows. In fact, the

Re: Best practice for connections and cursors

2013-08-01 Thread Neil Cerutti
On 2013-08-01, Joseph L. Casale jcas...@activenetwerx.com wrote: A bit vague I know, but does anyone see the obvious mistake? I assumed the module setting up a singleton connection was a perfectly viable way to accomplish this? My one db application started out creating a new connection to the

Re: Best practice for connections and cursors

2013-08-01 Thread Ian Kelly
On Thu, Aug 1, 2013 at 6:49 PM, Dennis Lee Bieber wlfr...@ix.netcom.com wrote: On Thu, 1 Aug 2013 15:05:08 +, Joseph L. Casale jcas...@activenetwerx.com declaimed the following: As the module opens a connection, wherever I import it I call a commit against the connection after invoking any