eGenix mxODBC Django Database Engine 1.2.0 GA
Introduction
The mxODBC Django Database Engine™ 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:
- access all your Microsoft SQL Server databases using the native Django ORM integration we provide for MS SQL Server 2005, 2008 and 2012, or
- 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.
Across Platforms
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.
For more information, please see the
News
The 1.2.0 release of mxODBC Django Database Engine is the first public release of our Django database engine.
Features
- 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 managers.
- 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 requirements.
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 backend.
- 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 all popular SQL Server ODBC drivers: The mxODBC Django Database Engine supports the MS SQL Server Native Client on Windows, the MS SQL Server Native Client for Linux, as well as the FreeTDS ODBC driver. Commercial drivers from well-known driver vendors are also supported.
- 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 used.
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 support.
- 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.
Downloads
Please visit the eGenix mxODBC Django Database Engine product page for downloads, instructions on installation and documentation of the packages.
If you want to try the package, please jump straight to the download instructions.
Fully functional 30-day evaluation licenses for the mxODBC Django Database Engine are available free of charge.
Support
Commercial support for this product is available directly from eGenix.com.
Please see the support section of our website for details.
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