62
62
information on current support.
63
63
* \* - indicates the given DBAPI is the "default" for SQLAlchemy, i.e. when just the database name is specified
65
========================= =========================== =========== =========== =========== ================= ============
66
Driver Connect string Py2K Py3K Jython Unix Windows
67
========================= =========================== =========== =========== =========== ================= ============
65
=============================================================== =========================== =========== =========== =========== ================= ============
66
Driver Connect string Py2K Py3K Jython Unix Windows
67
=============================================================== =========================== =========== =========== =========== ================= ============
68
68
**DB2/Informix IDS**
69
ibm-db_ thirdparty thirdparty thirdparty thirdparty thirdparty thirdparty
71
mysql-python_ ``drizzle+mysqldb``\* yes development no yes yes
72
**Firebird / Interbase**
73
kinterbasdb_ ``firebird+kinterbasdb``\* yes development no yes yes
75
informixdb_ ``informix+informixdb``\* yes development no unknown unknown
77
sapdb_ ``maxdb+sapdb``\* development development no yes unknown
79
pyodbc_ ``access+pyodbc``\* development development no unknown yes
80
**Microsoft SQL Server**
81
adodbapi_ ``mssql+adodbapi`` development development no no yes
82
`jTDS JDBC Driver`_ ``mssql+zxjdbc`` no no development yes yes
83
mxodbc_ ``mssql+mxodbc`` yes development no yes with FreeTDS_ yes
84
pyodbc_ ``mssql+pyodbc``\* yes development no yes with FreeTDS_ yes
85
pymssql_ ``mssql+pymssql`` yes development no yes yes
87
`MySQL Connector/J`_ ``mysql+zxjdbc`` no no yes yes yes
88
`MySQL Connector/Python`_ ``mysql+mysqlconnector`` yes development no yes yes
89
mysql-python_ ``mysql+mysqldb``\* yes development no yes yes
90
OurSQL_ ``mysql+oursql`` yes yes no yes yes
91
pymysql_ ``mysql+pymysql`` yes development no yes yes
93
cx_oracle_ ``oracle+cx_oracle``\* yes development no yes yes
94
`Oracle JDBC Driver`_ ``oracle+zxjdbc`` no no yes yes yes
96
pg8000_ ``postgresql+pg8000`` yes yes no yes yes
97
`PostgreSQL JDBC Driver`_ ``postgresql+zxjdbc`` no no yes yes yes
98
psycopg2_ ``postgresql+psycopg2``\* yes yes no yes yes
99
pypostgresql_ ``postgresql+pypostgresql`` no yes no yes yes
101
pysqlite_ ``sqlite+pysqlite``\* yes yes no yes yes
102
sqlite3_ ``sqlite+pysqlite``\* yes yes no yes yes
104
mxodbc_ ``sybase+mxodbc`` development development no yes yes
105
pyodbc_ ``sybase+pyodbc``\* partial development no unknown unknown
106
python-sybase_ ``sybase+pysybase`` yes [1]_ development no yes yes
107
========================= =========================== =========== =========== =========== ================= ============
69
ibm-db_ thirdparty thirdparty thirdparty thirdparty thirdparty thirdparty
70
**Drizzle** :ref:`(docs) <drizzle_toplevel>`
71
mysql-python_ ``drizzle+mysqldb``\* yes development no yes yes
72
**Firebird / Interbase** :ref:`(docs) <firebird_toplevel>`
73
kinterbasdb_ ``firebird+kinterbasdb``\* yes development no yes yes
74
**Informix** :ref:`(docs) <informix_toplevel>`
75
informixdb_ ``informix+informixdb``\* yes development no unknown unknown
76
**MaxDB** :ref:`(docs) <maxdb_toplevel>`
77
sapdb_ ``maxdb+sapdb``\* development development no yes unknown
78
**Microsoft Access** :ref:`(docs) <access_toplevel>`
79
pyodbc_ ``access+pyodbc``\* development development no unknown yes
80
**Microsoft SQL Server** :ref:`(docs) <mssql_toplevel>`
81
adodbapi_ ``mssql+adodbapi`` development development no no yes
82
`jTDS JDBC Driver`_ ``mssql+zxjdbc`` no no development yes yes
83
mxodbc_ ``mssql+mxodbc`` yes development no yes with FreeTDS_ yes
84
pyodbc_ ``mssql+pyodbc``\* yes development no yes with FreeTDS_ yes
85
pymssql_ ``mssql+pymssql`` yes development no yes yes
86
**MySQL** :ref:`(docs) <mysql_toplevel>`
87
`MySQL Connector/J`_ ``mysql+zxjdbc`` no no yes yes yes
88
`MySQL Connector/Python`_ ``mysql+mysqlconnector`` yes development no yes yes
89
mysql-python_ ``mysql+mysqldb``\* yes development no yes yes
90
OurSQL_ ``mysql+oursql`` yes yes no yes yes
91
pymysql_ ``mysql+pymysql`` yes development no yes yes
92
rdbms_ (Google Appengine) ``mysql+gaerdbms`` yes development no no no
93
**Oracle** :ref:`(docs) <oracle_toplevel>`
94
cx_oracle_ ``oracle+cx_oracle``\* yes development no yes yes
95
`Oracle JDBC Driver`_ ``oracle+zxjdbc`` no no yes yes yes
96
**Postgresql** :ref:`(docs) <postgresql_toplevel>`
97
pg8000_ ``postgresql+pg8000`` yes yes no yes yes
98
`PostgreSQL JDBC Driver`_ ``postgresql+zxjdbc`` no no yes yes yes
99
psycopg2_ ``postgresql+psycopg2``\* yes yes no yes yes
100
pypostgresql_ ``postgresql+pypostgresql`` no yes no yes yes
101
**SQLite** :ref:`(docs) <sqlite_toplevel>`
102
pysqlite_ ``sqlite+pysqlite``\* yes yes no yes yes
103
sqlite3_ ``sqlite+pysqlite``\* yes yes no yes yes
104
**Sybase ASE** :ref:`(docs) <sybase_toplevel>`
105
mxodbc_ ``sybase+mxodbc`` development development no yes yes
106
pyodbc_ ``sybase+pyodbc``\* partial development no unknown unknown
107
python-sybase_ ``sybase+pysybase`` yes [1]_ development no yes yes
108
=============================================================== =========================== =========== =========== =========== ================= ============
109
110
.. [1] The Sybase dialect currently lacks the ability to reflect tables.
110
111
.. _psycopg2: http://www.initd.org/