Revision 8 as of 2008-02-18 17:41:33

Clear message

SAP DB (MaxDB)

URL for 7.6 and later

http://www.sdn.sap.com/irj/sdn/maxdb

URL for 7.5

(was http://www.mysql.org/products/maxdb/, but is no longer available)

URL for 7.3 and 7.4

http://www.sapdb.org/

licence
GPL
platforms
Linux/i386, Solaris, HP-UX, AIX, Dec, Windows


DB API 2.0 Drivers

sapdbapi

URL

http://www.sapdb.org/sap_db_program.htm

licence
LGPL
platforms
see SAP DB
Python versions
1.5.2 - 2.2

mxODBC

URL

http://www.egenix.com/products/python/mxODBC/

Licence
eGenix.com Commercial License
Platforms
Windows, Linux, MacOS X, FreeBSD, Solaris, AIX
Python versions
2.1 - 2.5

SAP DB's native CLI is ODBC compatible and mxODBC can link directly against these libraries on Unix. It also supports the SAPDB ODBC driver on Windows.

Other Drivers

sapdb

URL

http://www.sapdb.org/sap_db_program.htm

licence
LGPL
platforms
see SAP DB
Python versions
1.5.2 - 2.2

Programming Model

cursor = session.sql ("select * from messages")
for msgno, lang, text in cursor:
    print msgno, text

insert = session.prepare ("insert into sometable values (?, ?)")
print insert.getDescription ()
insert.execute (["string", 1])

select = session.prepare ("select * from messages where msgno < :msgno")
cursor = select.execute ([200])
print cursor.next ()
print cursor.relative (100)
print cursor.absolute (4)
print cursor.absolute (-4)


Supported Python Applications

Unable to edit the page? See the FrontPage for instructions.