661
Comment:
|
1175
|
Deletions are marked like this. | Additions are marked like this. |
Line 3: | Line 3: |
== SQL Databases == | == Relational Databases == |
Line 21: | Line 21: |
* other databases with Python support through ODBC or Jython support through JDBC | * Most databases have ODBC support; see the section below on ODBC modules. * Java databases usually support JDBC, and can be used from Jython. |
Line 25: | Line 26: |
== Other Databases == | == ODBC Support == * pyodbc: http://pyodbc.sourceforge.net/ * mxODBC: http://www.egenix.com/products/python/mxODBC/ Provides ODBC connectivity on Windows, Mac OS X, FreeBSD and most other Unix platforms. * ODBTPAPI: http://benjiyork.com/odbtp.html == ADO Support == * adodbapi (http://adodbapi.sourceforge.net/): A Python module that makes it easy to use Microsoft ADO for connecting to databases and other data sources. == Non-Relational Databases == |
Line 32: | Line 48: |
* ["db star"] |
This page should help in choosing the right database.
Relational Databases
- ["MySQL"]
- ["Oracle"]
- ["PostgreSQL"]
- ["SQLite"]
- ["SQL Server"]
- ["Informix"]
- ["Ingres"]
- ["Firebird"] (and Interbase)
- ["SAP DB"]
- ["Sybase"]
- ["ThinkSQL"]
add new entries (choose DatabaseTemplate when creating the page)
- Most databases have ODBC support; see the section below on ODBC modules.
- Java databases usually support JDBC, and can be used from Jython.
See also DbApiModuleComparison
ODBC Support
pyodbc: http://pyodbc.sourceforge.net/
mxODBC: http://www.egenix.com/products/python/mxODBC/ Provides ODBC connectivity on Windows, Mac OS X, FreeBSD and most other Unix platforms.
ODBTPAPI: http://benjiyork.com/odbtp.html
ADO Support
adodbapi (http://adodbapi.sourceforge.net/): A Python module that makes it easy to use Microsoft ADO for connecting to databases and other data sources.