[DB-SIG] Unittests for Python Database API Specification 2.0

[M.-A. Lemburg]

Michael Scharf wrote:
> Hi,
> 
> are there any unit tests for the "Python Database API Specification 2.0".
> I have seen some kind of tests in mxODBC, but I wonder if there is a set
> of unit tests that can be used to check the conformance to the PDAPI2.0?

Indeed. mxODBC has a test script which is used to test
the interface, but also to check the capabilities of the
ODBC drivers and the database backend.

> It would also be cool to have tests that tell you which features a
> particular PDAPI2.0 database implements. That could be helpful for
> deciding which database to use. It would also help when one wants to
> switch to another implementation.

Reading the documentation usually helps more :-)

> Another nice thing would be to have a set of performance tests based
> on the PDAPI2.0. That could be very helpful when to compare different
> implementations. There are so many databases and it's really hard to
> decide which one to use (given some performance constraints)...

I don't think that the interfaces cost that performance. It's
the database sitting behind the interface that's causing differing
performance... choosing a database is much like choosing a car:
you have cheap ones, expensive ones, fast and slow ones, heavy
weights and Smarts, etc.

Simple tests like the one used in mxODBC don't give you enough
information to help you decide.

You should also not forget that database administration is an
important factor: running DB2 or Oracle is a full-time job
for quite a few IT-people.

-- 
Marc-Andre Lemburg
CEO eGenix.com Software GmbH
_______________________________________________________________________
eGenix.com -- Makers of the Python mx Extensions: mxDateTime,mxODBC,...
Python Consulting:                               http://www.egenix.com/
Python Software:                    http://www.egenix.com/files/python/