Python is a general purpose, high-level scripting language
that is well suited for rapid application development. Python emphasizes
code readability and supports various programming paradigms, including
procedural, object-oriented, aspect-oriented, meta, and functional
programming. The Python language is managed by the Python Software
Foundation.
The following extensions are available for accessing IBM® Database servers from a Python application:
- ibm_db
- This API is defined by IBM and
provides the best support for advanced features. In addition to issuing
SQL queries, calling stored procedures, and using pureXML®, you can access metadata information.
- ibm_db_dbi
- This API implements Python Database API Specification v2.0. Because
the ibm_db_dbi API conforms to the specification, it does not offer
some of the advanced features that the ibm_db API supports. If you
have an application with a driver that supports Python Database API
Specification v2.0, you can easily switch to ibm_db. The ibm_db and
ibm_db_dbi APIs are packaged together.
- ibm_db_sa
- This adapter supports SQLAlchemy, which offers a flexible way
to access IBM Database servers.
SQLAlchemy is a popular open source Python SQL toolkit and object-to-relational
mapper (ORM).
- ibm_db_django
- This adapter enables access to IBM Database
servers from Django. Django is a popular web framework used to build
high-performing, elegant web applications quickly.
Python applications can access the following IBM Database servers:
- IBM DB2® for Linux, UNIX, and Windows Version
9.5 and later
- Remote connections to IBM DB2 for i V5R3,
with PTF SI27358 (includes SI27250)
- Remote connections to IBM DB2 for i V5R4
and later, with PTF SI27256
- Remote connections to IBM DB2 for z/OS® Version
8 and later
- IBM Informix® database server Version
11.10 and later