Re: [sqlite] Tracing Statements...

[Tim Murison]

On Sat, 2006-02-11 at 01:19 -0800, Nathaniel Smith wrote:
> On Sat, Feb 11, 2006 at 03:37:11AM -0500, Tim Murison wrote:
> > I would like to be able to generate a log of all sql statements executed
> > by my program.
> > 
> > Unfortunately all of my queries use parameters, and I would like to get
> > the full query (all parameters replaced with their sqlite3_bind_*
> > values).
> 
> In monotone, we log "executing command <...> with parameter 1 bound to
> <...>, parameter 2 bound to <...>," etc.
> 
> -- Nathaniel
> 

I thought of this too, it's just annoying in a few situations.

Re: [sqlite] Tracing Statements...

[Nathaniel Smith]

On Sat, Feb 11, 2006 at 03:37:11AM -0500, Tim Murison wrote:
> I would like to be able to generate a log of all sql statements executed
> by my program.
> 
> Unfortunately all of my queries use parameters, and I would like to get
> the full query (all parameters replaced with their sqlite3_bind_*
> values).

In monotone, we log "executing command <...> with parameter 1 bound to
<...>, parameter 2 bound to <...>," etc.

-- Nathaniel

-- 
"Of course, the entire effort is to put oneself
 Outside the ordinary range
 Of what are called statistics."
  -- Stephan Spender