|
Size: 1242
Comment:
|
Size: 1788
Comment: converted to 1.6 markup
|
| 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. * ["MySQL"] * ["Oracle"] * ["PostgreSQL"] * ["SQLite"] * ["SQL Server"] |
This page should help in choosing the right database system. |
| Line 11: | Line 5: |
| ------ | == 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]] (also known as "MaxDB") * Microsoft [[SQL Server]] * [[Sybase]] The following database systems are more oriented towards embedded applications: |
| Line 14: | Line 23: |
| * ["Informix"] * ["Ingres"] * ["Firebird"] (and Interbase) * ["SAP DB"] * ["Sybase"] * ["ThinkSQL"] * add new entries (choose Database''''''Template when creating the page) |
* [[SQLite]] * [[ThinkSQL]] To add new entries (choose DatabaseTemplate when creating the page). == Database Interfaces and APIs == |
| Line 23: | Line 32: |
See also DbApiModuleComparison |
* See also DbApiModuleComparison |
| Line 28: | Line 36: |
| * pyodbc: http://pyodbc.sourceforge.net/ | * ceODBC: http://ceodbc.sourceforge.net |
| Line 30: | Line 38: |
| * mxODBC: http://www.egenix.com/products/python/mxODBC/ | * pyodbc: http://pyodbc.sourceforge.net |
| Line 32: | Line 40: |
| mxODBC provides ODBC connectivity on Windows, Mac OS X, FreeBSD and most other Unix platforms. | * [[http://www.egenix.com/products/python/mxODBC|mxODBC]]: A commercial Python extension that provides ODBC connectivity on Windows, Linux, Mac OS X, FreeBSD and many other Unix platforms. * [[http://www.egenix.com/products/python/mxODBCConnect|mxODBC Connect]]: A commercial client-server product that allows connecting Python to ODBC compatible databases running on remote servers without requiring an ODBC driver on the client side. |
| Line 40: | Line 50: |
| Line 44: | Line 53: |
| * ["ZODB"] * ["BerkeleyDB"] * ["KirbyBase"] * ["Durus"] * ["atop"] * ["buzhug"] |
* [[ZODB]] * [[BerkeleyDB]] * [[KirbyBase]] * [[Durus]] * [[atop]] * [[buzhug]] |
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)
SAP DB (also known as "MaxDB")
Microsoft SQL Server
The following database systems are more oriented towards embedded applications:
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: A commercial Python extension that provides ODBC connectivity on Windows, Linux, Mac OS X, FreeBSD and many other Unix platforms.
mxODBC Connect: A commercial client-server product that allows connecting Python to ODBC compatible databases running on remote servers without requiring an ODBC driver on the client side.
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.