Re: [DB-SIG] Re: [Zope-dev] Prototype Zope mxODBC DA
Christopher Petrilli wrote:
BTW, I didn't mean to imply that what you've done isn't useful, it's simply incompatible with the direction we're taking. This is somewhat discussed in my roadmap. If you'd like to maintain the interface that you're talking about, then that'd be excellent.
In what way is it incompatible ? mxODBC is DB API compliant in most parts and has lots of useful extensions such as the ODBC catalog functions. The interface itself is thread safe and thread friendly. Of course, whether a certain ODBC driver is depends on the driver.
We are abandoning the use of DB-API interfaces for our own use simply because they have proven to be of little value in getting things running. In addition, their behavioral assumptions are sometimes quite incompatible with Zope requirements. Jim Fulton can better speak to this. We're now doing a more "thin shim" approach, and not going anywhere near the DB-API or SWIG.
FYI, mxODBC currently works with these database drivers/managers: Adabas - Informix - MySQL - PostgreSQL - Oracle - Solid - Sybase - Windows ODBC Manager - Unix iODBC Driver Manager - Linux unixODBC Driver Manager - EasySoft ODBC Bridge - OpenLink ODBC drivers - Intersolv ODBC drivers + virtually any database supported by one of the listed ODBC managers.
The issue is more that in many cases (Oracle for example) ODBC is enormously slower than the native drivers. we've had people comment that it's something around an order of magnitude. Also, Oracle's ODBC drivers leak like the proverbial sieve. Therefore we plan to target native interfaces, rather than glued on top constructs. Only on Windows is ODBC any form of gain. Now, if X/Open CLI is the native interface (as with DB2), then this will be fine... we just plan to talk to native interfaces. Chris -- | Christopher Petrilli Python Powered Digital Creations, Inc. | petrilli@digicool.com http://www.digicool.com
participants (1)
-
Christopher Petrilli