|
Size: 1270
Comment: Noted that mxODBC is commercial.
|
Size: 1470
Comment: Tidied up.
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 1: | Line 1: |
| This page should help in choosing the right database. | = Choosing a Database System = |
| Line 3: | Line 3: |
| == Relational Databases == Databases based on a relational model, with support for SQL. * ["DB2"] |
This page should help in choosing the right database system. == Relational Database Systems == Database systems employing a relational model, with support for SQL. * IBM ["DB2"] * ["Firebird"] (and Interbase) * ["Informix"] * ["Ingres"] |
| Line 9: | Line 16: |
| * ["SQLite"] * ["SQL Server"] |
* ["SAP DB"] (renamed to MaxDB) * Microsoft ["SQL Server"] * ["Sybase"] |
| Line 12: | Line 20: |
| ------ | The following database systems are more oriented towards embedded applications: |
| Line 15: | Line 23: |
| * ["Informix"] * ["Ingres"] * ["Firebird"] (and Interbase) * ["SAP DB"] * ["Sybase"] |
* ["SQLite"] |
| Line 21: | Line 25: |
| * add new entries (choose Database''''''Template when creating the page) | To add new entries (choose DatabaseTemplate when creating the page). == Database Interfaces and APIs == |
| Line 24: | Line 32: |
See also DbApiModuleComparison |
* See also DbApiModuleComparison |
| Line 39: | Line 46: |
Choosing a Database System
This page should help in choosing the right database system.
Relational Database Systems
Database systems employing a relational model, with support for SQL.
- IBM ["DB2"]
- ["Firebird"] (and Interbase)
- ["Informix"]
- ["Ingres"]
- ["MySQL"]
- ["Oracle"]
- ["PostgreSQL"]
- ["SAP DB"] (renamed to MaxDB)
- Microsoft ["SQL Server"]
- ["Sybase"]
The following database systems are more oriented towards embedded applications:
- ["SQLite"]
- ["ThinkSQL"]
To add new entries (choose DatabaseTemplate when creating the page).
Database Interfaces and APIs
- 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 : A commercial library that 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.