It's very dificult decision. I'm prefer to use some callback function for logging all queries. But I don't know how to realise this callback - trace and profile callbacks can't show query string with variables values.
2008/8/11, Dennis Cote <[EMAIL PROTECTED]>: > Alexey Pechnikov wrote: >> >> Can I get full log of sql statements for to sent it other network or store >> to >> outher device? >> > > Alexey, > > You may want to read http://www.sqlite.org/cvstrac/wiki?p=UndoRedo for > an example of using triggers to generate SQL to modify a database. This > example is used for undo/redo, but the principals would be the same if > you want to generate an SQL log of changes that have been made to a > database. > > HTH > Dennis Cote > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users