Dialects¶
dialect 是 SQLAlchemy 用于与各种类型的 DBAPI 实现和数据库通信的系统。 接下来的部分包含每个后端使用的参考文档和特定说明,以及各种 DBAPI 的说明。
所有 dialect 都需要安装适当的 DBAPI 驱动程序。
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.
已包含的 dialect¶
Included Dialects
已包含的 dialect 支持的版本¶
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
External Dialects¶
目前维护的 SQLAlchemy 外部方言项目包括:
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 |