[Zope] Fwd: ANN: eGenix mxODBC Zope Database Adapter, Version 1.0.0

Dylan Reinhardt zope@dylanreinhardt.com
Fri, 28 Feb 2003 13:28:04 -0800


Saw this in comp.lang.python, thought it might be of interest 
hereabouts.  Haven't used it myself.

Dylan


>From: "M.-A. Lemburg" <mal@lemburg.com>
>Organization: eGenix.com Software GmbH
>To: "Python List @ Python.org" <python-list@python.org>
>Subject: ANN: eGenix mxODBC Zope Database Adapter, Version 1.0.0
>Date: Fri, 28 Feb 2003 21:59:37 +0100
>
>________________________________________________________________________
>ANNOUNCEMENT
>
>                              EGENIX.COM
>
>                      mxODBC Zope Database Adapter
>
>                             Version 1.0.0
>                         (for Zope 2.5 and 2.6)
>
>________________________________________________________________________
>INTRODUCTION
>
>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 eGenix.com 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/95, Linux and Solaris using the same interface on all
>platforms.
>
>The mxODBC Zope DA implements 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 performance
>than ZODBC Zope DA or similar Zope database adapters under heavy load.
>This makes it ideal for deployment in Zope Clusters and Zope hosting
>environments where stability and high performance are a top priority.
>
>________________________________________________________________________
>FEATURES
>
>* Zope Level 3 Database Adapter: the mxODBC Zope DA is fully
>   multi-threaded and can handle multiple connections to multiple
>   databases.
>
>* Fully compatible to Z SQL Methods.
>
>* 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
>   object.
>
>* 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
>   replay).
>
>* 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.
>
>________________________________________________________________________
>MORE INFORMATION
>
>For more information on the mxODBC Zope DA, licensing and download
>instructions, please visit our web-site:
>
>     http://www.egenix.com/
>
>________________________________________________________________________
>
>Thank you,
>--
>Marc-Andre Lemburg
>eGenix.com
>
>Professional Python Software directly from the Source  (#1, Feb 28 2003)
>>>>Python/Zope Products & Consulting ...         http://www.egenix.com/
>>>>mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
>________________________________________________________________________
>Python UK 2003, Oxford:                                     32 days left
>EuroPython 2003, Charleroi, Belgium:                       116 days left
>
>
>
>--
>http://mail.python.org/mailman/listinfo/python-list
>