SQLAlchemy 1.3 Documentation
SQLAlchemy 1.3 Documentation
- Overview
- SQLAlchemy ORM
- SQLAlchemy Core
- Dialects¶
- Frequently Asked Questions
- Error Messages
- Changes and Migration
Project Versions
- Previous: Core Internals
- Next: PostgreSQL
- Up: Home
- On this page:
Dialects¶
The dialect is the system SQLAlchemy uses to communicate with various types of 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¶
Included, but not currently supported dialects¶
The following dialects have implementations within SQLAlchemy, but they are not part of continuous integration testing nor are they actively developed. These dialects may be removed in future major releases.
External Dialects¶
Currently maintained external dialect projects for SQLAlchemy include:
Database |
Dialect |
---|---|
Amazon Redshift (via psycopg2) |
|
Apache Drill |
|
Apache Druid |
|
Apache Hive and Presto |
|
Apache Solr |
|
CockroachDB |
|
CrateDB |
|
EXASolution |
|
Elasticsearch (readonly) |
|
Firebird |
|
Google BigQuery |
|
Google Sheets |
|
IBM DB2 and Informix |
|
IBM Netezza Performance Server |
|
Microsoft Access (via pyodbc) |
|
Microsoft SQL Server (via python-tds) |
|
Microsoft SQL Server (via turbodbc) |
|
MonetDB |
|
SAP Hana |
|
SAP Sybase SQL Anywhere |
|
Snowflake |
|
Teradata Vantage |
flambé! the dragon and The Alchemist image designs created and generously donated by Rotem Yaari.
Created using Sphinx 7.2.6. Documentation last generated: Sat 06 Jan 2024 12:16:06 PM