SQLAlchemy 2.1 Documentation
- 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¶
Supported versions for Included Dialects¶
The following table summarizes the support level for each included dialect.
Database |
||
---|---|---|
Microsoft SQL Server |
2012+ |
2005+ |
MySQL / MariaDB |
5.6+ / 10+ |
5.0.2+ / 5.0.2+ |
Oracle Database |
11+ |
9+ |
PostgreSQL |
9.6+ |
9+ |
SQLite |
3.12+ |
3.7.16+ |
Support Definitions¶
- Supported version¶
Supported version indicates that most SQLAlchemy features should work for the mentioned database version. Since not all database versions may be tested in the ci there may be some not working edge cases.
- Best effort¶
Best effort indicates that SQLAlchemy tries to support basic features on these versions, but most likely there will be unsupported features or errors in some use cases. Pull requests with associated issues may be accepted to continue supporting older versions, which are reviewed on a case-by-case basis.
External Dialects¶
Currently maintained external dialect projects for SQLAlchemy include:
Database |
Dialect |
---|---|
Actian Data Platform, Vector, Actian X, Ingres |
|
Amazon Athena |
|
Amazon Redshift (via psycopg2) |
|
Apache Drill |
|
Apache Druid |
|
Apache Hive and Presto |
|
Apache Solr |
|
Clickhouse |
|
CockroachDB |
|
CrateDB |
|
Databend |
|
Databricks |
|
EXASolution |
|
Elasticsearch (readonly) |
|
Firebird |
|
Firebolt |
|
Google BigQuery |
|
Google Sheets |
|
Greenplum |
|
HyperSQL (hsqldb) |
|
IBM DB2 and Informix |
|
IBM Netezza Performance Server [1] |
|
Impala |
|
Kinetica |
|
Microsoft Access (via pyodbc) |
|
Microsoft SQL Server (via python-tds) |
|
Microsoft SQL Server (via turbodbc) |
|
MonetDB |
|
OpenGauss |
|
Rockset |
|
SAP ASE (fork of former Sybase dialect) |
|
SAP Hana [1] |
|
SAP Sybase SQL Anywhere |
|
Snowflake |
|
Teradata Vantage |
|
TiDB |
|
YDB |
|
YugabyteDB |
flambé! the dragon and The Alchemist image designs created and generously donated by Rotem Yaari.
Created using Sphinx 7.2.6. Documentation last generated: Thu 12 Dec 2024 05:32:02 PM EST