Meditations on programming, startups, and technology
New Relic

IBM releases DB2 adapter for SQLAlchemy

This article is obsolete. Please refer to the following articles for up do date instructions: Ruby/Rails and DB2 | Python/Django and DB2. Thank you!

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.


If you enjoyed this post, then make sure you subscribe to my Newsletter and/or Feed.

receive my posts by email

5 Responses to “IBM releases DB2 adapter for SQLAlchemy”

  1. Shawn says:

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

  2. Jeff says:

    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 says:

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

  4. Viktor says:

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

  5. Robert says:

    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

I sincerely welcome and appreciate your comments, whether in agreement or dissenting with my article. However, trolling will not be tolerated. Comments are automatically closed 15 days after the publication of each article.

Current ye@r *

Copyright © 2005-2014 Antonio Cangiano. All rights reserved.