eGenix mxODBC Zope DA 2.1.1 GA
Introduction
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 CMS.
>>> mxODBC Zope DA Product Page
News
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 cursors".
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
performance. The Zope DA documentation comes with high level
documentation regarding the cursor types. The included mxODBC
documentation has the technical details.
Fixes
- Fixed the installation instructions to be more generic and easily adaptable to Plone and Zope installations on both Windows and Unix platforms.
Features
mxODBC Zope/Plone Database Adapter 2.1.0 was released on 2012-09-18. These are the highlights of the new release:
Updated Plone Support
- Simplified zc.buildout deployment as used in Plone 4.x and the latest Zope 2.13 releases.
- Compatible with all recent Plone versions. Please see the mxODBC Zope DA documentation for details on how to install the product for use in Plone.
Enhanced ODBC Driver Support
- Updated the integrated mxODBC Python Extension to the latest 3.2 release, which includes a number of important new features and ODBC driver compatibility enhancements:
- Added support for the DataDirect ODBC manager on Linux which is used by several data warehouse database backends
- Added MS SQL Server ODBC Driver 1.0 for Linux support
- Added Teradata support
- Added Netezza support
- Switched to unixODBC 2.3.1+ API for better 64-bit support on Linux
- Enhanced Oracle Instance Client support
- Enhanced IBM DB2 driver support
- Enhanced Sybase ASE driver support
- Enhanced FreeTDS ODBC driver support
- Enhanced PostgreSQL driver support
- Enhanced generic support for many other ODBC compatible databases
Please see the mxODBC 3.2 release announcement for a complete set of changes available in the underlying mxODBC 3.2 package used in mxODBC Zope/Plone DA 2.1.
For the full list of features, please see the mxODBC Zope DA feature list.
Upgrading
Users are encouraged to upgrade to this latest mxODBC Zope/Plone DA
release to benefit from the new features and updated ODBC driver
support.
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@egenix.com, stating your name (or the name of the company) and the number of eval licenses that you need.Downloads
Please visit the eGenix mxODBC Zope DA product page for downloads, instructions on installation and documentation of the packages
More Information
For more information on the eGenix.com Python products, licensing and download instructions, please write to sales@egenix.com.
Enjoy !
Marc-Andre Lemburg, eGenix.com