[DB-SIG] API suggestion: expose 'quote' method
david at sundayta.com
Wed Jun 4 00:17:05 EDT 2003
> I don't see a need for this quote function for building SQL
> statements, and I don't see how it could work cross platform
> as presented, but I think it could be a good way to see what
> is happening under the hood. I would like to have that for
> pure debugging and logging purposes.
In java there is a JDBC Driver called p6spy which installs as a standard
jdbc driver in your application between it and the real jdbc driver. It
then logs every call to the jdbc driver. For example it shows prepared
statements before and after binding.
This is very useful for debugging sql (eg to make sure that proxies are
However, my limited understanding of the dbi-api is that it is not yet
complete enough as a layer for this to be possible. So far as I can see
it is not yet so easy to write cross dbms code in python as it is in
java. I would like to be proved wrong.
David Warnock, Sundayta Ltd. http://www.sundayta.com
iDocSys for Document Management. VisibleResults for Fundraising.
Development and Hosting of Web Applications and Sites.
More information about the DB-SIG