|
Size: 403
Comment: missing edit-log entry for this revision
|
Size: 1539
Comment:
|
| 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: |
| === SQL Databases === | This page should help in choosing the right database system. |
| Line 5: | Line 5: |
| * ["DB/2"] * GadFly |
== Relational Database Systems == Database systems employing a relational model, with support for SQL. * IBM ["DB2"] * ["Firebird"] (and Interbase) |
| Line 9: | Line 13: |
| * ["Interbase"] | |
| Line 13: | Line 16: |
| * ["SAP DB"] * ["SQLLite"] |
* ["SAP DB"] (a lso known as "MaxDB") * Microsoft ["SQL Server"] |
| Line 16: | Line 19: |
| * other databases with Python support through ODBC or Jython support through JDBC | |
| Line 18: | Line 20: |
| === Other Databases === | The following database systems are more oriented towards embedded applications: * GadFly * ["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 == * ceODBC: http://ceodbc.sourceforge.net * 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. == Non-Relational Databases == |
| Line 22: | Line 51: |
| * ["BerkeleyDB"] * ["KirbyBase"] * ["Durus"] * ["atop"] * ["buzh ug"] |
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"] (a lso known as "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
ceODBC: http://ceodbc.sourceforge.net
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.