IBM releases DB2 adapter for SQLAlchemy
A while ago I informally announced IBM’s intention to develop an SQLAlchemy adapter for DB2 and Informix IDS. Today, I’m happy to inform you that we have a first working release for DB2 on Linux, Unix and Windows (LUW). Support for Informix IDS is next (almost done), and after that, it will be System i and z/OS’ turn.
This release will surely excite those Pythonistas who can appreciate DB2 for what it is: one of the most powerful data servers in the world. Which, in its Express-C version, also happens to be gratis (“free as in free beer”). But there is more to it than just that.
IBM has in fact created a project on Google Code, for supporting Python development with IBM Data Servers. Aside from downloads and SVN access, this gives the project a nice public bug tracker which was missing up until this point. A Google Group was also created in order to have an easy to follow support mailing list, and I invite you to join it now.
With the switch to Google Code, there was also an update to the Python drivers (now version 0.2.5), which contain a few improvements and a bug fix for the egg that wasn’t working properly on Linux.
The project currently hosts the following components:
- The ibm_db Python Egg for Linux and Windows which contains:
- The ibm_db driver: a C extension module that wraps IBM’s Data Server Driver for ODBC and CLI APIs and provides a Python client interface for the DB2 and Informix IDS databases.
- The ibm_db_dbi: a Python coded module that relies on the ibm_db Python driver, and complies with the DB-API 2.0 specs.
- The ibm_db_sa: a Python coded adapter which implements the SQLAlchemy 0.4 API specification.
Please use the driver and/or the adapter for SQLAlchemy and let us know if you encounter any issues or have any feedback about it.
If you enjoyed this post, then make sure you subscribe to my Newsletter and/or Feed.
This is great news! Any word on OS X support?
This is great news! I’m trying to convince my work to look at Python and Django and we are a DB2 shop.
Another barrier knocked down.
Awesome news. SQLAlchemy is a fantastic tool, and it’s great to have more backend options. Rock on!
This is wonderful news! I should get recharge don using this again! Keep us updated on any other updates. Thanks!
I’m hoping that db2 django adapter will be next thing. Check following links:
– Backend for DB2 v9 database (http://code.djangoproject.com/ticket/5052)
– “Django adapter (alpha) based on PyDB2 -
contribution” (http://code.djangoproject.com/ticket/6995 == http://code.google.com/p/ibm-db/issues/detail?id=10)