Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Python > ANN: eGenix mxODBC Zope Database Adapter

Thread Tools

ANN: eGenix mxODBC Zope Database Adapter

M.-A. Lemburg
Posts: n/a
__________________________________________________ ______________________


mxODBC Zope Database Adapter

Version 1.0.7

Available for Zope 2.3 through 2.7 on
Windows, Linux, Solaris and FreeBSD

__________________________________________________ ______________________

The eGenix mxODBC Zope Database Adapter (Zope DA) allows you to easily
connect your Zope installation to just about any database backend on
the market today, giving you the reliability of the commercially
supported product mxODBC and the flexibility of the ODBC
standard as middle-tier architecture.

Unlike Zope's ZODBC Zope DA, the mxODBC Zope DA works on Windows
XP/NT/2000/98, Linux, Solaris and FreeBSD using the same interface on
all platforms.

The mxODBC Zope DA implements high performance thread-safe connection
pooling and multiple physical connects per logical Zope
connection. You can safely run Z SQL Methods in parallel, achieving a
much better throughput than ZODBC Zope DA or similar Zope database
adapters under heavy load.

This makes it ideal for deployment in ZEO Clusters and Zope hosting
environments where stability and high performance are a top priority.

__________________________________________________ ______________________

* Zope Level 3 Database Adapter: the mxODBC Zope DA is fully
multi-threaded and can handle multiple connections to multiple

* Fully compatible to Z SQL Methods.

* Drop-in compatible to the ZODBC DA: the mxODBC Zope DA provides the
same interfaces as Zope's ZODBC DA to allow a smooth upgrade path
from this simplistic adapater to the high performance mxODBC Zope

* Fully compatible to the Znolk SQL Wizard Product and other similar
products relying on the common database schema access methods
.tables() and .columns().

* Connection Pooling: physical database connections are pooled and
kept open, to reduce the connection overhead to a minimum. This is
especially important for high latency database connections and ones
like Oracle which take a considerable amount of time to setup

* Parallel Execution of Queries on a single logical connection: the
mxODBC Zope DA can manage any number of physical connections on a
single logical connection. This enables running truly parallel Z SQL
Method queries -- a feature not available in other Zope DAs.

* Robust Mode of Operation: connections which have timed out or go
away due to network problems are automatically reconnected.

* Cross-platform Connection Objects: The Zope DA will automatically
choose the right platform specific ODBC manager for you.

* Per Connection Adjustable ODBC Interface: mxODBC comes with many
different subpackages to choose from on Unix. The Zope DA allows you
to select these subpackages on a per-connection basis.

* Per Connection Error Handling: you can tell each connection whether
it should report ODBC warnings or not; furthermore all warnings and
errors are made available as list .messages on the DatabaseConnection

* Transaction safe automatic reconnect: when the DA finds that a
connection has timed out, it automatically tries a reconnect
and replays the transaction on the connection (unlike other DAs
which break the transaction scheme by doing a reconnect without

* Built-in Schema Cache: this results in improved performance under
heavy load.

* Database Schema Access: all ODBC catalog methods are made available
for much better database schema inquiry. The catalog methods allow
building generic database interrogation or manipulation tools and
facilitates writing database independent Zope products.

* Lazy Connect: the mxODBC Zope DA only connects to the database
backends when a connection is actually requested. This results in a
better use of resources compared to other Zope DAs.

__________________________________________________ ______________________

Version 1.0.7 includes the following changes and enhancements:

* Zope 2.7.0 and Python 2.3 are now fully supported.

* The connection pooling was made more robust to allow less capable
ODBC drivers to work nicely with the mxODBC Zope DA.

* A new option was introduced to let the mxODBC Zope DA return empty
strings instead of None for SQL NULL values. This should simplify
porting applications to the mxODBC Zope DA.

* A problem with the MS SQL Server was solved which caused deadlocks
under heavy load in some application settings.

In short: mxODBC Zope DA is continuing to become the number one
solution for integrating relational databases with Zope applications.

__________________________________________________ ______________________

If you have already bought mxODBC Zope DA licenses, you can use these
license for the updated version as well. There is no need to buy new
licenses. The same is true for evaluation license users.

__________________________________________________ ______________________

For more information on the mxODBC Zope DA, licensing and download
instructions, please visit our web-site:

You can buy mxODBC Zope DA licenses online from the shop at:

__________________________________________________ ______________________

Thank you,
Marc-Andre Lemburg

Professional Python Services directly from the Source (#1, Dec 11 2003)
>>> Python/Zope Consulting and Support ...
>>> mxODBC.Zope.Database.Adapter ...
>>> mxODBC, mxDateTime, mxTextTools ...

__________________________________________________ ______________________

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
ANN: eGenix mxODBC and mxODBC Zope DA on AIX 5.3 (and later) eGenix Team: M.-A. Lemburg Python 0 11-19-2007 12:43 PM
ANN: eGenix mxODBC and mxODBC Zope DA on 64-bit FreeBSD eGenix Team: M.-A. Lemburg Python 0 09-12-2007 03:23 PM
ANN: eGenix mxODBC Zope Database Adapter 1.0.10 eGenix Team: M.-A. Lemburg Python 0 07-10-2006 02:59 PM
ANN: eGenix mxODBC Zope Database Adapter 1.0.9 M.-A. Lemburg Python 0 10-17-2005 09:58 PM
ANN: eGenix mxODBC Zope Database Adapter 1.0.8 mal Python 0 01-23-2004 03:54 PM