|
Size: 1221
Comment:
|
Size: 1654
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 2: | Line 2: |
| [[TableOfContents]] | |
| Line 4: | Line 3: |
| == Masthead == | = SAP DB (MaxDB) = |
| Line 6: | Line 5: |
| URL:: http://www.sapdb.org/ | 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/ |
| Line 9: | Line 10: |
---- |
|
| Line 19: | Line 22: |
| ==== Extensions to DB API ==== | === mxODBC === |
| Line 21: | Line 24: |
| ==== Comments ==== | 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. |
| Line 33: | Line 41: |
| Line 49: | Line 58: |
| ==== Comments ==== | ---- |
| Line 52: | Line 62: |
| Line 53: | Line 64: |
== Pros == == Cons == |
SAP DB (MaxDB)
- URL for 7.6 and later
- URL for 7.5
(was http://www.mysql.org/products/maxdb/, but is no longer available)
- URL for 7.3 and 7.4
- licence
- GPL
- platforms
- Linux/i386, Solaris, HP-UX, AIX, Dec, Windows
DB API 2.0 Drivers
sapdbapi
- URL
- licence
- LGPL
- platforms
- see SAP DB
- Python versions
- 1.5.2 - 2.2
mxODBC
- URL
- 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
- 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
- a sapdb driver exists for ["PyDO"] (Python Data Objects)