Choose Driver or ORM

Support level: Full

TiDB-JDBC is a customized Java driver based on MySQL 8.0.29. Compiled based on MySQL official version 8.0.29, TiDB-JDBC fixes the bug of multi-parameter and multi-field EOF in the prepare mode in the original JDBC, and adds features such as automatic TiCDC snapshot maintenance and the SM3 authentication plugin.

The authentication based on SM3 is only supported in TiDB's TiDB-JDBC.

If you use Maven, add the following content to the <dependencies></dependencies> section in the pom.xml file:

<dependency>
  <groupId>io.github.lastincisor</groupId>
  <artifactId>mysql-connector-java</artifactId>
  <version>8.0.29-tidb-1.0.0</version>
</dependency>

If you need to enable SM3 authentication, add the following content to the <dependencies></dependencies> section in the pom.xml file:

<dependency>
  <groupId>io.github.lastincisor</groupId>
  <artifactId>mysql-connector-java</artifactId>
  <version>8.0.29-tidb-1.0.0</version>
</dependency>
<dependency>
    <groupId>org.bouncycastle</groupId>
    <artifactId>bcprov-jdk15on</artifactId>
    <version>1.67</version>
</dependency>
<dependency>
    <groupId>org.bouncycastle</groupId>
    <artifactId>bcpkix-jdk15on</artifactId>
    <version>1.67</version>
</dependency>

If you use Gradle, add the following content to dependencies:

implementation group: 'io.github.lastincisor', name: 'mysql-connector-java', version: '8.0.29-tidb-1.0.0'
implementation group: 'org.bouncycastle', name: 'bcprov-jdk15on', version: '1.67'
implementation group: 'org.bouncycastle', name: 'bcpkix-jdk15on', version: '1.67'

Support level: Full

To avoid manually managing complex relationships between different dependencies of an application, you can use Gradle or Maven to get all dependencies of your application, including those indirect dependencies.

If you are using Maven, add the following to your <dependencies></dependencies>:

<dependency>
    <groupId>org.mybatis</groupId>
    <artifactId>mybatis</artifactId>
    <version>3.5.9</version>
</dependency>

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.49</version>
</dependency>

If you are using Gradle, add the following to your dependencies:

implementation 'org.mybatis:mybatis:3.5.9'
implementation 'mysql:mysql-connector-java:5.1.49'

For an example of using MyBatis to build a TiDB application, see Build a simple CRUD app with TiDB and MyBatis.

Support level: Compatible

You can follow the mysqlclient documentation to download and configure the driver. It is recommended to use mysqlclient 2.1.1 or later versions.

For an example of using mysqlclient to build a TiDB application, see Connect to TiDB with mysqlclient.

Support level: Compatible

You can follow the MySQL Connector/Python documentation to download and configure the driver. It is recommended to use Connector/Python 8.0.31 or later versions.

For an example of using MySQL Connector/Python to build a TiDB application, see Connect to TiDB with MySQL Connector/Python.

Support level: Full

SQLAlchemy is a popular ORM framework for Python. To get all dependencies in your application, you can use the pip install SQLAlchemy==1.4.44 command. It is recommended to use SQLAlchemy 1.4.44 or later versions.

For an example of using SQLAlchemy to build a TiDB application, see Connect to TiDB with SQLAlchemy.

Support level: Compatible

peewee is a popular ORM framework for Python. To get all dependencies in your application, you can use the pip install peewee==3.15.4 command. It is recommended to use peewee 3.15.4 or later versions.

For an example of using peewee to build a TiDB application, see Connect to TiDB with peewee.