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.
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.
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.
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.
mxODBC Zope/Plone Database Adapter 2.1.0 was released on 2012-09-18. These are the highlights of the new release:
- 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.
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 email@example.com, stating your name (or the name of the company) and the number of eval licenses that you need.
Please visit the eGenix mxODBC Zope DA product page for downloads, instructions on installation and documentation of the packages
For more information on the eGenix.com Python products, licensing and download instructions, please write to firstname.lastname@example.org.
Marc-Andre Lemburg, eGenix.com