The mxODBC Django Database Engine™
product allows you to easily connect your Django website 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.
Flexible Database Access
With the mxODBC Django Database Engine 1.2, you get two ways to connect to your databases:
tap into the powerful SQL-based mxODBC Database Interface
directly from within Django and access databases such as MS SQL Server,
Oracle, IBM DB2 and Informix , Sybase ASE and Sybase Anywhere, MySQL,
PostgreSQL, SAP MaxDB, and many others.
mxODBC Django Database Engine works on Windows, Linux, Mac OS X,FreeBSD, Solaris and AIX, providing you with the same consistent interface, flexibility and robustness across all of these platforms.
Fully integrated with the Django ORM: No need to learn a new API - simply continue to use the known Django ORM interface.
Compatible with all current Django versions: The mxODBC Django Database Engine supports Django 1.4 and 1.5.
Compatible with all recommended Python versions: The database engine supports Python 2.6 and 2.7; both as UCS2 (narrow) and UCS4 (wide) Unicode variant on Unix platforms.
Full Unicode Support: The database engine can communicate with the database using native Unicode and 8-bit encodings such as UTF-8 or CP1252.
Full 64-bit Support: The underlying mxODBC 3.2 library
fully supports 64-bit platforms such as Mac OS X 10.6 (Snow Leopard) or later, and
64-bit Linux systems that use unixODBC, iODBC or DataDirect ODBC
Cross-platform Connection Objects: The database engine will automatically choose the right platform specific ODBC manager for you.
Per Connection Adjustable ODBC Manager Interface: mxODBC
supports many different ODBC managers. The mxODBC Django Database Engine
allows you to select the ODBC manager on a per-connection basis.
Per Connection Customization of Interface Parameters: The
database engines allows adjusting many different parameters to adapt the
engine to your specific database needs, should you have special
MS SQL Server ORM Features
MS SQL Server fully integrated into the Django ORM: Access MS SQL Server through the Django ORM, just like any other Django ORM database.
MS SQL Server Regular Expression Emulation: Even though MS
SQL Server itself does not support regular expressions, the mxODBC
Django Database Engine provides an emulation for simple regular
expressions to simplify porting existing applications to a SQL Server
MS SQL Server Aggregate Function Support: We provide a special aggregate function implementation to have the Django ORM support SQL Server aggregate functions.
MS SQL Server Timestamp Support: SQL Server support
millisecond accuracy on timestamps. The database engine will take care
of applying the necessary rounding for the microsecond precision Python
timestamps in a seamless way.
Support for accessing SQL Server from Windows and Unix platforms:
On Windows and Linux you can use the SQL Server Native Client, on other
Unix platforms and Mac OS X, the FreeTDS driver or other commercial drivers can be
Direct mxODBC Interface to other Databases
Access IBM DB2, Sybase ASE, Oracle, Teradata, Netezza, etc. directly through the proven mxODBC Database API:
Import, query and save data directly to the databases using a simple to
use API and all available database specific SQL dialects, capabilities
and features, including ones for which the Django ORM does not provide
Fully Python DB-API 2.0 compatible interface: mxODBC
support the Python DB-API 2.0, including many standard extensions and
the full set of ODBC catalog methods for database introspection.
Full transaction control: When using the mxODBC Database
API, you get full control over the database connections, including
opening them on demand, in auto-commit mode, dynamically scaling the
number of connections per request, etc.