637
Comment:
|
1788
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: |
=== SQL Databases === | This page should help in choosing the right database system. |
Line 5: | Line 5: |
* ["DB/2"] | == 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 7: | Line 23: |
* ["Informix"] * ["Ingres"] * ["Firebird"] (and Interbase) * ["MySQL"] * ["Oracle"] * ["PostgreSQL"] * ["SAP DB"] * ["SQLite"] * ["SQL Server"] * ["Sybase"] * ["ThinkSQL"] * add new entries (choose Database''''''Template when creating the page) * other databases with Python support through ODBC or Jython support through JDBC |
* [[SQLite]] * [[ThinkSQL]] |
Line 21: | Line 26: |
See also DbApiModuleComparison | To add new entries (choose DatabaseTemplate when creating the page). |
Line 23: | Line 28: |
=== Other Databases === | == 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 * [[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. * 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 26: | Line 53: |
* ["ZODB"] * ["BerkeleyDB"] * ["KirbyBase"] * ["Durus"] * ["db star"] |
* [[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.