Hi, In debugging and inspecting applications using sqlite, I find it would be very useful to log some or all queries sent to the database, ideally also with timing information on how long it took to gather and send the response, so that it can be determined what queries are received and how long each query actually takes. It's possible to do this at the application level, but I think it would be very useful to do this using sqlite itself. If detailed query logging could be enabled in the database with a pragma or by using a debug version of the libarry somehow, it would let users and developers get standardised details about what queries are run and how long they take, even temporarily on a live system.
There's lots of situations where this could be useful, like switching on and off debugging on the fly in live/production systems to identify transient problems or bottlenecks, and debugging software using sqlite with a live dataset without necessarily having to recreate the working conditions in a controlled environment, and without recompiling, and without developing/enabling support for sql debugging in the application. I've used mysql-proxy in the past to debug mysql databases in this way, and it was very effective. But since there's no network connection involved in sqlite, this method can't be used to temporarily redirect the queries in the same way. Have I missed a way to do something like this in sqlite already, or would you regard this as a feature request? Thanks, Ketil _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
