Re: [DB-SIG] Prepared statements in python drivers

2014-04-09 Thread Federico Di Gregorio
On 09/04/2014 04:49, INADA Naoki wrote: > Prepared statement holds resource on server side. > For example, following code is dangerous when combined with connection pool. > > def myexecute(params): > cur = con.cursor() > cur.prepare(MY_STMT) # allocate resource on server-side that is > fr

Re: [DB-SIG] Prepared statements in python drivers

2014-04-09 Thread INADA Naoki
+1 on explicit separation between prepared statement and server-side placeholder. Prepared statement holds resource on server side. For example, following code is dangerous when combined with connection pool. def myexecute(params): cur = con.cursor() cur.prepare(MY_STMT) # allocate resou