Feb

13

IBM releases DB2 adapter for SQLAlchemy

By Antonio Cangiano. Filed under DB2, Django, Python 

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:

  1. 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.
  2. 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.

Related Articles:


If you enjoyed this post, then make sure you subscribe to our RSS Feed.

Comments

5 Responses to “IBM releases DB2 adapter for SQLAlchemy”

  1. Shawn on February 13th, 2008 1:29 pm

    This is great news! Any word on OS X support?

  2. Jeff on February 13th, 2008 1:36 pm

    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.

  3. Mark Ramm on February 13th, 2008 11:57 pm

    Awesome news. SQLAlchemy is a fantastic tool, and it’s great to have more backend options. Rock on!

  4. Viktor on February 14th, 2008 8:54 am

    This is wonderful news! I should get recharge don using this again! Keep us updated on any other updates. Thanks!

  5. Robert on April 9th, 2008 10:23 am

    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)

Leave a Reply