Hello!
On Thursday 10 December 2009 04:04:34 Roger Binns wrote:
>
Thanks! The great idea.
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Alexey Pechnikov wrote:
> I want to build a universal extension for logging all user queries. I can
> write
> this with trace function but it's difficult or impossible to split system and
> user queries.
There are two ways that can be done. The
Hello!
On Thursday 10 December 2009 02:36:25 Simon Slavin wrote:
> Do not rely on the operation of 'trace' in production code. It's a debugging
> feature only.
But why? I think with additional query type argument the trace function will be
useful in
production for database logging and
On 9 Dec 2009, at 11:16pm, Alexey Pechnikov wrote:
> I want to build a universal extension for logging all user queries. I can
> write
> this with trace function but it's difficult or impossible to split system and
> user queries.
Do not rely on the operation of 'trace' in production code.
Hello!
On Thursday 10 December 2009 01:36:39 Roger Binns wrote:
> My point was that if you only want to log queries your code makes then alter
> your code. For example instead of calling sqlite3_prepare/bind directly you
> can make wrapper functions that log the query and bindings. And because
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> The second argument with query type [user|system] for trace function
> will be very helpful. And third argument for profile function. But may be
> exists another way for logging only user queries?..
I'm sorry but I can not understand what you are
Hello!
On Wednesday 09 December 2009 22:49:53 Roger Binns wrote:
> Since you are the "user" you can do your own logging to the SQLite API
> recording whatever information you want.
The second argument with query type [user|system] for trace function
will be very helpful. And third argument for
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Alexey Pechnikov wrote:
> As you can see internal system queries are visualized too. It's may be useful
> for developers but very bad for users becouse it's impossible to log only
> user-applied queries.
Since you are the "user" you can do your own
8 matches
Mail list logo