http://qs321.pair.com?node_id=11125312

kaldor has asked for the wisdom of the Perl Monks concerning the following question:

Dear Monks,

I need some advice about logging with DBIx::Simple (+ SQL::Interp), since I can't figure it out myself.

I'd like a unified way to trace the SQL queries and log the application errors, so something like Log::Any seems the way to go. Of course, I'd rather see the placeholders replaced by quoted bind values in my logs, like DBI::Log does (but limited to DBI tracing). And there's also DBIx::LogAny.

If it's possible to use DBIx::Simple and DBIx::LogAny together, then I don't understand how to do it. For example, DBIx::Simple::connect seems to call DBI::connect and DBIx::LogAny::connect calls SUPER::connect, so what will happen if I use both modules? Should I pass them $dbh, but then in what order?

Thanks.