Python, SQLAlchemy, and Django Framework application development for IBM Database servers
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 listed 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. For more information, see Python support for IBM Db2 for LUW, IBM Informix and IBM Db2 for z/OS.
- 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). For more information, see IBM_DB_SA.
- ibm_db_django
- This adapter provides access to IBM Database servers from Django. Django is a popular web framework used to build high-performing, elegant web applications quickly. For more information, see Getting started with IBM DB Django adapter.
If you want to connect your Python applications to Db2® for IBM® i V5R4 and later servers, you must have PTF SI27256 applied to those servers.