blob: 7835a5e21bd69d77b638265fb535d1a2409b29a5 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
|
.. _dialect_toplevel:
Dialects
========
The **dialect** is the system SQLAlchemy uses to communicate with various types of :term:`DBAPI` implementations and databases.
The sections that follow contain reference documentation and notes specific to the usage of each backend, as well as notes
for the various DBAPIs.
All dialects require that an appropriate DBAPI driver is installed.
Included Dialects
-----------------
.. toctree::
:maxdepth: 1
:glob:
drizzle
firebird
informix
mssql
mysql
oracle
postgresql
sqlite
sybase
.. _external_toplevel:
External Dialects
-----------------
.. versionchanged:: 0.8
As of SQLAlchemy 0.8, several dialects have been moved to external
projects, and dialects for new databases will also be published
as external projects. The rationale here is to keep the base
SQLAlchemy install and test suite from growing inordinately large.
The "classic" dialects such as SQLite, MySQL, Postgresql, Oracle,
SQL Server, and Firebird will remain in the Core for the time being.
Current external dialect projects for SQLAlchemy include:
Production Ready
^^^^^^^^^^^^^^^^
* `ibm_db_sa <http://code.google.com/p/ibm-db/wiki/README>`_ - driver for IBM DB2, developed jointly by IBM and SQLAlchemy developers.
* `sqlalchemy-sqlany <https://code.google.com/p/sqlalchemy-sqlany/>`_ - driver for SAP Sybase SQL Anywhere, developed by SAP.
* `sqlalchemy-monetdb <https://github.com/gijzelaerr/sqlalchemy-monetdb>`_ - driver for MonetDB.
Experimental / Incomplete
^^^^^^^^^^^^^^^^^^^^^^^^^^
* `sqlalchemy-access <https://bitbucket.org/zzzeek/sqlalchemy-access>`_ - driver for Microsoft Access.
* `CALCHIPAN <https://bitbucket.org/zzzeek/calchipan/>`_ - Adapts `Pandas <http://pandas.pydata.org/>`_ dataframes to SQLAlchemy.
* `sqlalchemy-akiban <https://github.com/zzzeek/sqlalchemy_akiban>`_ - driver and ORM extensions for the `Akiban <http://www.akiban.com>`_ database.
* `sqlalchemy-cubrid <https://bitbucket.org/zzzeek/sqlalchemy-cubrid>`_ - driver for the CUBRID database.
* `sqlalchemy-maxdb <https://bitbucket.org/zzzeek/sqlalchemy-maxdb>`_ - driver for the MaxDB database
|