[Zope] ANN: eGenix mxODBC Zope/Plone Database Adapter 2.1.1

eGenix Team: M.-A. Lemburg info at egenix.com
Tue Apr 2 08:16:17 UTC 2013



                  mxODBC Zope/Plone Database Adapter

                            Version 2.1.1

                     for Zope and the Plone CMS

                Available for Plone 4.0, 4.1 and 4.2,
                        Zope 2.12 and 2.13, on
        Windows, Linux, Mac OS X, FreeBSD and other platforms

This announcement is also available on our web-site for online reading:



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

The mxODBC Zope Database Adapter is highly portable, just like Zope
itself and provides a high performance interface to all your ODBC data
sources, using a single well-supported interface on Windows, Linux,
Mac OS X, FreeBSD and other platforms.

This makes it ideal for deployment in ZEO Clusters and Zope hosting
environments where stability and high performance are a top priority,
establishing an excellent basis and scalable solution for your Plone

Product page:




We are pleased to announce the new version 2.1.1 of our mxODBC
Zope/Plone Database Adapter product.

Feature Enhancements

 * Added a new connection property "ODBC cursor type" which allows
   easily adjusting the ODBC cursor type to be used for mxODBC Zope DA
   connection objects.

   This new property allows enhancing the performance of the adapter
   significantly, when using it with MS SQL Server or IBM DB2 database
   backends. Please see below for details.

Driver Compatibility

 * MS SQL Server performance can now be much enhanced, and increased
   to levels beyond that of previous mxODBC Zope DA releases, by
   adjusting the connection ODBC cursor type to "Forward only

   The performance increase compared to mxODBC Zope DA 2.1.0 is
   enormous: from 2-3x faster executes/fetches for average queries, up
   to 300x faster for simple cases.

   In mxODBC Zope DA 2.2, we will switch to using "Forward only
   cursors" per default for all database backends.

 * IBM DB2 can benefit from the same performance enhancements using
   "Forward only cursors".

   The effect is a lot smaller, but still noticeable: up to 2x faster
   executes/fetches with forward-only cursors, compared to mxODBC Zope
   DA 2.1.0.

 * Added documentation to explain the different cursor types,
   compatibility with different database backends and effects on


 * Fixed the installation instructions to be more generic and easily
   adaptable to Plone and Zope installations on both Windows and Unix

For the full set of changes please check the change log:




Version 2.1.0 of our mxODBC Zope/Plone Database Adapter product
was released on 2012-09-18. Please see the full
announcement for highlights of the 2.1 release:


For the full set of features mxODBC has to offer, please see:




Users are encouraged to upgrade to this latest mxODBC Zope/Plone DA
release to benefit from the new features and updated ODBC driver

We have taken special care not to introduce backwards incompatible
changes, making the upgrade experience as smooth as possible.

As always, patch level upgrades (e.g. from 2.1.0 to 2.1.1) are free of
charge. The licenses you have purchased for 2.1 will continue to work
with this new release.

For major and minor upgrade purchases, we will give out 20% discount
coupons going from mxODBC Zope DA 1.x to 2.1 and 50% coupons for
upgrades from mxODBC 2.x to 2.1. After upgrade, use of the original
license from which you upgraded is no longer permitted.

Please contact the eGenix.com Sales Team with your existing license
serials for details for an upgrade discount coupon.

If you want to try the new release before purchace, you can request
30-day evaluation licenses by visiting our web-site or writing to
sales at egenix.com, stating your name (or the name of the company) and
the number of eval licenses that you need.



Commercial support for this product is available from eGenix.com.
Please see


for details about our support offerings.



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


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


About Python (http://www.python.org/):

    Python is an object-oriented Open Source programming language
    which runs on all modern platforms. By integrating ease-of-use,
    clarity in coding, enterprise application connectivity and rapid
    application design, Python establishes an ideal programming
    platform for today's IT challenges.

About eGenix (http://www.egenix.com/):

    eGenix is a software project, consulting and product company
    focusing on expert project services and professional quality
    products for companies, Python users and developers.

Marc-Andre Lemburg

Professional Python Services directly from the Source  (#1, Apr 02 2013)
>>> Python Projects, Consulting and Support ...   http://www.egenix.com/
>>> mxODBC.Zope/Plone.Database.Adapter ...       http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
2013-03-25: Released mxODBC 3.2.2 ...             http://egenix.com/go40
2013-04-10: Python Meeting Duesseldorf ...                  8 days to go

::::: Try our mxODBC.Connect Python Database Interface for free ! ::::::

   eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
    D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
           Registered at Amtsgericht Duesseldorf: HRB 46611

More information about the Zope mailing list